View: EGO_PAGE_ENTRIES_V

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

View Text

SELECT PE.PAGE_ID PAGE_ID
, PE.ASSOCIATION_ID ASSOCIATION_ID
, A.OBJECT_ID OBJECT_ID
, OTL.DISPLAY_NAME OBJECT_DISPLAY_NAME
, A.CLASSIFICATION_CODE CLASSIFICATION_CODE
, PE.CLASSIFICATION_CODE PAGE_ENTRY_CLASS_CODE
, PV.INTERNAL_NAME PAGE_INTERNAL_NAME
, PV.DISPLAY_NAME PAGE_DISPLAY_NAME
, PV.DATA_LEVEL_INT_NAME DATA_LEVEL_INT_NAME
, A.APPLICATION_ID ATTR_GRP_APPLICATION_ID
, A.ATTR_GROUP_TYPE ATTR_GROUP_TYPE
, A.ATTR_GROUP_NAME ATTR_GROUP_NAME
, A.ATTR_GROUP_DESCRIPTION ATTR_GROUP_DESCRIPTION
, PE.SEQUENCE SEQUENCE
FROM EGO_PAGES_V PV
, EGO_PAGE_ENTRIES_B PE
, EGO_OBJ_ATTR_GRP_ASSOCS_V A
, FND_OBJECTS_TL OTL
WHERE PE.PAGE_ID = PV.PAGE_ID
AND PE.ASSOCIATION_ID = A.ASSOCIATION_ID
AND A.OBJECT_ID = OTL.OBJECT_ID
AND OTL.LANGUAGE = USERENV('LANG')
AND A.ENABLED_CODE = 'Y'

Columns