DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on EGO_OBJ_TYPE_LIFECYCLES

Line 733: FROM EGO_OBJ_TYPE_LIFECYCLES olc

729: (SELECT TO_CHAR(ic.item_catalog_group_id)
730: FROM mtl_item_catalog_groups_b ic
731: WHERE EXISTS
732: (SELECT olc.object_classification_code CatalogId
733: FROM EGO_OBJ_TYPE_LIFECYCLES olc
734: WHERE olc.object_id = (SELECT OBJECT_ID FROM fnd_objects WHERE obj_name = 'EGO_ITEM')
735: AND olc.lifecycle_id = ITEM_DTLS.lifecycle_id
736: AND olc.object_classification_code = ic.item_catalog_group_id)
737: AND ROWNUM = 1