VIEW: APPS.OKL_PTL_PTQ_VALS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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