SELECT pov.id ID, pov.ove_id OVE_ID, pov.pon_id PON_ID, pov.from_date FROM_DATE, pov.TO_DATE TO_DATE, ove.value VALUE, pov.object_version_number OBJECT_VERSION_NUMBER FROM OKL_PDT_OPT_VALS_V POV,OKL_OPT_VALUES OVE WHERE pov.ove_id = ove.id
SELECT POV.ID ID
, POV.OVE_ID OVE_ID
, POV.PON_ID PON_ID
, POV.FROM_DATE FROM_DATE
, POV.TO_DATE TO_DATE
, OVE.VALUE VALUE
, POV.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM OKL_PDT_OPT_VALS_V POV
, OKL_OPT_VALUES OVE
WHERE POV.OVE_ID = OVE.ID
|
|
|