DPP Customer Claims

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

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