AR_PAY_SITE_USES_S_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

PAY_SITE_CUST_ACCT_SITE_ID PAY_SITE_TRNSL_CUST_NAME PAY_SITE_GSA_INDICATOR PAY_SITE_LOCATION PAY_SITE_SITE_USE_CODE PAY_SITE_SITE_USE_ID PAY_SITE_TAX_REFERENCE PAY_SITE_CUST_CAT_CODE PAY_SITE_GLOBAL_ATTR1 PAY_SITE_GLOBAL_ATTR2 PAY_SITE_GLOBAL_ATTR3 PAY_SITE_GLOBAL_ATTR4 PAY_SITE_GLOBAL_ATTR5 PAY_SITE_GLOBAL_ATTR6 PAY_SITE_GLOBAL_ATTR7 PAY_SITE_GLOBAL_ATTR8 PAY_SITE_GLOBAL_ATTR9 PAY_SITE_GLOBAL_ATTR_CAT PAY_SITE_PARTY_SITE_ID EVENT_ID LINE_NUMBER LEDGER_ID

Query

SQL_Statement

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ casa3.cust_acct_site_id pay_site_cust_acct_site_id , casa3.translated_customer_name pay_site_trnsl_cust_name , csua3.gsa_indicator pay_site_gsa_indicator , csua3.location pay_site_location , csua3.site_use_code pay_site_site_use_code , csua3.site_use_id pay_site_site_use_id , csua3.tax_reference pay_site_tax_reference , casa3.CUSTOMER_CATEGORY_CODE PAY_SITE_CUST_CAT_CODE , null PAY_SITE_GLOBAL_ATTR1 , null PAY_SITE_GLOBAL_ATTR2 , null PAY_SITE_GLOBAL_ATTR3 , null PAY_SITE_GLOBAL_ATTR4 , null PAY_SITE_GLOBAL_ATTR5 , null PAY_SITE_GLOBAL_ATTR6 , null PAY_SITE_GLOBAL_ATTR7 , null PAY_SITE_GLOBAL_ATTR8 , null PAY_SITE_GLOBAL_ATTR9 , null PAY_SITE_GLOBAL_ATTR_CAT , casa3.party_site_id PAY_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 csua3 , hz_cust_acct_sites_all casa3 , ar_xla_lines_extract l WHERE csua3.site_use_id = l.paying_site_use_id AND csua3.cust_acct_site_id = casa3.cust_acct_site_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'))