View: OKL_LA_PRODUCT_OPTIONS_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface view on Selected Product options for a Contract. It is used in contract producr options summary page.
Implementation/DBA Data:	APPS.OKL_LA_PRODUCT_OPTIONS_UV

View Text

SELECT OPT.NAME OPTON_NAME
, OPT.DESCRIPTION OPTION_DESCRIPTION
, OPT_VALS.VALUE VALUE
, OPT_VALS.DESCRIPTION VALUE_DESCRIPTION
, CSPB.KHR_ID KHR_ID
FROM OKL_OPTIONS OPT
, OKL_PDT_OPTS PDT_OPT
, OKL_OPT_VALUES OPT_VALS
, OKL_PDT_OPT_VALS PDT_OPT_VALS
, OKL_SLCTD_OPTNS CSPB
WHERE OPT.ID = PDT_OPT.OPT_ID
AND OPT_VALS.ID = PDT_OPT_VALS.OVE_ID
AND PDT_OPT_VALS.ID = CSPB.POV_ID
AND PDT_OPT.ID = PDT_OPT_VALS.PON_ID
AND OPT.ID = OPT_VALS.OPT_ID

Columns