View: WSH_ITM_PARTY_NAMES_V

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

View Text

SELECT DISTINCT HU.ORGANIZATION_ID SOURCE_ID
, 'SHIP_FROM' SOURCE_TYPE
, HU.NAME PARTY_NAME
, NULL PARTY_NUMBER
FROM HR_ALL_ORGANIZATION_UNITS HU
, HR_LOCATIONS HL
, WSH_ITM_PARTIES WIP
WHERE WIP.PARTY_TYPE = 'SHIP_FROM'
AND HL.LOCATION_ID = HU.LOCATION_ID
AND HU.ORGANIZATION_ID = WIP.SOURCE_ORG_ID UNION SELECT DISTINCT CUST_ACCT.CUST_ACCOUNT_ID SOURCE_ID
, 'SOLD_TO' SORUCE_TYPE
, PARTY.PARTY_NAME PARTY_NAME
, PARTY.PARTY_NUMBER PARTY_NUMBER
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_LOCATIONS LOC
, HZ_PARTY_SITES PARTY_SITE
, WSH_ITM_PARTIES WIP
WHERE PARTY.PARTY_ID = CUST_ACCT.PARTY_ID
AND WIP.PARTY_TYPE = 'SOLD_TO'
AND CUST_ACCT.CUST_ACCOUNT_ID = WIP.SOURCE_ORG_ID
AND PARTY_SITE.PARTY_ID = PARTY.PARTY_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID UNION SELECT DISTINCT SITE_USES.SITE_USE_ID SOURCE_ID
, WIP.PARTY_TYPE SOURCE_TYPE
, PARTY.PARTY_NAME PARTY_NAME
, PARTY_SITE.PARTY_SITE_NUMBER PARTY_NUMBER
FROM HZ_CUST_SITE_USES_ALL SITE_USES
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_PARTIES PARTY
, HZ_LOCATIONS LOC
, WSH_ITM_PARTIES WIP
WHERE SITE_USES.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND PARTY_SITE.PARTY_ID = PARTY.PARTY_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND WIP.PARTY_TYPE IN ('BILL_TO'
, 'SHIP_TO'
, 'DELIVER_TO'
, 'INTERMED_SHIP_TO')
AND SITE_USES.SITE_USE_CODE = WIP.PARTY_TYPE
AND SITE_USES.SITE_USE_ID = WIP.SOURCE_ORG_ID

Columns