DBA Data[Home] [Help]

APPS.EGO_ITEM_AML_PUB dependencies on FND_OBJECTS

Line 826: -- FROM ego_obj_type_lifecycles olc, fnd_objects o

822: --
823: -- this code does not return the first catalog category id in the hierarchy
824: --
825: -- SELECT olc.object_classification_code
826: -- FROM ego_obj_type_lifecycles olc, fnd_objects o
827: -- WHERE o.obj_name = G_EGO_ITEM
828: -- AND olc.object_id = o.object_id
829: -- AND olc.lifecycle_id = cp_lifecycle_id
830: -- AND olc.object_classification_code IN

Line 844: FROM ego_obj_type_lifecycles olc, fnd_objects o

840: FROM mtl_item_catalog_groups_b ic
841: WHERE EXISTS
842: (
843: SELECT olc.object_classification_code CatalogId
844: FROM ego_obj_type_lifecycles olc, fnd_objects o
845: WHERE o.obj_name = G_EGO_ITEM
846: AND olc.object_id = o.object_id
847: AND olc.lifecycle_id = cp_lifecycle_id
848: AND olc.object_classification_code = to_char(ic.item_catalog_group_id)