DBA Data[Home] [Help]

APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on EGO_OBJTYPE_ATTACH_CATS

Line 840: FROM ego_objtype_attach_cats

836: DELETE fnd_attached_documents docs
837: WHERE pk2_value = to_char(p_inventory_item_id)
838: AND entity_name IN ('MTL_ITEM_REVISIONS','MTL_SYSTEM_ITEMS')
839: AND EXISTS (SELECT NULL
840: FROM ego_objtype_attach_cats
841: WHERE attach_category_id = docs.category_id
842: AND classification_code IN
843: (SELECT to_char(item_catalog_group_id)
844: FROM mtl_item_catalog_groups_b

Line 848: FROM ego_objtype_attach_cats

844: FROM mtl_item_catalog_groups_b
845: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
846: START WITH item_catalog_group_id = p_catalog_group_id))
847: AND NOT EXISTS (SELECT NULL
848: FROM ego_objtype_attach_cats
849: WHERE attach_category_id = docs.category_id
850: AND classification_code IN
851: (SELECT to_char(item_catalog_group_id)
852: FROM mtl_item_catalog_groups_b