View: OKL_LA_PDT_OPTS_UV

Product:	OKL - Lease and Finance Management
Description:	User interface View for product options - used in product options lov page.
Implementation/DBA Data:	APPS.OKL_LA_PDT_OPTS_UV

View Text

SELECT OPT.NAME NAME
, OPT.DESCRIPTION DESCRIPTION
, PDT_OPT.ID ID
, PDT_OPT.PDT_ID PDT_ID
, KHR.ID KHR_ID
FROM OKL_OPTIONS OPT
, OKL_PDT_OPTS PDT_OPT
, OKL_K_HEADERS KHR
WHERE OPT.ID = PDT_OPT.OPT_ID
AND KHR.PDT_ID = PDT_OPT.PDT_ID
AND TRUNC(NVL(OPT.FROM_DATE
, SYSDATE)) <= TRUNC( SYSDATE)
AND TRUNC(NVL(OPT.TO_DATE
, SYSDATE+1)) > TRUNC( SYSDATE)
AND TRUNC(NVL(PDT_OPT.FROM_DATE
, SYSDATE)) <= TRUNC( SYSDATE)
AND TRUNC( NVL(PDT_OPT.TO_DATE
, SYSDATE+1)) > TRUNC(SYSDATE)

Columns