APPS.CLN_SYNCITEM_PKG dependencies on MTL_ITEM_CATALOG_GROUPS_KFV

Line 203: FROM mtl_item_catalog_groups_kfv micgk

199: )
200: AND ( p_catalog_category_id IS NULL OR
201: p_catalog_category_id IN
202: ( SELECT micgk.item_catalog_group_id
203: FROM mtl_item_catalog_groups_kfv micgk
204: WHERE micgk.item_catalog_group_id = CLN_ITEMMST_ITEMHEADER_V.item_catalog_group_id
205: )
206: )
207: AND ( p_item_status IS NULL OR

Line 359: FROM mtl_item_catalog_groups_kfv micgk

355: mic.organization_id = p_inventory_org_id )
356: )AND
357: ( p_catalog_category_id IS NULL OR p_catalog_category_id IN
358: ( SELECT micgk.item_catalog_group_id
359: FROM mtl_item_catalog_groups_kfv micgk
360: WHERE micgk.item_catalog_group_id = msib.item_catalog_group_id)
361: )AND
362: ( p_item_status IS NULL OR msib.INVENTORY_ITEM_STATUS_CODE = p_item_status)AND
363: ( msib.CONCATENATED_SEGMENTS >= NVL(l_from_items,msib.CONCATENATED_SEGMENTS) AND

Line 998: mtl_item_revisions mir, mtl_item_catalog_groups_kfv micgk, po_hazard_classes_tl phct

994: CURSOR c_DeletedItems
995: IS
996: SELECT distinct msib.concatenated_segments, msib.item_type, msib.primary_uom_code, mci.customer_item_number
997: FROM mtl_system_items_b_kfv msib, mtl_system_items_tl msit, mtl_customer_item_xrefs mcix, mtl_customer_items mci,
998: mtl_item_revisions mir, mtl_item_catalog_groups_kfv micgk, po_hazard_classes_tl phct
999: WHERE msib.inventory_item_id = msit.inventory_item_id(+) and msib.inventory_item_id = mcix.inventory_item_id(+)
1000: and mcix.customer_item_id = mci.customer_item_id(+) and msib.inventory_item_id = mir.inventory_item_id(+)
1001: and msit.organization_id = msib.organization_id and mir.organization_id = msib.organization_id
1002: and msib.service_item_flag = 'N' and msib.inventory_item_flag = 'Y'