APPS.CLN_SYNCITEM_PKG dependencies on PO_HAZARD_CLASSES_TL

Line 311: po_hazard_classes_tl phct,

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 ,
315: HZ_CUST_ACCOUNTS HZC,

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'