ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF6F3869E053B46B63588994Y select OCA.CLAIM_NUMBER, hca.ACCOUNT_NUMBER CUSTOMER_NUMBER, hca.ACCOUNT_NAME CUSTOMER_NAME, MSIK.concatenated_segments ITEM_NUMBER, MSIK.DESCRIPTION ITEM_DESCRIPTION, DCC.REPORTED_INVENTORY, muomv.unit_of_measure UOM, DCC.CUSTOMER_NEW_PRICE NEW_PRICE, ROUND(DCC.CUST_CLAIM_AMT,fl.precision) CUST_CLAIM_AMT, fl.description TRX_CURRENCY, DCC.DEBIT_MEMO_NUMBER FROM DPP_CUSTOMER_CLAIMS_ALL DCC, HZ_CUST_ACCOUNTS hca, mtl_system_items_kfv MSIK, DPP_TRANSACTION_HEADERS_ALL DH, OZF_CLAIMS_ALL OCA, MTL_UNITS_OF_MEASURE_vL muomv, fnd_currencies_vl fl, financials_system_params_all fspa WHERE DCC.CUST_ACCOUNT_ID=hca.CUST_ACCOUNT_ID AND DCC.INVENTORY_ITEM_ID=MSIK.INVENTORY_ITEM_ID AND DCC.TRANSACTION_HEADER_ID=DH.TRANSACTION_HEADER_ID AND DH.TRANSACTION_NUMBER = :TRANSACTION_NUMBER AND DCC.CUSTOMER_CLAIM_ID=OCA.CLAIM_ID AND muomv.uom_code = DCC.uom AND fl.CURRENCY_CODE =DH.TRX_CURRENCY AND fspa.org_id = dh.org_id AND fspa.INVENTORY_ORGANIZATION_ID = msik.organization_id DPP DPPCUSTCLM US DPP Customer Claims Application: Oracle Price Protection Source: Short Name: DPPCUSTCLM DB package: BI Publisher :transaction_number