VIEW: APPS.OKL_PDT_PQY_VALS_UV

Source

View Text - Preformatted

SELECT pqv.ID ID, pdt.id PDT_ID, pdq.ID PDQ_ID, pdq.PQY_ID PQY_ID, pqy.NAME NAME, qve.VALUE value, qve.DESCRIPTION DESCRIPTION, pqv.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TO_DATE(NULL) FROM_DATE, TO_DATE(NULL) TO_DATE FROM OKL_PDT_QUALITYS PQY,OKL_PRODUCTS PDT,OKL_PDT_PQYS PDQ,OKL_PDT_PQY_VALS PQV,OKL_PQY_VALUES QVE WHERE PQV.PDT_ID = PDT.ID AND PQV.PDQ_ID = PDQ.ID AND PQV.QVE_ID = QVE.ID AND QVE.PQY_ID = PQY.ID AND PDQ.PQY_ID = PQY.ID AND PDT.PTL_ID = PDQ.PTL_ID UNION SELECT DISTINCT TO_NUMBER(NULL) ID, PDT.ID PDT_ID, PDQ.ID PDQ_ID, pdq.PQY_ID PQY_ID, PQY.NAME NAME, NULL VALUE, NULL DESCRIPTION, TO_NUMBER(NULL) OBJECT_VERSION_NUMBER, pqy.FROM_DATE FROM_DATE, pqy.TO_DATE TO_DATE FROM OKL_PQY_VALUES QVE, OKL_PRODUCTS PDT, OKL_PDT_PQYS PDQ, OKL_PDT_QUALITYS PQY WHERE PDT.PTL_ID = PDQ.PTL_ID AND PDQ.PQY_ID = PQY.ID AND PQY.ID = QVE.PQY_ID AND NOT EXISTS ( SELECT 1 FROM OKL_PDT_PQY_VALS PQV2 WHERE PQV2.PDT_ID = PDT.ID AND PQV2.PDQ_ID = PDQ.ID)

View Text - HTML Formatted

SELECT PQV.ID ID
, PDT.ID PDT_ID
, PDQ.ID PDQ_ID
, PDQ.PQY_ID PQY_ID
, PQY.NAME NAME
, QVE.VALUE VALUE
, QVE.DESCRIPTION DESCRIPTION
, PQV.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TO_DATE(NULL) FROM_DATE
, TO_DATE(NULL) TO_DATE
FROM OKL_PDT_QUALITYS PQY
, OKL_PRODUCTS PDT
, OKL_PDT_PQYS PDQ
, OKL_PDT_PQY_VALS PQV
, OKL_PQY_VALUES QVE
WHERE PQV.PDT_ID = PDT.ID
AND PQV.PDQ_ID = PDQ.ID
AND PQV.QVE_ID = QVE.ID
AND QVE.PQY_ID = PQY.ID
AND PDQ.PQY_ID = PQY.ID
AND PDT.PTL_ID = PDQ.PTL_ID UNION SELECT DISTINCT TO_NUMBER(NULL) ID
, PDT.ID PDT_ID
, PDQ.ID PDQ_ID
, PDQ.PQY_ID PQY_ID
, PQY.NAME NAME
, NULL VALUE
, NULL DESCRIPTION
, TO_NUMBER(NULL) OBJECT_VERSION_NUMBER
, PQY.FROM_DATE FROM_DATE
, PQY.TO_DATE TO_DATE
FROM OKL_PQY_VALUES QVE
, OKL_PRODUCTS PDT
, OKL_PDT_PQYS PDQ
, OKL_PDT_QUALITYS PQY
WHERE PDT.PTL_ID = PDQ.PTL_ID
AND PDQ.PQY_ID = PQY.ID
AND PQY.ID = QVE.PQY_ID
AND NOT EXISTS ( SELECT 1
FROM OKL_PDT_PQY_VALS PQV2
WHERE PQV2.PDT_ID = PDT.ID
AND PQV2.PDQ_ID = PDQ.ID)