View: WSH_CUSTOMER_SITES_V

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

View Text

SELECT HP.DUNS_NUMBER
, HPS.PARTY_SITE_NUMBER
, HPS.LOCATION_ID
, HCA.CUST_ACCOUNT_ID CUSTOMER_ID
, SUBSTRB(HP.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HCA.STATUS CUSTOMER_STATUS
, HCAS.CUST_ACCT_SITE_ID ADDRESS_ID
, HCAS.TP_HEADER_ID TP_HEADER_ID
, HCAS.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, HCAS.ECE_TP_LOCATION_CODE TP_LOCATION_CODE_EXT
, HCAS.STATUS CUST_ACCT_SITE_STATUS
, HCSU.SITE_USE_ID SITE_USE_ID
, HCSU.SITE_USE_CODE SITE_USE_CODE
, HCSU.LOCATION LOCATION
, HCSU.GSA_INDICATOR
, HCSU.STATUS SITE_USE_STATUS
, HCSU.PRIMARY_FLAG
, HCAS.ORG_ID
FROM HZ_PARTIES HP
, HZ_CUST_ACCOUNTS HCA
, HZ_CUST_SITE_USES_ALL HCSU
, HZ_CUST_ACCT_SITES_ALL HCAS
, HZ_PARTY_SITES HPS
WHERE HCA.CUST_ACCOUNT_ID = HCAS.CUST_ACCOUNT_ID
AND HCA.PARTY_ID = HP.PARTY_ID
AND HP.PARTY_ID = HPS.PARTY_ID
AND HCAS.PARTY_SITE_ID =HPS.PARTY_SITE_ID
AND HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
AND NVL( HCSU.ORG_ID
, -999) = NVL( HCAS.ORG_ID
, -999)

Columns