AR_CM_SHIP_TO_CUST_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

CM_SHIP_CUST_ACCOUNT_NUMBER CM_SHIP_CUST_TYPE CM_SHIP_CUST_ACCOUNT_ID CM_SHIP_CUST_GLOBAL_ATTR1 CM_SHIP_CUST_GLOBAL_ATTR10 CM_SHIP_CUST_GLOBAL_ATTR12 CM_SHIP_CUST_GLOBAL_ATTR9 CM_SHIP_CUST_GLOBAL_ATTR_CAT CM_SHIP_CUST_NPA_NUMBER CM_SHIP_CUST_AREA_CODE CM_SHIP_CUST_CAT_CODE CM_SHIP_CUST_CITY CM_SHIP_CUST_COUNTRY CM_SHIP_CUST_COUNTY CM_SHIP_CUST_GROUP_TYPE CM_SHIP_CUST_GSA_FLAG CM_SHIP_CUST_FISCAL_CODE CM_SHIP_CUST_PARTY_ID CM_SHIP_CUST_PARTY_NAME CM_SHIP_CUST_PARTY_NUMBER CM_SHIP_CUST_PARTY_TYPE CM_SHIP_CUST_POSTAL_CODE CM_SHIP_CUST_PROVINCE CM_SHIP_CUST_STATE CM_SHIP_CUST_TAX_REFERENCE LEDGER_ID EVENT_ID CM_SHIP_SITE_CITY CM_SHIP_SITE_COUNTRY CM_SHIP_SITE_COUNTY CM_SHIP_SITE_POSTAL_CODE CM_SHIP_SITE_PROVINCE CM_SHIP_SITE_STATE

Query

SQL_Statement

SELECT /*+INDEX(l ar_xla_lines_extract_n1) */ null cm_ship_cust_account_number , null cm_ship_cust_type , null cm_ship_cust_account_id , null cm_ship_cust_global_attr1 , null cm_ship_cust_global_attr10 , null cm_ship_cust_global_attr12 , null cm_ship_cust_global_attr9 , null cm_ship_cust_global_attr_cat , null cm_ship_cust_npa_number , p5.primary_phone_area_code CM_SHIP_CUST_AREA_CODE , p5.category_code cm_ship_cust_cat_code , p5.city cm_ship_cust_city , p5.country cm_ship_cust_country , p5.county cm_ship_cust_county , p5.group_type cm_ship_cust_group_type , p5.gsa_indicator_flag cm_ship_cust_gsa_flag , p5.jgzz_fiscal_code cm_ship_cust_fiscal_code , p5.party_id cm_ship_cust_party_id , p5.party_name cm_ship_cust_party_name , p5.party_number cm_ship_cust_party_number , p5.party_type cm_ship_cust_party_type , p5.postal_code cm_ship_cust_postal_code , p5.province cm_ship_cust_province , p5.state cm_ship_cust_state , null cm_ship_cust_tax_reference , l.ledger_id ledger_id , l.event_id event_id , loc.city cm_ship_site_city , loc.country cm_ship_site_country , loc.county cm_ship_site_county , loc.postal_code cm_ship_site_postal_code , loc.province cm_ship_site_province , loc.state cm_ship_site_state FROM hz_parties p5 , ar_xla_lines_extract l, hz_party_site_uses p_su, hz_party_sites p_site, hz_locations loc WHERE p5.party_id = l.ship_customer_id AND l.level_flag = 'H' AND p_su.party_site_use_id = l.ship_site_use_id AND p_site.party_site_id = p_su.party_site_id AND loc.location_id = p_site.location_id