VIEW: APPS.CLN_ITEMMST_TRADING_PARTNERS_V

Source

View Text - Preformatted

SELECT hp.party_name || ' ' || hl.address1 || ' ' || hl.address2 || '  '||hl.city ||' ' || hl.state || ' '|| hl.postal_code TRADING_PARTNER_NAME, eth.tp_header_id from ecx_tp_headers eth, ecx_tp_details etd, ecx_ext_processes eep, ecx_transactions et, hz_parties hp, hz_party_sites hps, hz_locations hl WHERE eth.tp_header_id = etd.tp_header_id and etd.EXT_PROCESS_ID = eep.EXT_PROCESS_ID and eth.party_id = hp.party_id and eth.party_site_id = hps.party_site_id and hps.location_id = hl.location_id and eep.transaction_id = et.transaction_id and et.transaction_type = 'CLN' and et.transaction_subtype = 'SYNCITEMO' and eep.direction = 'OUT'

View Text - HTML Formatted

SELECT HP.PARTY_NAME || ' ' || HL.ADDRESS1 || ' ' || HL.ADDRESS2 || ' '||HL.CITY ||' ' || HL.STATE || ' '|| HL.POSTAL_CODE TRADING_PARTNER_NAME
, ETH.TP_HEADER_ID
FROM ECX_TP_HEADERS ETH
, ECX_TP_DETAILS ETD
, ECX_EXT_PROCESSES EEP
, ECX_TRANSACTIONS ET
, HZ_PARTIES HP
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
WHERE ETH.TP_HEADER_ID = ETD.TP_HEADER_ID
AND ETD.EXT_PROCESS_ID = EEP.EXT_PROCESS_ID
AND ETH.PARTY_ID = HP.PARTY_ID
AND ETH.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND HPS.LOCATION_ID = HL.LOCATION_ID
AND EEP.TRANSACTION_ID = ET.TRANSACTION_ID
AND ET.TRANSACTION_TYPE = 'CLN'
AND ET.TRANSACTION_SUBTYPE = 'SYNCITEMO'
AND EEP.DIRECTION = 'OUT'