AR_CM_BILL_SITE_USES_H_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 BILL_TO_SITE CM_BILL_USES_TAX_REFERENCE CM_BILL_SITE_PARTY_SITE_ID LEDGER_ID EVENT_ID CM_BILL_SITE_USES_ATTR1 CM_BILL_SITE_USES_ATTR2 CM_BILL_SITE_USES_ATTR3 CM_BILL_SITE_USES_ATTR4 CM_BILL_SITE_USES_ATTR5 CM_BILL_SITE_USES_ATTR6 CM_BILL_SITE_USES_ATTR7 CM_BILL_SITE_USES_ATTR8 CM_BILL_SITE_USES_ATTR9 CM_BILL_SITE_USES_ATTR10 CM_BILL_SITE_USES_ATTR11 CM_BILL_SITE_USES_ATTR12 CM_BILL_SITE_USES_ATTR13 CM_BILL_SITE_USES_ATTR14 CM_BILL_SITE_USES_ATTR15 CM_BILL_SITE_USES_ATTR_CAT CM_BILL_SITE_ATTR1 CM_BILL_SITE_ATTR2 CM_BILL_SITE_ATTR3 CM_BILL_SITE_ATTR4 CM_BILL_SITE_ATTR5 CM_BILL_SITE_ATTR6 CM_BILL_SITE_ATTR7 CM_BILL_SITE_ATTR8 CM_BILL_SITE_ATTR9 CM_BILL_SITE_ATTR10 CM_BILL_SITE_ATTR11 CM_BILL_SITE_ATTR12 CM_BILL_SITE_ATTR13 CM_BILL_SITE_ATTR14 CM_BILL_SITE_ATTR15 CM_BILL_SITE_ATTR_CAT

Query

SQL_Statement

SELECT /*+INDEX(he ar_xla_lines_extract_n1) */ 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 , csua6.location bill_to_site , csua6.tax_reference cm_bill_uses_tax_reference , casa7.party_site_id CM_BILL_SITE_PARTY_SITE_ID , he.ledger_id ledger_id , he.event_id event_id , csua6.ATTRIBUTE1 CM_BILL_SITE_USES_ATTR1 , csua6.ATTRIBUTE2 CM_BILL_SITE_USES_ATTR2 , csua6.ATTRIBUTE3 CM_BILL_SITE_USES_ATTR3 , csua6.ATTRIBUTE4 CM_BILL_SITE_USES_ATTR4 , csua6.ATTRIBUTE5 CM_BILL_SITE_USES_ATTR5 , csua6.ATTRIBUTE6 CM_BILL_SITE_USES_ATTR6 , csua6.ATTRIBUTE7 CM_BILL_SITE_USES_ATTR7 , csua6.ATTRIBUTE8 CM_BILL_SITE_USES_ATTR8 , csua6.ATTRIBUTE9 CM_BILL_SITE_USES_ATTR9 , csua6.ATTRIBUTE10 CM_BILL_SITE_USES_ATTR10 , csua6.ATTRIBUTE11 CM_BILL_SITE_USES_ATTR11 , csua6.ATTRIBUTE12 CM_BILL_SITE_USES_ATTR12 , csua6.ATTRIBUTE13 CM_BILL_SITE_USES_ATTR13 , csua6.ATTRIBUTE14 CM_BILL_SITE_USES_ATTR14 , csua6.ATTRIBUTE15 CM_BILL_SITE_USES_ATTR15 , csua6.ATTRIBUTE_CATEGORY CM_BILL_SITE_USES_ATTR_CAT , casa7.ATTRIBUTE1 CM_BILL_SITE_ATTR1 , casa7.ATTRIBUTE2 CM_BILL_SITE_ATTR2 , casa7.ATTRIBUTE3 CM_BILL_SITE_ATTR3 , casa7.ATTRIBUTE4 CM_BILL_SITE_ATTR4 , casa7.ATTRIBUTE5 CM_BILL_SITE_ATTR5 , casa7.ATTRIBUTE6 CM_BILL_SITE_ATTR6 , casa7.ATTRIBUTE7 CM_BILL_SITE_ATTR7 , casa7.ATTRIBUTE8 CM_BILL_SITE_ATTR8 , casa7.ATTRIBUTE9 CM_BILL_SITE_ATTR9 , casa7.ATTRIBUTE10 CM_BILL_SITE_ATTR10 , casa7.ATTRIBUTE11 CM_BILL_SITE_ATTR11 , casa7.ATTRIBUTE12 CM_BILL_SITE_ATTR12 , casa7.ATTRIBUTE13 CM_BILL_SITE_ATTR13 , casa7.ATTRIBUTE14 CM_BILL_SITE_ATTR14 , casa7.ATTRIBUTE15 CM_BILL_SITE_ATTR15 , casa7.ATTRIBUTE_CATEGORY CM_BILL_SITE_ATTR_CAT 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 he.level_flag = 'H' 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_type_code IN ( 'CM_CREATE' , 'CM_UPDATE')