VIEW: APPS.OKL_PROD_QLTY_VAL_UV

Source

View Text - Preformatted

SELECT pdt.id pdt_id, pqy.name quality_name, qve.value quality_val FROM OKL_PRODUCTS PDT,OKL_PDT_QUALITYS PQY,OKL_PDT_PQY_VALS PQV,OKL_PQY_VALUES QVE WHERE pdt.id = pqv.pdt_id AND pqv.qve_id = qve.id AND qve.pqy_id = pqy.id

View Text - HTML Formatted

SELECT PDT.ID PDT_ID
, PQY.NAME QUALITY_NAME
, QVE.VALUE QUALITY_VAL
FROM OKL_PRODUCTS PDT
, OKL_PDT_QUALITYS PQY
, OKL_PDT_PQY_VALS PQV
, OKL_PQY_VALUES QVE
WHERE PDT.ID = PQV.PDT_ID
AND PQV.QVE_ID = QVE.ID
AND QVE.PQY_ID = PQY.ID