VRM_BILL_TO_CUSTOMERS_S_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name

BILL_CUST_ACCOUNT_NUMBER BILL_CUST_TYPE BILL_CUST_ACCOUNT_ID BILL_CUST_GLOBAL_ATTR1 BILL_CUST_GLOBAL_ATTR10 BILL_CUST_GLOBAL_ATTR12 BILL_CUST_GLOBAL_ATTR9 BILL_CUST_GLOBAL_ATTR_CAT BILL_CUST_NPA_NUMBER BILL_CUST_CAT_CODE BILL_CUST_CITY BILL_CUST_COUNTRY BILL_CUST_COUNTY BILL_CUST_GROUP_TYPE BILL_CUST_GSA_FLAG BILL_CUST_FISCAL_CODE BILL_CUST_PARTY_ID BILL_CUST_PARTY_NAME BILL_CUST_PARTY_NUMBER BILL_CUST_PARTY_TYPE BILL_CUST_POSTAL_CODE BILL_CUST_PROVINCE BILL_CUST_STATE BILL_CUST_TAX_REFERENCE EVENT_ID LINE_NUMBER LEDGER_ID BILL_CUSTOMER_CLASS_CODE

Query

SQL_Statement

SELECT /*+INDEX (l vrm_xla_lines_extract_n1)*/ ca1.account_number bill_cust_account_number , ca1.customer_type bill_cust_type , ca1.cust_account_id bill_cust_account_id , NULL bill_cust_global_attr1 , NULL bill_cust_global_attr10 , NULL bill_cust_global_attr12 , NULL bill_cust_global_attr9 , NULL bill_cust_global_attr_cat , ca1.npa_number bill_cust_npa_number , p1.category_code bill_cust_cat_code , p1.city bill_cust_city , p1.country bill_cust_country , p1.county bill_cust_county , p1.group_type bill_cust_group_type , p1.gsa_indicator_flag bill_cust_gsa_flag , p1.jgzz_fiscal_code bill_cust_fiscal_code , p1.party_id bill_cust_party_id , p1.party_name bill_cust_party_name , p1.party_number bill_cust_party_number , p1.party_type bill_cust_party_type , p1.postal_code bill_cust_postal_code , p1.province bill_cust_province , p1.state bill_cust_state , NULL bill_cust_tax_reference , l.event_id event_id , l.line_number line_number , l.ledger_id ledger_id , UPPER(ca1.customer_class_code) bill_customer_class_code FROM hz_cust_accounts ca1 , hz_parties p1 , vrm_xla_lines_extract_gt l WHERE ca1.cust_account_id = l.bill_customer_id AND ca1.party_id = p1.party_id