AR_CM_SOLD_TO_CUST_S_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

CM_SOLD_CUST_ACCOUNT_NUMBER CM_SOLD_CUST_TYPE CM_SOLD_CUST_ACCOUNT_ID CM_SOLD_CUST_GLOBAL_ATTR1 CM_SOLD_CUST_GLOBAL_ATTR10 CM_SOLD_CUST_GLOBAL_ATTR12 CM_SOLD_CUST_GLOBAL_ATTR9 CM_SOLD_CUST_GLOBAL_ATTR_CAT CM_SOLD_CUST_NPA_NUMBER CM_SOLD_CUST_AREA_CODE CM_SOLD_CUST_CAT_CODE CM_SOLD_CUST_CITY CM_SOLD_CUST_COUNTRY CM_SOLD_CUST_COUNTY CM_SOLD_CUST_GROUP_TYPE CM_SOLD_CUST_GSA_FLAG CM_SOLD_CUST_FISCAL_CODE CM_SOLD_CUST_PARTY_ID CM_SOLD_CUST_PARTY_NAME CM_SOLD_CUST_PARTY_NUMBER CM_SOLD_CUST_PARTY_TYPE CM_SOLD_CUST_POSTAL_CODE CM_SOLD_CUST_PROVINCE CM_SOLD_CUST_STATE CM_SOLD_CUST_TAX_REFERENCE EVENT_ID LINE_NUMBER LANGUAGE LEDGER_ID

Query

SQL_Statement

SELECT null cm_sold_cust_account_number , null cm_sold_cust_type , null cm_sold_cust_account_id , null cm_sold_cust_global_attr1 , null cm_sold_cust_global_attr10 , null cm_sold_cust_global_attr12 , null cm_sold_cust_global_attr9 , null cm_sold_cust_global_attr_cat , null cm_sold_cust_npa_number , p4.primary_phone_area_code CM_SOLD_CUST_AREA_CODE, p4.category_code cm_sold_cust_cat_code , p4.city cm_sold_cust_city , p4.country cm_sold_cust_country , p4.county cm_sold_cust_county , p4.group_type cm_sold_cust_group_type , p4.gsa_indicator_flag cm_sold_cust_gsa_flag , p4.jgzz_fiscal_code cm_sold_cust_fiscal_code , p4.party_id cm_sold_cust_party_id , p4.party_name cm_sold_cust_party_name , p4.party_number cm_sold_cust_party_number , p4.party_type cm_sold_cust_party_type , p4.postal_code cm_sold_cust_postal_code , p4.province cm_sold_cust_province , p4.state cm_sold_cust_state , null cm_sold_cust_tax_reference , l.event_id event_id , l.line_number line_number , l.language language , l.ledger_id ledger_id FROM hz_parties p4 , ar_xla_lines_extract l WHERE l.level_flag = 'H' AND l.event_class_code = 'CREDIT_MEMO' AND p4.party_id = l.sold_customer_id