View: PJI_MT_MEASURE_SETS_VL

Product:	PJI - Project Intelligence(Obsolete)
Description:	This table stores information about measure sets used for reporting in Oracle Projects
Implementation/DBA Data:	APPS.PJI_MT_MEASURE_SETS_VL

View Text

SELECT B.ROWID ROW_ID
, B.MEASURE_SET_CODE
, B.MEASURE_SET_TYPE
, B.MEASURE_FORMAT
, B.MEASURE_SOURCE
, B.MEASURE_FORMULA
, B.DB_COLUMN_NAME
, B.OBJECT_VERSION_NUMBER
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.NAME
, T.DESCRIPTION
FROM PJI_MT_MEASURE_SETS_B B
, PJI_MT_MEASURE_SETS_TL T
WHERE T.MEASURE_SET_CODE = B.MEASURE_SET_CODE
AND T.LANGUAGE = USERENV('LANG')

Columns