View: DPP_TXN_DASHBOARD_V

Product:	DPP - Oracle Price Protection
Description:	Dpp Transaction Dashboard View
Implementation/DBA Data:	APPS.DPP_TXN_DASHBOARD_V

View Text

SELECT HAO.NAME OPERATING_UNIT
, DAH.REF_DOCUMENT_NUMBER
, APS.VENDOR_NAME SUPPLIER_NAME
, DAH.TRANSACTION_HEADER_ID
, DAH.TRANSACTION_NUMBER TRANSACTION_NUMBER
, DAH.CREATION_DATE
, DAH.EFFECTIVE_START_DATE
, DAH.TRANSACTION_SOURCE
, DAH.TRANSACTION_STATUS
, FLV.MEANING
, (SELECT SUM(CLAIM_AMOUNT)
FROM DPP_TRANSACTION_LINES_ALL DAL
WHERE DAH.TRANSACTION_HEADER_ID=DAL.TRANSACTION_HEADER_ID
AND DAH.ORG_ID=DAL.ORG_ID) CLAIMED_AMOUNT
, DAH.TRX_CURRENCY ONHAND_INV_CURRENCY
, (SELECT SUM(NVL(GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT_SQL ( DCC.TRX_CURRENCY
, DAH.TRX_CURRENCY
, SYSDATE
, FND_PROFILE.VALUE('DPP_CURRENCY_CONVERSION_TYPE')
, NULL
, DCC.CUST_CLAIM_AMT
, -1)
, 0))
FROM DPP_CUSTOMER_CLAIMS_ALL DCC
WHERE DAH.TRANSACTION_HEADER_ID=DCC.TRANSACTION_HEADER_ID
AND DCC.TRX_CURRENCY IS NOT NULL
AND DCC.CUST_CLAIM_AMT IS NOT NULL) CUST_CLAIM_AMOUNT
, DAH.TRX_CURRENCY CLAIM_CURRENCY
FROM AP_SUPPLIERS APS
, DPP_TRANSACTION_HEADERS DAH
, FND_LOOKUP_VALUES_VL FLV
, HR_ALL_ORGANIZATION_UNITS HAO
WHERE DAH.VENDOR_ID=APS.VENDOR_ID
AND FLV.LOOKUP_TYPE='DPP_TRANSACTION_STATUSES'
AND SYSDATE BETWEEN FLV.START_DATE_ACTIVE
AND NVL(FLV.END_DATE_ACTIVE
, SYSDATE)
AND FLV.LOOKUP_CODE=DAH.TRANSACTION_STATUS
AND HAO.ORGANIZATION_ID=DAH.ORG_ID

Columns