DBA Data[Home] [Help]

APPS.CLN_SYNCITEM_PKG dependencies on HZ_PARTY_SITES

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'