View: CLN_ITEMMST_TRADING_PARTNERS_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View of the available trading partners
Implementation/DBA Data:	APPS.CLN_ITEMMST_TRADING_PARTNERS_V

View Text

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'

Columns