VIEW: APPS.WSH_CUSTOMER_SITES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)