AR_BILL_TO_SITE_USES_S_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

BILL_SITE_CUST_CAT_CODE BILL_SITE_CUST_ACCT_SITE_ID BILL_SITE_GLOBAL_ATTR1 BILL_SITE_GLOBAL_ATTR2 BILL_SITE_GLOBAL_ATTR3 BILL_SITE_GLOBAL_ATTR4 BILL_SITE_GLOBAL_ATTR5 BILL_SITE_GLOBAL_ATTR6 BILL_SITE_GLOBAL_ATTR7 BILL_SITE_GLOBAL_ATTR8 BILL_SITE_GLOBAL_ATTR9 BILL_SITE_GLOBAL_ATTR_CAT BILL_SITE_TRNSL_CUST_NAME BILL_USES_GLOBAL_ATTR1 BILL_USES_GLOBAL_ATTR_CAT BILL_USES_CLEARING_CCID BILL_USES_FREIGHT_CCID BILL_USES_REC_CCID BILL_USES_REV_CCID BILL_USES_TAX_CCID BILL_USES_UNBILLED_CCID BILL_USES_UNEARNED_CCID BILL_USES_GSA_INDICATOR BILL_USES_LOCATION BILL_USES_SITE_USE_CODE BILL_USES_SITE_USE_ID BILL_TO_SITE BILL_USES_TAX_REFERENCE BILL_SITE_PARTY_SITE_ID EVENT_ID LINE_NUMBER LEDGER_ID BILL_SITE_USES_ATTR1 BILL_SITE_USES_ATTR2 BILL_SITE_USES_ATTR3 BILL_SITE_USES_ATTR4 BILL_SITE_USES_ATTR5 BILL_SITE_USES_ATTR6 BILL_SITE_USES_ATTR7 BILL_SITE_USES_ATTR8 BILL_SITE_USES_ATTR9 BILL_SITE_USES_ATTR10 BILL_SITE_USES_ATTR11 BILL_SITE_USES_ATTR12 BILL_SITE_USES_ATTR13 BILL_SITE_USES_ATTR14 BILL_SITE_USES_ATTR15 BILL_SITE_USES_ATTR_CAT BILL_SITE_ATTR1 BILL_SITE_ATTR2 BILL_SITE_ATTR3 BILL_SITE_ATTR4 BILL_SITE_ATTR5 BILL_SITE_ATTR6 BILL_SITE_ATTR7 BILL_SITE_ATTR8 BILL_SITE_ATTR9 BILL_SITE_ATTR10 BILL_SITE_ATTR11 BILL_SITE_ATTR12 BILL_SITE_ATTR13 BILL_SITE_ATTR14 BILL_SITE_ATTR15 BILL_SITE_ATTR_CAT

Query

SQL_Statement

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ bill_site_cust_cat_code , bill_site_cust_acct_site_id , bill_site_global_attr1 , bill_site_global_attr2 , bill_site_global_attr3 , bill_site_global_attr4 , bill_site_global_attr5 , bill_site_global_attr6 , bill_site_global_attr7 , bill_site_global_attr8 , bill_site_global_attr9 , bill_site_global_attr_cat , bill_site_trnsl_cust_name , bill_uses_global_attr1 , bill_uses_global_attr_cat , bill_uses_clearing_ccid , bill_uses_freight_ccid , bill_uses_rec_ccid , bill_uses_rev_ccid , bill_uses_tax_ccid , bill_uses_unbilled_ccid , bill_uses_unearned_ccid , bill_uses_gsa_indicator , bill_uses_location , bill_uses_site_use_code , bill_uses_site_use_id , BILL_TO_SITE , bill_uses_tax_reference , BILL_SITE_PARTY_SITE_ID , event_id , line_number , ledger_id , BILL_SITE_USES_ATTR1 , BILL_SITE_USES_ATTR2 , BILL_SITE_USES_ATTR3 , BILL_SITE_USES_ATTR4 , BILL_SITE_USES_ATTR5 , BILL_SITE_USES_ATTR6 , BILL_SITE_USES_ATTR7 , BILL_SITE_USES_ATTR8 , BILL_SITE_USES_ATTR9 , BILL_SITE_USES_ATTR10 , BILL_SITE_USES_ATTR11 , BILL_SITE_USES_ATTR12 , BILL_SITE_USES_ATTR13 , BILL_SITE_USES_ATTR14 , BILL_SITE_USES_ATTR15 , BILL_SITE_USES_ATTR_CAT , BILL_SITE_ATTR1 , BILL_SITE_ATTR2 , BILL_SITE_ATTR3 , BILL_SITE_ATTR4 , BILL_SITE_ATTR5 , BILL_SITE_ATTR6 , BILL_SITE_ATTR7 , BILL_SITE_ATTR8 , BILL_SITE_ATTR9 , BILL_SITE_ATTR10 , BILL_SITE_ATTR11 , BILL_SITE_ATTR12 , BILL_SITE_ATTR13 , BILL_SITE_ATTR14 , BILL_SITE_ATTR15 , BILL_SITE_ATTR_CAT FROM ar_bill_to_site_gt gt , ar_xla_lines_extract l WHERE gt.bill_uses_site_use_id = l.bill_site_use_id AND gt.org_id = l.org_id AND ((l.event_class_code IN ('INVOICE','DEBIT_MEMO','DEPOSIT', 'GUARANTEE','CHARGEBACK','ADJUSTMENT') AND l.level_flag = 'H') OR (l.event_class_code IN ('CREDIT_MEMO','RECEIPT') AND l.level_flag = 'L' AND l.from_to_flag = 'T'))