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
, WC.CARRIER_NAME
, WC.FREIGHT_CODE
, WC.FREIGHT_CODE
FROM WSH_CARRIERS_V WC
WHERE WC.ACTIVE ='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 HC.STATUS = 'A'
AND HP.PARTY_ID = HC.PARTY_ID UNION SELECT DISTINCT PARTY_TYPE
, HP.PARTY_NAME
, HP.PARTY_NUMBER
, TO_CHAR(HP.PARTY_ID)
FROM HZ_PARTIES HP
WHERE HP.STATUS IN ('A'
, 'M'
, 'D')

Columns