VIEW: APPS.ZPB_HIERARCHIES_VL

Source

View Text - Preformatted

SELECT A.HIERARCHY_ID, A.DIMENSION_ID, B.NAME, A.EPB_ID, A.HIER_TYPE, A.PERS_CWM_NAME, A.SHAR_CWM_NAME, A.PERS_TABLE_ID, A.SHAR_TABLE_ID, B.LONG_NAME, B.PLURAL_NAME, B.PLURAL_LONG_NAME, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN FROM ZPB_HIERARCHIES A, ZPB_HIERARCHIES_TL B WHERE A.HIERARCHY_ID = B.HIERARCHY_ID (+) and B.LANGUAGE (+) = userenv('Lang')

View Text - HTML Formatted

SELECT A.HIERARCHY_ID
, A.DIMENSION_ID
, B.NAME
, A.EPB_ID
, A.HIER_TYPE
, A.PERS_CWM_NAME
, A.SHAR_CWM_NAME
, A.PERS_TABLE_ID
, A.SHAR_TABLE_ID
, B.LONG_NAME
, B.PLURAL_NAME
, B.PLURAL_LONG_NAME
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM ZPB_HIERARCHIES A
, ZPB_HIERARCHIES_TL B
WHERE A.HIERARCHY_ID = B.HIERARCHY_ID (+)
AND B.LANGUAGE (+) = USERENV('LANG')