VRM_BILL_CUST_ACCT_SITES

Details

Schema: FUSION
Object owner: VRM
Object type: VIEW

Columns

Name
BILL_CUST_SITE_USE_ID BILL_CUST_SITE_ID BILL_CUST_SITE_NAME BILL_CUST_SITE_NUMBER BILL_CUST_ACCOUNT_ID BILL_CUST_ACCOUNT_NUMBER BILL_CUST_ACCOUNT_NAME BILL_CUST_TYPE BILL_CUST_PARTY_ID BILL_CUST_PARTY_NUMBER BILL_CUST_PARTY_NAME BILL_CUST_PARTY_TYPE BILL_CUST_COUNTRY BILL_CUST_STATE BILL_CUST_COUNTY BILL_CUST_CITY BILL_CUST_POSTAL_CODE BILL_CUST_PROVINCE BILL_CUSTOMER_CLASS_CODE BILL_CUST_ADDRESS

Name

BILL_CUST_SITE_USE_ID

BILL_CUST_SITE_ID

BILL_CUST_SITE_NAME

BILL_CUST_SITE_NUMBER

BILL_CUST_ACCOUNT_ID

BILL_CUST_ACCOUNT_NUMBER

BILL_CUST_ACCOUNT_NAME

BILL_CUST_TYPE

BILL_CUST_PARTY_ID

BILL_CUST_PARTY_NUMBER

BILL_CUST_PARTY_NAME

BILL_CUST_PARTY_TYPE

BILL_CUST_COUNTRY

BILL_CUST_STATE

BILL_CUST_COUNTY

BILL_CUST_CITY

BILL_CUST_POSTAL_CODE

BILL_CUST_PROVINCE

BILL_CUSTOMER_CLASS_CODE

BILL_CUST_ADDRESS

Query

SQL_Statement
SELECT csu.site_use_id bill_cust_site_use_id , casa1.cust_acct_site_id bill_cust_site_id , ps.party_site_name bill_cust_site_name , ps.party_site_number bill_cust_site_number , ca1.cust_account_id bill_cust_account_id , ca1.account_number bill_cust_account_number , ca1.account_name bill_cust_account_name, ca1.customer_type bill_cust_type , p1.party_id bill_cust_party_id , p1.party_number bill_cust_party_number , p1.party_name bill_cust_party_name , p1.party_type bill_cust_party_type , zl.country bill_cust_country , zl.state bill_cust_state , zl.county bill_cust_county , zl.city bill_cust_city , zl.postal_code bill_cust_postal_code , zl.province bill_cust_province , UPPER(ca1.customer_class_code) bill_customer_class_code , (zl.address1\|\|','\|\|zl.address2\|\|','\|\|zl.address3\|\|','\|\|zl.address4\|\|','\|\|zl.city \|\|','\|\|zl.postal_code) bill_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 = 'BILL_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

SQL_Statement

SELECT csu.site_use_id bill_cust_site_use_id ,

casa1.cust_acct_site_id bill_cust_site_id ,

ps.party_site_name bill_cust_site_name ,

ps.party_site_number bill_cust_site_number ,

ca1.cust_account_id bill_cust_account_id ,

ca1.account_number bill_cust_account_number ,

ca1.account_name bill_cust_account_name,

ca1.customer_type bill_cust_type ,

p1.party_id bill_cust_party_id ,

p1.party_number bill_cust_party_number ,

p1.party_name bill_cust_party_name ,

p1.party_type bill_cust_party_type ,

zl.country bill_cust_country ,

zl.state bill_cust_state ,

zl.county bill_cust_county ,

zl.city bill_cust_city ,

zl.postal_code bill_cust_postal_code ,

zl.province bill_cust_province ,

UPPER(ca1.customer_class_code) bill_customer_class_code ,

(zl.address1||','||zl.address2||','||zl.address3||','||zl.address4||','||zl.city ||','||zl.postal_code) bill_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 = 'BILL_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