AR_CM_BILL_SITE_USES_S_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

CM_BILL_SITE_CUST_CAT_CODE CM_BILL_SITE_CUST_ACCT_SITE_ID CM_BILL_SITE_GLOBAL_ATTR1 CM_BILL_SITE_GLOBAL_ATTR2 CM_BILL_SITE_GLOBAL_ATTR3 CM_BILL_SITE_GLOBAL_ATTR4 CM_BILL_SITE_GLOBAL_ATTR5 CM_BILL_SITE_GLOBAL_ATTR6 CM_BILL_SITE_GLOBAL_ATTR7 CM_BILL_SITE_GLOBAL_ATTR8 CM_BILL_SITE_GLOBAL_ATTR9 CM_BILL_SITE_GLOBAL_ATTR_CAT CM_BILL_SITE_TRNSL_CUST_NAME CM_BILL_USES_GLOBAL_ATTR1 CM_BILL_USES_GLOBAL_ATTR_CAT CM_BILL_USES_CLEARING_CCID CM_BILL_USES_FREIGHT_CCID CM_BILL_USES_REC_CCID CM_BILL_USES_REV_CCID CM_BILL_USES_TAX_CCID CM_BILL_USES_UNBILLED_CCID CM_BILL_USES_UNEARNED_CCID CM_BILL_USES_GSA_INDICATOR CM_BILL_USES_LOCATION CM_BILL_USES_SITE_USE_CODE CM_BILL_USES_SITE_USE_ID CM_BILL_USES_TAX_REFERENCE CM_BILL_SITE_PARTY_SITE_ID EVENT_ID LINE_NUMBER LEDGER_ID LANGUAGE

Query

SQL_Statement

SELECT casa7.customer_category_code cm_bill_site_cust_cat_code , casa7.cust_acct_site_id cm_bill_site_cust_acct_site_id , null cm_bill_site_global_attr1 , null cm_bill_site_global_attr2 , null cm_bill_site_global_attr3 , null cm_bill_site_global_attr4 , null cm_bill_site_global_attr5 , null cm_bill_site_global_attr6 , null cm_bill_site_global_attr7 , null cm_bill_site_global_attr8 , null cm_bill_site_global_attr9 , null cm_bill_site_global_attr_cat , casa7.translated_customer_name cm_bill_site_trnsl_cust_name , null cm_bill_uses_global_attr1 , null cm_bill_uses_global_attr_cat , refacc.CLEARING_CCID cm_bill_uses_clearing_ccid , refacc.FREIGHT_CCID cm_bill_uses_freight_ccid , refacc.REC_CCID cm_bill_uses_rec_ccid , refacc.REV_CCID cm_bill_uses_rev_ccid , refacc.TAX_CCID cm_bill_uses_tax_ccid , refacc.UNBILLED_CCID cm_bill_uses_unbilled_ccid , refacc.UNEARNED_CCID cm_bill_uses_unearned_ccid , csua6.gsa_indicator cm_bill_uses_gsa_indicator , csua6.location cm_bill_uses_location , csua6.site_use_code cm_bill_uses_site_use_code , csua6.site_use_id cm_bill_uses_site_use_id , null cm_bill_uses_tax_reference , casa7.party_site_id CM_BILL_SITE_PARTY_SITE_ID , he.event_id event_id , he.line_number line_number , he.ledger_id ledger_id , he.language language FROM hz_cust_site_uses_all csua6 , hz_cust_acct_sites_all casa7 , ar_xla_lines_extract he, AR_REF_ACCOUNTS_ALL refacc WHERE csua6.site_use_id = he.bill_site_use_id AND csua6.cust_acct_site_id = casa7.cust_acct_site_id AND refacc.SOURCE_REF_ACCOUNT_ID(+)= he.bill_site_use_id AND refacc.SOURCE_REF_TABLE(+)= 'HZ_CUST_SITE_USES_ALL' AND refacc.BU_ID(+) = he.org_id AND he.event_class_code = 'CREDIT_MEMO' AND he.level_flag = 'H'