VIEW: APPS.ZPB_LEVELS_VL

Source

View Text - Preformatted

SELECT A.LEVEL_ID, A.DIMENSION_ID, B.NAME, A.EPB_ID, A.PERS_CWM_NAME, A.SHAR_CWM_NAME, A.PERS_LEVEL_FLAG, B.LONG_NAME, B.PLURAL_NAME, B.PLURAL_LONG_NAME, A.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM ZPB_LEVELS A, ZPB_LEVELS_TL B WHERE A.LEVEL_ID = B.LEVEL_ID (+) and B.LANGUAGE (+) = userenv('Lang')

View Text - HTML Formatted

SELECT A.LEVEL_ID
, A.DIMENSION_ID
, B.NAME
, A.EPB_ID
, A.PERS_CWM_NAME
, A.SHAR_CWM_NAME
, A.PERS_LEVEL_FLAG
, B.LONG_NAME
, B.PLURAL_NAME
, B.PLURAL_LONG_NAME
, A.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM ZPB_LEVELS A
, ZPB_LEVELS_TL B
WHERE A.LEVEL_ID = B.LEVEL_ID (+)
AND B.LANGUAGE (+) = USERENV('LANG')