CJM_XLA_SUPPLIER_CLAIM_V

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name
CLAIM_ID CLAIM_NUMBER SUPPLIER SUPPLIER_SITE CLAIM_TYPE CLAIM_REASON CLAIM_DATE CLAIM_AMOUNT CLAIM_LEDGER_AMOUNT

Query

SQL_Statement

SELECT DISTINCT cla.claim_id, cla.claim_number claim_number, vendor_party.party_name supplier, pvs.vendor_site_code supplier_site, clty.claim_type_name claim_type, clrs.reason_code_name claim_reason, cla.claim_date claim_date, cla.amount_settled claim_amount, cla.acctd_amount_settled claim_ledger_amount FROM cjm_xla_claim_headers oxh, cjm_claims_all cla, cjm_claim_types_tl clty, cjm_claim_reason_codes_tl clrs, poz_suppliers poz_vendor, hz_parties vendor_party, poz_supplier_sites_all_m pvs WHERE cla.claim_id = oxh.claim_id AND cla.claim_for_code = 'SUPPLIER' 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.vendor_id = poz_vendor.vendor_id AND poz_vendor.party_id = vendor_party.party_id AND cla.vendor_site_id = pvs.vendor_site_id