AR_SOLD_TO_SITE_USES_S_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

SOLD_SITE_CUST_CAT_CODE SOLD_SITE_CUST_ACCT_SITE_ID SOLD_SITE_GLOBAL_ATTR1 SOLD_SITE_GLOBAL_ATTR2 SOLD_SITE_GLOBAL_ATTR3 SOLD_SITE_GLOBAL_ATTR4 SOLD_SITE_GLOBAL_ATTR5 SOLD_SITE_GLOBAL_ATTR6 SOLD_SITE_GLOBAL_ATTR7 SOLD_SITE_GLOBAL_ATTR8 SOLD_SITE_GLOBAL_ATTR9 SOLD_SITE_GLOBAL_ATTR_CAT SOLD_SITE_TRNSL_CUST_NAME SOLD_SITE_GSA_INDICATOR SOLD_SITE_LOCATION SOLD_SITE_SITE_USE_CODE SOLD_SITE_SITE_USE_ID SOLD_SITE_TAX_REFERENCE SOLD_USES_GLOBAL_ATTR1 SOLD_USES_GLOBAL_ATTR_CAT SOLD_USES_GSA_INDICATOR SOLD_USES_LOCATION SOLD_USES_SITE_USE_CODE SOLD_USES_SITE_USE_ID SOLD_USES_TAX_REFERENCE SOLD_SITE_PARTY_SITE_ID EVENT_ID LINE_NUMBER LEDGER_ID

Query

SQL_Statement

SELECT /*+INDEX (l ar_xla_lines_extract_n1)*/ casa4.customer_category_code sold_site_cust_cat_code , casa4.cust_acct_site_id sold_site_cust_acct_site_id , null sold_site_global_attr1 , null sold_site_global_attr2 , null sold_site_global_attr3 , null sold_site_global_attr4 , null sold_site_global_attr5 , null sold_site_global_attr6 , null sold_site_global_attr7 , null sold_site_global_attr8 , null sold_site_global_attr9 , null sold_site_global_attr_cat , casa4.translated_customer_name sold_site_trnsl_cust_name , csua4.gsa_indicator sold_site_gsa_indicator , csua4.location sold_site_location , csua4.site_use_code sold_site_site_use_code , csua4.site_use_id sold_site_site_use_id , csua4.tax_reference sold_site_tax_reference , null SOLD_USES_GLOBAL_ATTR1 , null SOLD_USES_GLOBAL_ATTR_CAT , csua4.gsa_indicator SOLD_USES_GSA_INDICATOR , csua4.location SOLD_USES_LOCATION , csua4.site_use_code SOLD_USES_SITE_USE_CODE , csua4.site_use_id SOLD_USES_SITE_USE_ID , csua4.tax_reference SOLD_USES_TAX_REFERENCE , casa4.party_site_id SOLD_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 csua4 , hz_cust_acct_sites_all casa4 , ar_xla_lines_extract l WHERE csua4.site_use_id = l.sold_site_use_id AND csua4.cust_acct_site_id = casa4.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'))