VIEW: APPS.EGO_PAGES_V

Source

View Text - Preformatted

SELECT B.PAGE_ID AS PAGE_ID , B.OBJECT_ID AS OBJECT_ID , O.OBJ_NAME AS OBJECT_NAME , B.CLASSIFICATION_CODE AS CLASSIFICATION_CODE , B.DATA_LEVEL AS DATA_LEVEL_INT_NAME , DL_VL.USER_DATA_LEVEL_NAME AS DATA_LEVEL_DISP_NAME , B.INTERNAL_NAME AS INTERNAL_NAME , TL.DISPLAY_NAME AS DISPLAY_NAME , TL.DESCRIPTION AS DESCRIPTION , B.SEQUENCE AS SEQUENCE FROM EGO_PAGES_B B , EGO_PAGES_TL TL , (SELECT DISTINCT DATA_LEVEL_NAME, USER_DATA_LEVEL_NAME FROM EGO_DATA_LEVEL_VL) DL_VL, FND_OBJECTS O WHERE B.PAGE_ID = TL.PAGE_ID AND B.OBJECT_ID= O.OBJECT_ID AND DL_VL.DATA_LEVEL_NAME = B.DATA_LEVEL AND TL.LANGUAGE= USERENV('LANG')

View Text - HTML Formatted

SELECT B.PAGE_ID AS PAGE_ID
, B.OBJECT_ID AS OBJECT_ID
, O.OBJ_NAME AS OBJECT_NAME
, B.CLASSIFICATION_CODE AS CLASSIFICATION_CODE
, B.DATA_LEVEL AS DATA_LEVEL_INT_NAME
, DL_VL.USER_DATA_LEVEL_NAME AS DATA_LEVEL_DISP_NAME
, B.INTERNAL_NAME AS INTERNAL_NAME
, TL.DISPLAY_NAME AS DISPLAY_NAME
, TL.DESCRIPTION AS DESCRIPTION
, B.SEQUENCE AS SEQUENCE
FROM EGO_PAGES_B B
, EGO_PAGES_TL TL
, (SELECT DISTINCT DATA_LEVEL_NAME
, USER_DATA_LEVEL_NAME
FROM EGO_DATA_LEVEL_VL) DL_VL
, FND_OBJECTS O
WHERE B.PAGE_ID = TL.PAGE_ID
AND B.OBJECT_ID= O.OBJECT_ID
AND DL_VL.DATA_LEVEL_NAME = B.DATA_LEVEL
AND TL.LANGUAGE= USERENV('LANG')