VIEW: APPS.OKL_LA_PRODUCT_OPTIONS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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