View: CLN_ITEMMST_CUSTOMER_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View for the customer section of the Sync Item XML message
Implementation/DBA Data:	APPS.CLN_ITEMMST_CUSTOMER_V

View Text

SELECT HP.PARTY_NAME PARTY_NAME
, ETH.PARTY_ID PARTY_ID
, ETD.EXTERNAL_TP_LOCATION_CODE CUSTOMER_PARTNRIDX
FROM ECX_TP_HEADERS ETH
, ECX_TP_DETAILS ETD
, ECX_EXT_PROCESSES EEP
, ECX_TRANSACTIONS ET
, HZ_PARTIES HP
WHERE ETH.TP_HEADER_ID = ETD.TP_HEADER_ID
AND ETH.PARTY_ID = HP.PARTY_ID
AND ETD.EXT_PROCESS_ID = EEP.EXT_PROCESS_ID
AND EEP.TRANSACTION_ID = ET.TRANSACTION_ID
AND ET.TRANSACTION_TYPE = 'CLN'
AND ET.TRANSACTION_SUBTYPE = 'SYNCITEMO'
AND EEP.DIRECTION = 'OUT'

Columns