DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on EGO_OBJ_TYPE_LIFECYCLES

Line 599: ' FROM ego_obj_type_lifecycles olc '||

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: ' ) '||

Line 738: FROM ego_obj_type_lifecycles olc, mtl_system_items_b MSI

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

Line 4599: FROM ego_obj_type_lifecycles olc, fnd_objects o

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