APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 875: FROM mtl_item_catalog_groups_b ic

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

Line 962: ' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV ICGKFV ' ||

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