View: EGO_PAGES_V

Product:	EGO - Advanced Product Catalog
Description:	View contains the User-Defined Pages
Implementation/DBA Data:	APPS.EGO_PAGES_V

View Text

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')

Columns