DPP Customer Claims

Description
Categories: BI Publisher, Sales
Application: Oracle Price Protection
Source:
Short Name: DPPCUSTCLM
DB package:
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