AR_CM_SHIP_TO_SITE_USES_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

CM_SHIP_SITE_CUST_CAT_CODE CM_SHIP_SITE_CUST_ACCT_SITE_ID CM_SHIP_SITE_GLOBAL_ATTR1 CM_SHIP_SITE_GLOBAL_ATTR2 CM_SHIP_SITE_GLOBAL_ATTR3 CM_SHIP_SITE_GLOBAL_ATTR4 CM_SHIP_SITE_GLOBAL_ATTR5 CM_SHIP_SITE_GLOBAL_ATTR6 CM_SHIP_SITE_GLOBAL_ATTR7 CM_SHIP_SITE_GLOBAL_ATTR8 CM_SHIP_SITE_GLOBAL_ATTR9 CM_SHIP_SITE_GLOBAL_ATTR_CAT CM_SHIP_SITE_TRNSL_CUST_NAME CM_SHIP_SITE_GSA_INDICATOR CM_SHIP_SITE_LOCATION CM_SHIP_SITE_SITE_USE_CODE CM_SHIP_SITE_SITE_USE_ID CM_SHIP_SITE_TAX_REFERENCE CM_SHIP_USES_GLOBAL_ATTR1 CM_SHIP_USES_GLOBAL_ATTR_CAT CM_SHIP_USES_GSA_INDICATOR CM_SHIP_USES_LOCATION CM_SHIP_USES_SITE_USE_CODE CM_SHIP_USES_SITE_USE_ID CM_SHIP_USES_TAX_REFERENCE CM_SHIP_SITE_PARTY_SITE_ID CM_SHIP_CUST_TAXPAYER_ID LEDGER_ID EVENT_ID

Query

SQL_Statement

SELECT /*+INDEX(he ar_xla_lines_extract_n1)*/ null cm_ship_site_cust_cat_code , null cm_ship_site_cust_acct_site_id , null cm_ship_site_global_attr1 , null cm_ship_site_global_attr2 , null cm_ship_site_global_attr3 , null cm_ship_site_global_attr4 , null cm_ship_site_global_attr5 , null cm_ship_site_global_attr6 , null cm_ship_site_global_attr7 , null cm_ship_site_global_attr8 , null cm_ship_site_global_attr9 , null cm_ship_site_global_attr_cat , null cm_ship_site_trnsl_cust_name , null cm_ship_site_gsa_indicator , casa10.party_site_number cm_ship_site_location , csua9.site_use_type cm_ship_site_site_use_code , csua9.party_site_use_id cm_ship_site_site_use_id , null cm_ship_site_tax_reference , null CM_SHIP_USES_GLOBAL_ATTR1 , null CM_SHIP_USES_GLOBAL_ATTR_CAT , null CM_SHIP_USES_GSA_INDICATOR , null CM_SHIP_USES_LOCATION , csua9.site_use_type CM_SHIP_USES_SITE_USE_CODE , csua9.party_site_use_id CM_SHIP_USES_SITE_USE_ID , null CM_SHIP_USES_TAX_REFERENCE , casa10.party_site_id CM_SHIP_SITE_PARTY_SITE_ID , p5.jgzz_fiscal_code CM_SHIP_CUST_TAXPAYER_ID , he.ledger_id ledger_id , he.event_id event_id FROM hz_party_site_uses csua9 , hz_party_sites casa10 , hz_parties p5, ar_xla_lines_extract he WHERE he.level_flag = 'H' AND csua9.party_site_use_id = he.ship_site_use_id AND csua9.party_site_id = casa10.party_site_id AND p5.party_id = casa10.party_id