DBA Data[Home] [Help]

VIEW: APPS.OKL_PDT_PQYS_UV

Source

View Text - Preformatted

SELECT PDQ.ID ID, PDQ.PTL_ID PTL_ID, PQY.id pqy_id, PQY.NAME PQY_NAME, PQY.description PQY_description, PQY.FROM_DATE FROM_DATE, PQY.TO_DATE TO_DATE, PDQ.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM OKL_PDT_QUALITYS PQY,OKL_PDT_PQYS PDQ WHERE pqy.id = pdq.pqy_id
View Text - HTML Formatted

SELECT PDQ.ID ID
, PDQ.PTL_ID PTL_ID
, PQY.ID PQY_ID
, PQY.NAME PQY_NAME
, PQY.DESCRIPTION PQY_DESCRIPTION
, PQY.FROM_DATE FROM_DATE
, PQY.TO_DATE TO_DATE
, PDQ.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM OKL_PDT_QUALITYS PQY
, OKL_PDT_PQYS PDQ
WHERE PQY.ID = PDQ.PQY_ID