CJM_XLA_CUSTOMER_CLAIM_V

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name
CLAIM_ID CLAIM_NUMBER CUSTOMER_NAME CUSTOMER_BILL_TO CLAIM_TYPE CLAIM_REASON CLAIM_DATE CLAIM_AMOUNT CLAIM_ACCTD_AMOUNT CLAIM_CURRENCY

Query

SQL_Statement

SELECT DISTINCT cla.claim_id claim_id, cla.claim_number claim_number, hzp.party_name customer_name, hzsu.location customer_bill_to, clty.claim_type_name claim_type, clrs.reason_code_name claim_reason, cla.claim_date claim_date, cla.amount claim_amount, cla.acctd_amount claim_acctd_amount, cla.currency_code claim_currency FROM cjm_xla_customer_claim_headers cxh, cjm_claims_all cla, cjm_claim_types_tl clty, cjm_claim_reason_codes_tl clrs, hz_parties hzp, hz_cust_accounts hzca, hz_cust_site_uses_all hzsu WHERE cla.claim_id = cxh.claim_id AND cla.claim_for_code = 'CUSTOMER' AND clty.claim_type_id = cla.claim_type_id AND clty.language = userenv('LANG') AND clrs.reason_code_id = cla.reason_code_id AND clrs.language = userenv('LANG') AND cla.bill_to_customer_id = hzca.cust_account_id AND hzca.party_id = hzp.party_id AND cla.bill_to_site_use_id = hzsu.site_use_id (+)