VIEW: APPS.ZPB_DIMENSIONS_VL

Source

View Text - Preformatted

SELECT A.DIMENSION_ID, A.BUS_AREA_ID, B.NAME, A.AW_NAME, A.DEFAULT_HIER, A.DEFAULT_MEMBER, A.DIM_CODE, A.DIM_TYPE, A.EPB_ID, A.IS_CURRENCY_DIM, A.IS_DATA_DIM, A.IS_OWNER_DIM, A.PERS_CWM_NAME, A.PERS_TABLE_ID, A.SHAR_CWM_NAME, A.SHAR_TABLE_ID, A.ANNOTATION_DIM, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN, B.PLURAL_NAME, B.PLURAL_LONG_NAME, B.NAME AS LONG_NAME FROM ZPB_DIMENSIONS A, ZPB_DIMENSIONS_TL B WHERE A.DIMENSION_ID = B.DIMENSION_ID and B.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT A.DIMENSION_ID
, A.BUS_AREA_ID
, B.NAME
, A.AW_NAME
, A.DEFAULT_HIER
, A.DEFAULT_MEMBER
, A.DIM_CODE
, A.DIM_TYPE
, A.EPB_ID
, A.IS_CURRENCY_DIM
, A.IS_DATA_DIM
, A.IS_OWNER_DIM
, A.PERS_CWM_NAME
, A.PERS_TABLE_ID
, A.SHAR_CWM_NAME
, A.SHAR_TABLE_ID
, A.ANNOTATION_DIM
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, B.PLURAL_NAME
, B.PLURAL_LONG_NAME
, B.NAME AS LONG_NAME
FROM ZPB_DIMENSIONS A
, ZPB_DIMENSIONS_TL B
WHERE A.DIMENSION_ID = B.DIMENSION_ID
AND B.LANGUAGE = USERENV('LANG')