[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 |