AR_CM_SHIP_TO_CUST_S_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 LINE_NUMBER LEDGER_ID LANGUAGE EVENT_ID

Query

SQL_Statement

SELECT 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.line_number line_number , l.ledger_id ledger_id , l.language language , l.event_id event_id FROM hz_parties p5 , ar_xla_lines_extract l WHERE p5.party_id = l.ship_customer_id AND l.level_flag = 'H' AND l.event_class_code = 'CREDIT_MEMO'