VIEW: APPS.OKL_PTL_PTQ_LKUP_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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