eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_PAGES_BULKLOAD_PVT dependencies on EGO_ITEM_CAT_DENORM_HIER

Line 371: AND classification_code IN ( SELECT PARENT_CATALOG_GROUP_ID FROM EGO_ITEM_CAT_DENORM_HIER

367: SET page_id = (SELECT page_id
368: FROM ego_pages_b
369: WHERE object_id = G_OBJECT_ID
370: AND internal_name = epi.internal_name
371: AND classification_code IN ( SELECT PARENT_CATALOG_GROUP_ID FROM EGO_ITEM_CAT_DENORM_HIER
372: WHERE CHILD_CATALOG_GROUP_ID = epi.classification_code)),
373: last_updated_by = G_USER_ID,
374: last_update_date = SYSDATE,
375: last_update_login = G_LOGIN_ID

Line 436: FROM EGO_ITEM_CAT_DENORM_HIER

432: UPDATE ego_page_entries_interface epi
433: SET old_association_id = (SELECT association_id
434: FROM EGO_OBJ_AG_ASSOCS_B
435: WHERE classification_code IN ( SELECT PARENT_CATALOG_GROUP_ID
436: FROM EGO_ITEM_CAT_DENORM_HIER
437: WHERE CHILD_CATALOG_GROUP_ID = epi.classification_code)
438: AND attr_group_id = epi.old_attr_group_id
439: AND data_level = (SELECT data_level
440: FROM ego_pages_b

Line 461: FROM EGO_ITEM_CAT_DENORM_HIER

457: UPDATE ego_page_entries_interface epi
458: SET new_association_id = (SELECT association_id
459: FROM EGO_OBJ_AG_ASSOCS_B
460: WHERE classification_code IN ( SELECT PARENT_CATALOG_GROUP_ID
461: FROM EGO_ITEM_CAT_DENORM_HIER
462: WHERE CHILD_CATALOG_GROUP_ID = epi.classification_code)
463: AND attr_group_id = epi.new_attr_group_id
464: AND data_level = (SELECT data_level
465: FROM ego_pages_b