FND Design Data [Home] [Help]

View: OKL_NO_OF_CURES_UV

Product: OKL - Lease and Finance Management
Description:
Implementation/DBA Data: ViewAPPS.OKL_NO_OF_CURES_UV
View Text

SELECT CHR_ID
, COUNT(CHR_ID)
FROM OKL_CURE_AMOUNTS CAM
WHERE STATUS = 'CURESINPROGRESS'
AND NEGOTIATED_AMOUNT IS NOT NULL
AND RECEIVED_AMOUNT IS NOT NULL GROUP BY CHR_ID

Columns

Name
CHR_ID
CURES_IN_POSSESSION