View: DPP_XLA_CP_V

Product:	DPP - Oracle Price Protection
Description:	Dpp SLA Claim Summary View
Implementation/DBA Data:	APPS.DPP_XLA_CP_V

View Text

SELECT DTH.TRANSACTION_HEADER_ID
, DTC.CLAIM_ID
, DTH.TRANSACTION_NUMBER
, OCA.ACCTD_AMOUNT AMOUNT
, OCA.CLAIM_DATE
, OCA.CLAIM_NUMBER
, FLV.MEANING
, OCA.CURRENCY_CODE
FROM OZF_CLAIMS_ALL OCA
, DPP_TRANSACTION_HEADERS_ALL DTH
, DPP_TRANSACTION_CLAIMS_ALL DTC
, FND_LOOKUP_VALUES_VL FLV
, DPP_XLA_HEADERS DXH
WHERE OCA.ORG_ID=DTH.ORG_ID
AND DXH.BASE_TRANSACTION_HEADER_ID IS NOT NULL
AND DXH.BASE_TRANSACTION_HEADER_ID=OCA.CLAIM_ID
AND DXH.TRANSACTION_HEADER_ID=DTH.TRANSACTION_HEADER_ID
AND DTC.CLAIM_ID=OCA.CLAIM_ID
AND DTH.TRANSACTION_HEADER_ID=DTC.TRANSACTION_HEADER_ID
AND FLV.LOOKUP_CODE=DTC.CLAIM_TYPE
AND FLV.LOOKUP_TYPE='DPP_CLAIM_TYPES'
AND SYSDATE BETWEEN FLV.START_DATE_ACTIVE
AND NVL(FLV.END_DATE_ACTIVE
, SYSDATE)

Columns