eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: QA_COLLECTION_PLAN_VIEWS_V

Product:	QA - Quality
Description:	Collection Plan Views allow you to query and inspect Quality result data for a particular collection plan in the Quality data repository.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT QR.ROWID ROW_ID
, QR.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, QR.PLAN_ID
, QP.NAME PLAN_NAME
, QR.COLLECTION_ID
, QR.OCCURRENCE
FROM QA_RESULTS QR
, QA_PLANS QP
, MTL_PARAMETERS MP
WHERE QR.PLAN_ID = QP.PLAN_ID
AND QR.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND (QR.STATUS IS NULL OR QR.STATUS = 2)

Columns

Name
ROW_ID
ORGANIZATION_ID
ORGANIZATION_CODE
PLAN_ID
PLAN_NAME
COLLECTION_ID
OCCURRENCE