VIEW: APPS.EGO_PAGE_ENTRIES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'