[Home] [Help]
View: OKL_PROD_QLTY_VAL_UV
Product: | OKL - Lease and Finance Management |
Description: | Product Quality Values View |
Implementation/DBA Data: |
APPS.OKL_PROD_QLTY_VAL_UV
|
View Text
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
Columns
Name |
PDT_ID |
QUALITY_NAME |
QUALITY_VAL |