Product: | QA - Quality |
---|---|
Description: | Sampling plans |
Implementation/DBA Data: | APPS.QA_SAMPLING_PLANS_V |
SELECT QSP.ROWID ROW_ID
, QSP.SAMPLING_PLAN_ID
, QSP.SAMPLING_PLAN_CODE
, QSP.DESCRIPTION
, QSP.INSP_LEVEL_CODE
, QL1.MEANING INSP_LEVEL_DESC
, QSP.SAMPLING_STD_CODE
, QL2.MEANING SAMPLING_STD_DESC
, QSP.AQL
, QSP.ORGANIZATION_ID
, QSP.LAST_UPDATE_DATE
, QSP.LAST_UPDATED_BY
, QSP.CREATION_DATE
, QSP.CREATED_BY
, QSP.LAST_UPDATE_LOGIN
FROM QA_SAMPLING_PLANS QSP
, QA_LOOKUPS QL1
, QA_LOOKUPS QL2
WHERE QL1.LOOKUP_TYPE (+)= 'QA_SAMPLING_INSP_LEVEL'
AND QL1.LOOKUP_CODE (+)= QSP.INSP_LEVEL_CODE
AND QL2.LOOKUP_TYPE = 'QA_SAMPLING_STD'
AND QL2.LOOKUP_CODE = QSP.SAMPLING_STD_CODE