View: PA_PERIOD_MASKS_VL

Product:	PA - Projects
Description:	MLS View for pa_period_masks_b and pa_period_masks_tl.
Implementation/DBA Data:	APPS.PA_PERIOD_MASKS_VL

View Text

SELECT T.ROWID ROW_ID
, B.PERIOD_MASK_ID
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.TIME_PHASE_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.RECORD_VERSION_NUMBER
, B.PRE_DEFINED_FLAG
, T.NAME
, T.DESCRIPTION
, T.LANGUAGE
FROM PA_PERIOD_MASKS_B B
, PA_PERIOD_MASKS_TL T
WHERE B.PERIOD_MASK_ID = T.PERIOD_MASK_ID
AND T.LANGUAGE = USERENV('LANG')

Columns