AR_CM_BILL_TO_CUST_S_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

CM_BILL_CUST_ACCOUNT_NUMBER CM_BILL_CUST_TYPE CM_BILL_CUST_ACCOUNT_ID CM_BILL_CUST_GLOBAL_ATTR1 CM_BILL_CUST_GLOBAL_ATTR10 CM_BILL_CUST_GLOBAL_ATTR12 CM_BILL_CUST_GLOBAL_ATTR9 CM_BILL_CUST_GLOBAL_ATTR_CAT CM_BILL_CUST_NPA_NUMBER CM_BILL_CUST_CAT_CODE CM_BILL_CUST_CITY CM_BILL_CUST_COUNTRY CM_BILL_CUST_COUNTY CM_BILL_CUST_GROUP_TYPE CM_BILL_CUST_GSA_FLAG CM_BILL_CUST_FISCAL_CODE CM_BILL_CUST_PARTY_ID CM_BILL_CUST_PARTY_NAME CM_BILL_CUST_PARTY_NUMBER CM_BILL_CUST_PARTY_TYPE CM_BILL_CUST_POSTAL_CODE CM_BILL_CUST_PROVINCE CM_BILL_CUST_STATE CM_BILL_CUST_TAX_REFERENCE EVENT_ID LINE_NUMBER LEDGER_ID LANGUAGE

Query

SQL_Statement

SELECT ca7.account_number cm_bill_cust_account_number , ca7.customer_type cm_bill_cust_type , ca7.cust_account_id cm_bill_cust_account_id , null cm_bill_cust_global_attr1 , null cm_bill_cust_global_attr10 , null cm_bill_cust_global_attr12 , null cm_bill_cust_global_attr9 , null cm_bill_cust_global_attr_cat , ca7.npa_number cm_bill_cust_npa_number , p7.category_code cm_bill_cust_cat_code , p7.city cm_bill_cust_city , p7.country cm_bill_cust_country , p7.county cm_bill_cust_county , p7.group_type cm_bill_cust_group_type , p7.gsa_indicator_flag cm_bill_cust_gsa_flag , p7.jgzz_fiscal_code cm_bill_cust_fiscal_code , p7.party_id cm_bill_cust_party_id , p7.party_name cm_bill_cust_party_name , p7.party_number cm_bill_cust_party_number , p7.party_type cm_bill_cust_party_type , p7.postal_code cm_bill_cust_postal_code , p7.province cm_bill_cust_province , p7.state cm_bill_cust_state , null cm_bill_cust_tax_reference , he.event_id event_id , he.line_number line_number , he.ledger_id ledger_id , he.language language FROM hz_cust_accounts ca7 , hz_parties p7 , ar_xla_lines_extract he WHERE ca7.cust_account_id = he.bill_customer_id AND he.level_flag = 'H' AND ca7.party_id = p7.party_id