DBA Data[Home] [Help]

APPS.CLN_SYNCITEM_PKG dependencies on MTL_ITEM_REVISIONS

Line 310: mtl_customer_item_xrefs mcix, -- mtl_item_revisions mir,

306: -- Modified the query below due to performance hit. Bug #4946778
307:
308: SELECT 'x' into l_dummy_check FROM dual
309: WHERE EXISTS (SELECT 'X' FROM mtl_system_items_b_kfv msib, --mtl_system_items_vl msib,
310: mtl_customer_item_xrefs mcix, -- mtl_item_revisions mir,
311: po_hazard_classes_tl phct,
312: MTL_CUSTOMER_ITEMS MCI,
313: HZ_PARTIES HZP,
314: MFG_LOOKUPS MFL ,

Line 333: --mir.revision = (SELECT MAX (revision) FROM mtl_item_revisions WHERE inventory_item_id = mir.inventory_item_id AND

329: msib.hazard_class_id = phct.hazard_class_id(+) AND
330: MCI.CUSTOMER_ID = HZC.CUST_ACCOUNT_ID AND
331: MCI.ITEM_DEFINITION_LEVEL = MFL.LOOKUP_CODE AND
332: MFL.LOOKUP_TYPE = 'INV_ITEM_DEFINITION_LEVEL' AND
333: --mir.revision = (SELECT MAX (revision) FROM mtl_item_revisions WHERE inventory_item_id = mir.inventory_item_id AND
334: --organization_id = mir.organization_id) AND
335: phct.LANGUAGE(+) = USERENV ('lang') AND
336: ARL.ENABLED_FLAG(+) = 'Y' AND
337: ARL.LOOKUP_TYPE(+) = 'ADDRESS_CATEGORY' 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'