Query to Connect Trading Partner header ( ecx_tp_header) table with TCA ( Suppliers) table
select eth.tp_header_id,eth.party_type,eth.party_id,eth.party_site_id,
pv.vendor_name, pvsa.vendor_site_code, pvsa.ece_tp_location_code, hp.party_name, hps.party_site_name
FROM
po_vendors pv,
po_vendor_sites_all pvsa,
ecx_tp_headers eth,
HZ_PARTY_SITES HPS,
HZ_PARTIES HP
WHERE HPS.PARTY_SITE_ID = pvsa.party_site_id
AND HPS.PARTY_ID = hp.PARTY_ID
AND HP.PARTY_ID = pv.party_id
AND eth.party_site_id = pvsa.vendor_site_id
AND eth.party_id = pv.vendor_id
AND pvsa.ece_tp_location_code is not null
AND pvsa.vendor_id = pv.vendor_id
nice
ReplyDelete