[Home] [Help]
View: CLN_PROCAT_TRADING_PARTNERS_V
Product: | CLN - Supply Chain Trading Connector for RosettaNet |
Description: | View of the available trading partners |
Implementation/DBA Data: |
APPS.CLN_PROCAT_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 = 'SYNCCTLGO'
AND EEP.DIRECTION = 'OUT'
Columns
Name |
TRADING_PARTNER_NAME |
TP_HEADER_ID |