DBA Data[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on EGO_OBJ_TYPE_LIFECYCLES

Line 4095: -- FROM ego_obj_type_lifecycles olc, fnd_objects o

4091: --
4092: -- this code does not return the first catalog category id in the hierarchy
4093: --
4094: -- SELECT olc.object_classification_code
4095: -- FROM ego_obj_type_lifecycles olc, fnd_objects o
4096: -- WHERE o.obj_name = G_EGO_ITEM
4097: -- AND olc.object_id = o.object_id
4098: -- AND olc.lifecycle_id = cp_lifecycle_id
4099: -- AND olc.object_classification_code IN

Line 4113: FROM ego_obj_type_lifecycles olc, fnd_objects o

4109: FROM mtl_item_catalog_groups_b ic
4110: WHERE EXISTS
4111: (
4112: SELECT olc.object_classification_code CatalogId
4113: FROM ego_obj_type_lifecycles olc, fnd_objects o
4114: WHERE o.obj_name = 'EGO_ITEM'
4115: AND olc.object_id = o.object_id
4116: AND olc.lifecycle_id = cp_lifecycle_id
4117: AND olc.object_classification_code = to_char(ic.item_catalog_group_id)