1. Tables and Views for Project Management
  2. PJS_MT_MEASURES_VL

PJS_MT_MEASURES_VL

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: VIEW

Columns

Name

MEASURE_ID

MEASURE_SET_CODE

MEASURE_CODE

XTD_TYPE

MEASURE_FORMULA

TIMEVIEW_DIM

GRAPH_DISPLAY

GRAPH_TYPE

ENABLE_FLAG

DEFAULT_DISPLAY_FLAG

DEFAULT_COST_DISPLAY_FLAG

DEFAULT_CAPITAL_DISPLAY_FLAG

PROGRAM_ENABLED_FLAG

DEFAULT_PROGRAM_DISPLAY_FLAG

REST_ATTRIBUTE_NAME

APPLICABLE_FOR

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

BASE_MEASURE_ID_1

BASE_MEASURE_ID_2

MULTIPLIER

CALC_FORMULA_CODE

ADDL_ATTR_CHAR_1

ADDL_ATTR_CHAR_2

ADDL_ATTR_CHAR_3

ADDL_ATTR_CHAR_4

ADDL_ATTR_CHAR_5

NAME

DESCRIPTION

Query

SQL_Statement

SELECT

PJS_MT_MEASURES_B.MEASURE_ID MEASURE_ID,

PJS_MT_MEASURES_B.MEASURE_SET_CODE MEASURE_SET_CODE,

PJS_MT_MEASURES_B.MEASURE_CODE MEASURE_CODE,

PJS_MT_MEASURES_B.XTD_TYPE XTD_TYPE,

PJS_MT_MEASURES_B.MEASURE_FORMULA MEASURE_FORMULA,

PJS_MT_MEASURES_B.timeview_dim timeview_dim,

PJS_MT_MEASURES_B.Graph_display Graph_display,

PJS_MT_MEASURES_B.Graph_type Graph_type,

PJS_MT_MEASURES_B.Enable_Flag Enable_Flag,

PJS_MT_MEASURES_B.DEFAULT_DISPLAY_FLAG ,

PJS_MT_MEASURES_B.DEFAULT_COST_DISPLAY_FLAG ,

PJS_MT_MEASURES_B.DEFAULT_CAPITAL_DISPLAY_FLAG ,

PJS_MT_MEASURES_B.PROGRAM_ENABLED_FLAG,

PJS_MT_MEASURES_B.DEFAULT_PROGRAM_DISPLAY_FLAG,

PJS_MT_MEASURES_B.REST_ATTRIBUTE_NAME,

PJS_MT_MEASURES_B.APPLICABLE_FOR,

pJS_MT_MEASURES_B.CREATION_DATE CREATION_DATE,

PJS_MT_MEASURES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PJS_MT_MEASURES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

PJS_MT_MEASURES_B.CREATED_BY CREATED_BY,

PJS_MT_MEASURES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PJS_MT_MEASURES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PJS_MT_MEASURES_B.BASE_MEASURE_ID_1 BASE_MEASURE_ID_1,

PJS_MT_MEASURES_B.BASE_MEASURE_ID_2 BASE_MEASURE_ID_2,

PJS_MT_MEASURES_B.MULTIPLIER MULTIPLIER,

PJS_MT_MEASURES_B.CALC_FORMULA_CODE CALC_FORMULA_CODE,

PJS_MT_MEASURES_B.ADDL_ATTR_CHAR_1 ADDL_ATTR_CHAR_1,

PJS_MT_MEASURES_B.ADDL_ATTR_CHAR_2 ADDL_ATTR_CHAR_2,

PJS_MT_MEASURES_B.ADDL_ATTR_CHAR_3 ADDL_ATTR_CHAR_3,

PJS_MT_MEASURES_B.ADDL_ATTR_CHAR_4 ADDL_ATTR_CHAR_4,

PJS_MT_MEASURES_B.ADDL_ATTR_CHAR_5 ADDL_ATTR_CHAR_5,

PJS_MT_MEASURES_TL.NAME NAME,

PJS_MT_MEASURES_TL.DESCRIPTION DESCRIPTION

FROM

PJS_MT_MEASURES_B,

PJS_MT_MEASURES_TL

WHERE

PJS_MT_MEASURES_TL.MEASURE_ID = PJS_MT_MEASURES_B.MEASURE_ID AND PJS_MT_MEASURES_TL.LANGUAGE = USERENV('LANG')