DPP Customer Claims

➜ Back to Library
Description
Categories: BI Publisher
Application: Oracle Price Protection
Source:
Short Name: DPPCUSTCLM
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Download
 
Related Blitz Reports
DPP Customer Inventory Detail DPP Supplier Claims Detail GL Account Analysis XXRG GL Account Analysis GL Account Analysis (Distributions) PO Invoice Price Variance PO Headers and Lines XXT OF: PO Headers and Lines XXSUB PO Headers and Lines
Blitz Report™

Blitz Report™ provides multiple benefits: