[Home] [Help]
View: OKL_PDT_PQY_VALS_UV
View Text
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)
Columns
Name |
ID |
PDT_ID |
PDQ_ID |
PQY_ID |
NAME |
VALUE |
DESCRIPTION |
OBJECT_VERSION_NUMBER |
FROM_DATE |
TO_DATE |