595: ' (SELECT TO_CHAR(ic.item_catalog_group_id) '||
596: ' FROM mtl_item_catalog_groups_b ic'||
597: ' WHERE EXISTS '||
598: ' ( SELECT olc.object_classification_code CatalogId '||
599: ' FROM ego_obj_type_lifecycles olc '||
600: ' WHERE olc.object_id = :3 '||
601: ' AND olc.lifecycle_id = MSI.lifecycle_id '||
602: ' AND olc.object_classification_code = ic.item_catalog_group_id '||
603: ' ) '||
734: FROM (SELECT item_catalog_group_id
735: FROM mtl_item_catalog_groups_b ic
736: WHERE EXISTS
737: ( SELECT olc.object_classification_code CatalogId
738: FROM ego_obj_type_lifecycles olc, mtl_system_items_b MSI
739: WHERE olc.object_id = l_object_id
740: AND olc.lifecycle_id = MSI.lifecycle_id
741: AND MSI.inventory_item_id = p_inventory_item_id
742: AND MSI.organization_id = p_organization_id
4595: FROM (SELECT item_catalog_group_id
4596: FROM mtl_item_catalog_groups_b ic
4597: WHERE EXISTS
4598: ( SELECT olc.object_classification_code CatalogId
4599: FROM ego_obj_type_lifecycles olc, fnd_objects o
4600: WHERE o.obj_name = G_EGO_ITEM
4601: AND olc.object_id = o.object_id
4602: AND olc.lifecycle_id = l_curr_lifecycle_id
4603: AND olc.object_classification_code = l_curr_cc_id