View: WSH_ITM_SYNC_PARTIES_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_ITM_SYNC_PARTIES_V

View Text

SELECT DISTINCT 'CARRIER' PARTY_TYPE
, HP.PARTY_NAME
, WC.FREIGHT_CODE
, WC.FREIGHT_CODE
FROM WSH_CARRIERS WC
, HZ_PARTIES HP
WHERE HP.PARTY_ID = WC.CARRIER_ID
AND HP.STATUS ='A' UNION SELECT DISTINCT 'CUSTOMER' PARTY_TYPE
, HP.PARTY_NAME
, HC.ACCOUNT_NUMBER
, TO_CHAR(HC.CUST_ACCOUNT_ID)
FROM HZ_PARTIES HP
, HZ_CUST_ACCOUNTS HC
WHERE HP.STATUS = 'A'
AND HP.PARTY_ID = HC.PARTY_ID

Columns