VRM_BILL_TO_SITE_USES_S_V

Details

• Schema: FUSION

• Object owner: VRM

• 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_USES_TAX_REFERENCE BILL_SITE_PARTY_SITE_ID EVENT_ID LINE_NUMBER LEDGER_ID

Query

SQL_Statement

SELECT /*+INDEX(l vrm_xla_lines_extract_n1)*/ casa1.customer_category_code bill_site_cust_cat_code , casa1.cust_acct_site_id bill_site_cust_acct_site_id , NULL bill_site_global_attr1 , NULL bill_site_global_attr2 , NULL bill_site_global_attr3 , NULL bill_site_global_attr4 , NULL bill_site_global_attr5 , NULL bill_site_global_attr6 , NULL bill_site_global_attr7 , NULL bill_site_global_attr8 , NULL bill_site_global_attr9 , NULL bill_site_global_attr_cat , casa1.translated_customer_name bill_site_trnsl_cust_name , NULL bill_uses_global_attr1 , NULL bill_uses_global_attr_cat , refacc.CLEARING_CCID bill_uses_clearing_ccid , refacc.FREIGHT_CCID bill_uses_freight_ccid , refacc.REC_CCID bill_uses_rec_ccid , refacc.REV_CCID bill_uses_rev_ccid , refacc.TAX_CCID bill_uses_tax_ccid , refacc.UNBILLED_CCID bill_uses_unbilled_ccid , refacc.UNEARNED_CCID bill_uses_unearned_ccid , csua1.gsa_indicator bill_uses_gsa_indicator , csua1.location bill_uses_location , csua1.site_use_code bill_uses_site_use_code , csua1.site_use_id bill_uses_site_use_id , csua1.tax_reference bill_uses_tax_reference , casa1.party_site_id BILL_SITE_PARTY_SITE_ID , l.event_id event_id , l.line_number line_number , l.ledger_id ledger_id FROM hz_cust_site_uses_all csua1 , hz_cust_acct_sites_all casa1 , vrm_xla_lines_extract_gt l, AR_REF_ACCOUNTS refacc WHERE csua1.site_use_id = l.bill_site_use_id AND csua1.cust_acct_site_id = casa1.cust_acct_site_id AND (casa1.SET_ID = FND_SETID_UTILITY.GETSETID('HZ_CUSTOMER_ACCOUNT_SITE','BU', l.ORG_ID) OR casa1.SET_ID = 0) AND casa1.SET_ID = csua1.SET_ID AND refacc.SOURCE_REF_ACCOUNT_ID(+) = l.bill_site_use_id AND refacc.source_ref_table(+) = 'HZ_CUST_SITE_USES_ALL' AND refacc.bu_id(+) = l.org_id