VRM_SHIP_CUST_ACCT_SITES_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name
SHIP_CUST_SITE_USE_ID SHIP_CUST_SITE_ID SHIP_CUST_SITE_NAME SHIP_CUST_SITE_NUMBER SHIP_CUST_ACCOUNT_ID SHIP_CUST_ACCOUNT_NUMBER SHIP_CUST_ACCOUNT_NAME SHIP_CUST_TYPE SHIP_CUST_PARTY_ID SHIP_CUST_PARTY_NUMBER SHIP_CUST_PARTY_NAME SHIP_CUST_PARTY_TYPE SHIP_CUST_COUNTRY SHIP_CUST_STATE SHIP_CUST_COUNTY SHIP_CUST_CITY SHIP_CUST_POSTAL_CODE SHIP_CUST_PROVINCE SHIP_CUSTOMER_CLASS_CODE SHIP_CUST_ADDRESS

Query

SQL_Statement

SELECT csu.site_use_id ship_cust_site_use_id , casa1.cust_acct_site_id ship_cust_site_id , ps.party_site_name ship_cust_site_name , ps.party_site_number ship_cust_site_number , ca1.cust_account_id ship_cust_account_id , ca1.account_number ship_cust_account_number , ca1.account_name ship_cust_account_name, ca1.customer_type ship_cust_type , p1.party_id ship_cust_party_id , p1.party_number ship_cust_party_number , p1.party_name ship_cust_party_name , p1.party_type ship_cust_party_type , zl.country ship_cust_country , zl.state ship_cust_state , zl.county ship_cust_county , zl.city ship_cust_city , zl.postal_code ship_cust_postal_code , zl.province ship_cust_province , UPPER(ca1.customer_class_code) ship_customer_class_code , (zl.address1||','||zl.address2||','||zl.address3||','||zl.address4||','||zl.city ||','||zl.postal_code) ship_cust_address FROM hz_cust_site_uses_all csu , hz_cust_acct_sites_all casa1, hz_cust_accounts ca1 , hz_party_sites ps, hz_parties p1, hz_locations zl WHERE csu.site_use_code = 'SHIP_TO' AND csu.cust_acct_site_id = casa1.cust_acct_site_id AND casa1.cust_account_id = ca1.cust_account_id AND casa1.party_site_id = ps.party_site_id AND ps.party_id = p1.party_id AND ps.location_id = zl.location_id