VIEW: APPS.WSH_ITM_SYNC_PARTIES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')