AR_SHIP_TO_SITE_USES_S_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

SHIP_SITE_CUST_CAT_CODE SHIP_SITE_CUST_ACCT_SITE_ID SHIP_SITE_GLOBAL_ATTR1 SHIP_SITE_GLOBAL_ATTR2 SHIP_SITE_GLOBAL_ATTR3 SHIP_SITE_GLOBAL_ATTR4 SHIP_SITE_GLOBAL_ATTR5 SHIP_SITE_GLOBAL_ATTR6 SHIP_SITE_GLOBAL_ATTR7 SHIP_SITE_GLOBAL_ATTR8 SHIP_SITE_GLOBAL_ATTR9 SHIP_SITE_GLOBAL_ATTR_CAT SHIP_SITE_TRNSL_CUST_NAME SHIP_SITE_GSA_INDICATOR SHIP_SITE_LOCATION SHIP_SITE_SITE_USE_CODE SHIP_SITE_SITE_USE_ID SHIP_SITE_TAX_REFERENCE SHIP_USES_GLOBAL_ATTR1 SHIP_USES_GLOBAL_ATTR_CAT SHIP_USES_GSA_INDICATOR SHIP_USES_LOCATION SHIP_USES_SITE_USE_CODE SHIP_USES_SITE_USE_ID SHIP_USES_TAX_REFERENCE SHIP_CUST_TAXPAYER_ID SHIP_SITE_PARTY_SITE_ID EVENT_ID LINE_NUMBER LEDGER_ID

Query

SQL_Statement

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ null ship_site_cust_cat_code , null ship_site_cust_acct_site_id , null ship_site_global_attr1 , null ship_site_global_attr2 , null ship_site_global_attr3 , null ship_site_global_attr4 , null ship_site_global_attr5 , null ship_site_global_attr6 , null ship_site_global_attr7 , null ship_site_global_attr8 , null ship_site_global_attr9 , null ship_site_global_attr_cat , null ship_site_trnsl_cust_name , null ship_site_gsa_indicator , p_site.party_site_number ship_site_location , p_uses.site_use_type ship_site_site_use_code , p_uses.party_site_use_id ship_site_site_use_id , null ship_site_tax_reference , null SHIP_USES_GLOBAL_ATTR1 , null SHIP_USES_GLOBAL_ATTR_CAT , null SHIP_USES_GSA_INDICATOR , p_site.party_site_number SHIP_USES_LOCATION , p_uses.site_use_type SHIP_USES_SITE_USE_CODE , p_uses.party_site_use_id SHIP_USES_SITE_USE_ID , null SHIP_USES_TAX_REFERENCE , p5.jgzz_fiscal_code SHIP_CUST_TAXPAYER_ID, p_site.party_site_id SHIP_SITE_PARTY_SITE_ID , l.event_id event_id , l.line_number line_number , l.ledger_id ledger_id FROM hz_party_site_uses p_uses , hz_party_sites p_site , hz_parties p5, ar_xla_lines_extract l WHERE p_uses.party_site_use_id = l.ship_site_use_id AND p_site.party_site_id = p_uses.party_site_id AND p5.party_id = p_site.party_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'))