View: OKL_SEC_BUYBACK_PRODUCTS_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for securitization buy-back products
Implementation/DBA Data:	APPS.OKL_SEC_BUYBACK_PRODUCTS_UV

View Text

SELECT PDTB.ID PDT_ID
, PDTB.NAME PRODUCT
, PDTB.FROM_DATE PDT_FROM_DATE
, PDTB.TO_DATE PDT_TO_DATE
FROM OKL_PRODUCTS PDTB
WHERE PDTB.ID IN (SELECT KHRB.PDT_ID
FROM OKL_K_HEADERS KHRB
, OKL_POOL_CONTENTS POCB
WHERE KHRB.PDT_ID = PDTB.ID
AND POCB.KHR_ID = KHRB.ID
AND POCB.STATUS_CODE = 'ACTIVE')

Columns