Query to Connect Trading Partner header and TCA ( Suppliers) table

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

Cancel the remaining lines

When the user chooses cancel the remaining lines an attempt is made to cancel all lines that are unfulfilled and unshipped on the order, however if one line fails to cancel then it would fail the entire operation. This is not intended to cancel lines that are cancellable