AR_CM_PAY_SITE_USES_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

CM_PAY_SITE_CUST_ACCT_SITE_ID CM_PAY_SITE_TRNSL_CUST_NAME CM_PAY_SITE_GSA_INDICATOR CM_PAY_SITE_LOCATION CM_PAY_SITE_SITE_USE_CODE CM_PAY_SITE_SITE_USE_ID CM_PAY_SITE_TAX_REFERENCE CM_PAY_SITE_CUST_CAT_CODE CM_PAY_SITE_GLOBAL_ATTR1 CM_PAY_SITE_GLOBAL_ATTR2 CM_PAY_SITE_GLOBAL_ATTR3 CM_PAY_SITE_GLOBAL_ATTR4 CM_PAY_SITE_GLOBAL_ATTR5 CM_PAY_SITE_GLOBAL_ATTR6 CM_PAY_SITE_GLOBAL_ATTR7 CM_PAY_SITE_GLOBAL_ATTR8 CM_PAY_SITE_GLOBAL_ATTR9 CM_PAY_SITE_GLOBAL_ATTR_CAT CM_PAY_SITE_PARTY_SITE_ID EVENT_ID LEDGER_ID

Query

SQL_Statement

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ casa3.cust_acct_site_id cm_pay_site_cust_acct_site_id , casa3.translated_customer_name cm_pay_site_trnsl_cust_name , csua3.gsa_indicator cm_pay_site_gsa_indicator , csua3.location cm_pay_site_location , csua3.site_use_code cm_pay_site_site_use_code , csua3.site_use_id cm_pay_site_site_use_id , csua3.tax_reference cm_pay_site_tax_reference , casa3.CUSTOMER_CATEGORY_CODE cm_pay_site_cust_cat_code , null cm_pay_site_global_attr1 , null cm_pay_site_global_attr2 , null cm_pay_site_global_attr3 , null cm_pay_site_global_attr4 , null cm_pay_site_global_attr5 , null cm_pay_site_global_attr6 , null cm_pay_site_global_attr7 , null cm_pay_site_global_attr8 , null cm_pay_site_global_attr9 , null cm_pay_site_global_attr_cat , casa3.party_site_id cm_pay_site_party_site_id , l.event_id event_id , l.ledger_id ledger_id FROM hz_cust_site_uses_all csua3 , hz_cust_acct_sites_all casa3 , ar_xla_lines_extract l 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