VRM_SHIP_TO_CUSTOMERS_S_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name

SHIP_CUST_ACCOUNT_NUMBER SHIP_CUST_TYPE SHIP_CUST_ACCOUNT_ID SHIP_CUST_GLOBAL_ATTR1 SHIP_CUST_GLOBAL_ATTR10 SHIP_CUST_GLOBAL_ATTR12 SHIP_CUST_GLOBAL_ATTR9 SHIP_CUST_GLOBAL_ATTR_CAT SHIP_CUST_NPA_NUMBER SHIP_CUST_CAT_CODE SHIP_CUST_CITY SHIP_CUST_COUNTRY SHIP_CUST_COUNTY SHIP_CUST_GROUP_TYPE SHIP_CUST_GSA_FLAG SHIP_CUST_FISCAL_CODE SHIP_CUST_PARTY_ID SHIP_CUST_PARTY_NAME SHIP_CUST_PARTY_NUMBER SHIP_CUST_PARTY_TYPE SHIP_CUST_POSTAL_CODE SHIP_CUST_PROVINCE SHIP_CUST_STATE SHIP_CUST_TAX_REFERENCE LINE_NUMBER EVENT_ID LEDGER_ID SHIP_CUSTOMER_CLASS_CODE

Query

SQL_Statement

SELECT /*+INDEX(l vrm_xla_lines_extract_n1)*/ ca5.account_number ship_cust_account_number , ca5.customer_type ship_cust_type , ca5.cust_account_id ship_cust_account_id , NULL ship_cust_global_attr1 , NULL ship_cust_global_attr10 , NULL ship_cust_global_attr12 , NULL ship_cust_global_attr9 , NULL ship_cust_global_attr_cat , ca5.npa_number ship_cust_npa_number , p5.category_code ship_cust_cat_code , p5.city ship_cust_city , p5.country ship_cust_country , p5.county ship_cust_county , p5.group_type ship_cust_group_type , p5.gsa_indicator_flag ship_cust_gsa_flag , p5.jgzz_fiscal_code ship_cust_fiscal_code , p5.party_id ship_cust_party_id , p5.party_name ship_cust_party_name , p5.party_number ship_cust_party_number , p5.party_type ship_cust_party_type , p5.postal_code ship_cust_postal_code , p5.province ship_cust_province , p5.state ship_cust_state , NULL ship_cust_tax_reference , l.line_number line_number , l.event_id event_id , l.ledger_id ledger_id , ca5.customer_class_code ship_customer_class_code FROM hz_cust_accounts ca5 , hz_parties p5 , vrm_xla_lines_extract_gt l WHERE ca5.cust_account_id = l.ship_customer_id AND ca5.party_id = p5.party_id