[Home] [Help]
View: OKL_PTL_PTQ_VALS_UV
View Text
SELECT PMV.ID ID
, PTQ.NAME PTQ_NAME
, PTQ.ID PTQ_ID
, PTV.VALUE PTV_VALUE
, PTV.ID PTV_ID
, PMV.PTL_ID PTL_ID
, PMV.FROM_DATE FROM_DATE
, PMV.TO_DATE TO_DATE
, PMV.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM OKL_PTL_QUALITYS PTQ
, OKL_PTQ_VALUES PTV
, OKL_PTL_PTQ_VALS PMV
WHERE PMV.PTV_ID = PTV.ID
AND PMV.PTQ_ID = PTQ.ID
Columns
Name |
ID |
PTQ_NAME |
PTQ_ID |
PTV_VALUE |
PTV_ID |
PTL_ID |
FROM_DATE |
TO_DATE |
OBJECT_VERSION_NUMBER |