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.

VIEW: APPS.QAFV_COLPLNELAC

Source

View Text - Preformatted


SELECT QPCA.PLAN_CHAR_ACTION_ID PLAN_ELEMENT_ACTION_ID , QPCA.MESSAGE , QPCA.STATUS_CODE , QPCA.PLAN_CHAR_ACTION_TRIGGER_ID PLAN_ELEMENT_ACTION_TRIGGER_ID , QPCA.ACTION_ID , QUALITY_ACTION_TYPE.DESCRIPTION ACTION_DESCRIPTION , QPCA.ASSIGNED_CHAR_ID ASSIGNED_COLLECTION_ELEMENT_ID , COLLECTION_ELEMENT.NAME ASSIGNED_COLLECTION_ELEMENT , QPCA.LAST_UPDATE_DATE , QPCA.LAST_UPDATED_BY , QPCA.CREATION_DATE , QPCA.CREATED_BY FROM QA_PLAN_CHAR_ACTIONS QPCA, QA_CHARS COLLECTION_ELEMENT, QA_ACTIONS QUALITY_ACTION_TYPE WHERE QPCA.ASSIGNED_CHAR_ID = COLLECTION_ELEMENT.CHAR_ID (+) AND QPCA.ACTION_ID = QUALITY_ACTION_TYPE.ACTION_ID WITH READ ONLY

View Text - HTML Formatted

SELECT QPCA.PLAN_CHAR_ACTION_ID PLAN_ELEMENT_ACTION_ID
, QPCA.MESSAGE
, QPCA.STATUS_CODE
, QPCA.PLAN_CHAR_ACTION_TRIGGER_ID PLAN_ELEMENT_ACTION_TRIGGER_ID
, QPCA.ACTION_ID
, QUALITY_ACTION_TYPE.DESCRIPTION ACTION_DESCRIPTION
, QPCA.ASSIGNED_CHAR_ID ASSIGNED_COLLECTION_ELEMENT_ID
, COLLECTION_ELEMENT.NAME ASSIGNED_COLLECTION_ELEMENT
, QPCA.LAST_UPDATE_DATE
, QPCA.LAST_UPDATED_BY
, QPCA.CREATION_DATE
, QPCA.CREATED_BY
FROM QA_PLAN_CHAR_ACTIONS QPCA
, QA_CHARS COLLECTION_ELEMENT
, QA_ACTIONS QUALITY_ACTION_TYPE
WHERE QPCA.ASSIGNED_CHAR_ID = COLLECTION_ELEMENT.CHAR_ID (+)
AND QPCA.ACTION_ID = QUALITY_ACTION_TYPE.ACTION_ID WITH READ ONLY