[Home] [Help]
View: OKL_PRODUCT_OPTIONS_UV
View Text
SELECT PON.ID ID
, PON.OPTIONAL_YN OPTIONAL_YN
, PON.PDT_ID PDT_ID
, PDT.NAME PDT_NAME
, PON.OPT_ID OPT_ID
, OPT.NAME OPT_NAME
, OPT.DESCRIPTION OPT_DESCRIPTION
, PON.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PON.FROM_DATE FROM_DATE
, PON.TO_DATE TO_DATE
FROM OKL_PDT_OPTS PON
, OKL_PRODUCTS PDT
, OKL_OPTIONS OPT
WHERE PON.PDT_ID = PDT.ID
AND PON.OPT_ID = OPT.ID
Columns
Name |
ID |
OPTIONAL_YN |
PDT_ID |
PDT_NAME |
OPT_ID |
OPT_NAME |
OPT_DESCRIPTION |
OBJECT_VERSION_NUMBER |
FROM_DATE |
TO_DATE |