APPS.CLN_SYNCITEM_PKG dependencies on HZ_PARTIES

Line 313: HZ_PARTIES HZP,

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,
316: AR_LOOKUPS ARL
317: WHERE mcix.customer_item_id = mci.customer_item_id AND

Line 704: ecx_transactions et, hz_parties hp, hz_party_sites hps, hz_locations hl

700: -- cursor to hold the list of trading partners to send to
701: CURSOR c_TradingPartners IS
702: select eth.tp_header_id
703: from ecx_tp_headers eth, ecx_tp_details etd, ecx_ext_processes eep,
704: ecx_transactions et, hz_parties hp, hz_party_sites hps, hz_locations hl
705: where eth.tp_header_id = etd.tp_header_id
706: and etd.EXT_PROCESS_ID = eep.EXT_PROCESS_ID and eth.party_id = hp.party_id
707: and eth.party_site_id = hps.party_site_id and hps.location_id = hl.location_id
708: and eep.transaction_id = et.transaction_id and et.transaction_type = 'CLN'