[Home] [Help]
View: OKL_PTL_PTQ_LKUP_UV
View Text
SELECT PTV.ID PTV_ID
, PTV.DESCRIPTION PTV_DESCR
, PTV.VALUE VALUE
, PTV.FROM_DATE PTV_FROM_DATE
, PTV.TO_DATE PTV_TO_DATE
, PTQ.ID PTQ_ID
, PTQ.DESCRIPTION PTQ_DESCR
, PTQ.NAME NAME
, PTQ.FROM_DATE PTQ_FROM_DATE
, PTQ.TO_DATE PTQ_TO_DATE
FROM OKL_PTL_QUALITYS PTQ
, OKL_PTQ_VALUES PTV
WHERE PTV.PTQ_ID = PTQ.ID
Columns
Name |
PTV_ID |
PTV_DESCR |
VALUE |
PTV_FROM_DATE |
PTV_TO_DATE |
PTQ_ID |
PTQ_DESCR |
NAME |
PTQ_FROM_DATE |
PTQ_TO_DATE |