DBA Data[Home] [Help]

APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on EGO_OBJTYPE_ATTACH_CATS

Line 896: FROM ego_objtype_attach_cats

892: WHERE pk2_value = to_char(p_inventory_item_id)
893: AND pk1_value IN (SELECT to_Char(organization_id) FROM mtl_parameters WHERE master_organization_id=p_organization_id) /* Changed WHERE clause for the Bug 9094912 */
894: AND entity_name IN ('MTL_ITEM_REVISIONS','MTL_SYSTEM_ITEMS')
895: AND EXISTS (SELECT NULL
896: FROM ego_objtype_attach_cats
897: WHERE attach_category_id = docs.category_id
898: AND classification_code IN
899: (SELECT to_char(item_catalog_group_id)
900: FROM mtl_item_catalog_groups_b

Line 904: FROM ego_objtype_attach_cats

900: FROM mtl_item_catalog_groups_b
901: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
902: START WITH item_catalog_group_id = p_catalog_group_id))
903: AND NOT EXISTS (SELECT NULL
904: FROM ego_objtype_attach_cats
905: WHERE attach_category_id = docs.category_id
906: AND classification_code IN
907: (SELECT to_char(item_catalog_group_id)
908: FROM mtl_item_catalog_groups_b