AR_RCT_SITE_USES_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

RCT_SITE_CUST_ACCT_SITE_ID RCT_SITE_TRNSL_CUST_NAME RCT_SITE_GSA_INDICATOR RCT_SITE_LOCATION RCT_SITE_SITE_USE_CODE RCT_SITE_SITE_USE_ID BILL_TO_SITE RCT_SITE_TAX_REFERENCE RCT_SITE_CUST_CAT_CODE RCT_SITE_GLOBAL_ATTR1 RCT_SITE_GLOBAL_ATTR2 RCT_SITE_GLOBAL_ATTR3 RCT_SITE_GLOBAL_ATTR4 RCT_SITE_GLOBAL_ATTR5 RCT_SITE_GLOBAL_ATTR6 RCT_SITE_GLOBAL_ATTR7 RCT_SITE_GLOBAL_ATTR8 RCT_SITE_GLOBAL_ATTR9 RCT_SITE_GLOBAL_ATTR_CAT RCT_SITE_PARTY_SITE_ID EVENT_ID LEDGER_ID RCT_USES_CLEARING_CCID RCT_USES_FREIGHT_CCID RCT_USES_REC_CCID RCT_USES_REV_CCID RCT_USES_TAX_CCID RCT_USES_UNBILLED_CCID RCT_USES_UNEARNED_CCID

Query

SQL_Statement

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ casa3.cust_acct_site_id rct_site_cust_acct_site_id , casa3.translated_customer_name rct_site_trnsl_cust_name , csua3.gsa_indicator rct_site_gsa_indicator , csua3.location rct_site_location , csua3.site_use_code rct_site_site_use_code , csua3.site_use_id rct_site_site_use_id , csua3.location bill_to_site , csua3.tax_reference rct_site_tax_reference , casa3.CUSTOMER_CATEGORY_CODE rct_site_cust_cat_code , null rct_site_global_attr1 , null rct_site_global_attr2 , null rct_site_global_attr3 , null rct_site_global_attr4 , null rct_site_global_attr5 , null rct_site_global_attr6 , null rct_site_global_attr7 , null rct_site_global_attr8 , null rct_site_global_attr9 , null rct_site_global_attr_cat , casa3.party_site_id rct_site_party_site_id , l.event_id event_id , l.ledger_id ledger_id, refacc.clearing_ccid rct_uses_clearing_ccid , refacc.freight_ccid rct_uses_freight_ccid , refacc.rec_ccid rct_uses_rec_ccid , refacc.rev_ccid rct_uses_rev_ccid , refacc.tax_ccid rct_uses_tax_ccid , refacc.unbilled_ccid rct_uses_unbilled_ccid , refacc.unearned_ccid rct_uses_unearned_ccid FROM hz_cust_site_uses_all csua3 , hz_cust_acct_sites_all casa3 , ar_xla_lines_extract l, ar_ref_accounts_all refacc WHERE csua3.site_use_id = l.paying_site_use_id AND l.level_flag = 'H' AND csua3.cust_acct_site_id = casa3.cust_acct_site_id AND refacc.SOURCE_REF_ACCOUNT_ID(+) = csua3.site_use_id AND refacc.source_ref_table(+) = 'HZ_CUST_SITE_USES_ALL' AND refacc.bu_id(+) = l.org_id