DBA Data[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on FND_OBJECTS

Line 3847: -- FROM ego_obj_type_lifecycles olc, fnd_objects o

3843: --
3844: -- this code does not return the first catalog category id in the hierarchy
3845: --
3846: -- SELECT olc.object_classification_code
3847: -- FROM ego_obj_type_lifecycles olc, fnd_objects o
3848: -- WHERE o.obj_name = G_EGO_ITEM
3849: -- AND olc.object_id = o.object_id
3850: -- AND olc.lifecycle_id = cp_lifecycle_id
3851: -- AND olc.object_classification_code IN

Line 3865: FROM ego_obj_type_lifecycles olc, fnd_objects o

3861: FROM mtl_item_catalog_groups_b ic
3862: WHERE EXISTS
3863: (
3864: SELECT olc.object_classification_code CatalogId
3865: FROM ego_obj_type_lifecycles olc, fnd_objects o
3866: WHERE o.obj_name = 'EGO_ITEM'
3867: AND olc.object_id = o.object_id
3868: AND olc.lifecycle_id = cp_lifecycle_id
3869: AND olc.object_classification_code = to_char(ic.item_catalog_group_id)