View: OKL_LA_PDT_OPTS_VALS_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface View for product option values - used in product option values lov page. Displayes option values for selected option for the product attached to a contract.
Implementation/DBA Data:	APPS.OKL_LA_PDT_OPTS_VALS_UV

View Text

SELECT OPT_VALS.VALUE VALUE
, OPT_VALS.DESCRIPTION DESCRIPTION
, PDT_OPT_VALS.ID ID
, PDT_OPT_VALS.PON_ID PON_ID
FROM OKL_OPT_VALUES OPT_VALS
, OKL_PDT_OPT_VALS PDT_OPT_VALS
WHERE OPT_VALS.ID = PDT_OPT_VALS.OVE_ID
AND TRUNC(NVL(OPT_VALS.FROM_DATE
, SYSDATE)) <= TRUNC( SYSDATE)
AND TRUNC(NVL(OPT_VALS.TO_DATE
, SYSDATE+1)) > TRUNC(SYSDATE)
AND TRUNC(NVL(PDT_OPT_VALS.FROM_DATE
, SYSDATE)) <= TRUNC( SYSDATE)
AND TRUNC(NVL(PDT_OPT_VALS.TO_DATE
, SYSDATE+1)) > TRUNC(SYSDATE)

Columns