APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 874: FROM mtl_item_catalog_groups_b ic

870: IF l_lifecycle_id IS NOT NULL AND l_catalog_id IS NOT NULL THEN
871: BEGIN
872: SELECT ic.item_catalog_group_id
873: INTO l_hier_catalog_id
874: FROM mtl_item_catalog_groups_b ic
875: WHERE EXISTS
876: (SELECT olc.object_classification_code CatalogId
877: FROM ego_obj_type_lifecycles olc
878: WHERE olc.object_id = (select object_id from fnd_objects where obj_name = 'EGO_ITEM')

Line 961: ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV ICGKFV ' ||

957: ' AND UOMTL.BASE_UOM_FLAG = ''Y''' ||
958: ' AND UOMTL.UOM_CLASS = :1 ';
959:
960: l_p_atr_sql('ITEM_CATALOG_GROUP_ID') := ' SELECT ICGKFV.CONCATENATED_SEGMENTS ' ||
961: ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV ICGKFV ' ||
962: ' WHERE ICGKFV.ITEM_CATALOG_GROUP_ID = ' ;
963: l_p_atr_sql('CURRENT_PHASE_ID') := ' SELECT LCP.NAME '||
964: ' FROM PA_EGO_LIFECYCLES_PHASES_V LCP '||
965: ' WHERE LCP.OBJECT_TYPE = ''PA_TASKS'' '||