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_GTIN_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 2887: FROM MTL_ITEM_CATALOG_GROUPS_B

2883: and EXT.DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
2884: and EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
2885: and A.CLASSIFICATION_CODE IN
2886: ( SELECT ITEM_CATALOG_GROUP_ID
2887: FROM MTL_ITEM_CATALOG_GROUPS_B
2888: CONNECT BY PRIOR PARENT_CATALOG_GROUP_ID = ITEM_CATALOG_GROUP_ID
2889: START WITH ITEM_CATALOG_GROUP_ID = (select item_catalog_group_id
2890: from mtl_system_items_b
2891: where inventory_item_id = p_inventory_item_id

Line 3179: FROM mtl_item_catalog_groups_b mi

3175:
3176: -- Do a bulk collect for catalog groups without parent and without any UCCnet associations
3177: SELECT mi.item_catalog_group_id
3178: BULK COLLECT INTO l_CatalogGroupIds
3179: FROM mtl_item_catalog_groups_b mi
3180: WHERE mi.parent_catalog_group_id IS NULL
3181: AND NOT EXISTS
3182: (SELECT oa.attr_group_id
3183: FROM ego_obj_ag_assocs_b oa,