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_PLNELMACTT

Source

View Text - Preformatted


SELECT QPCAT.PLAN_CHAR_ACTION_TRIGGER_ID PLAN_ELEMENT_ACTION_TRIGGER_ID , MF1.MEANING LOW_VALUE_LIMIT_TYPE , QPCAT.LOW_VALUE_OTHER LOW_VALUE , MF2.MEANING HIGH_VALUE_LIMIT_TYPE , QPCAT.HIGH_VALUE_OTHER HIGH_VALUE , MF3.MEANING OPERATOR , QPCAT.TRIGGER_SEQUENCE , QPCAT.PLAN_ID COLLECTION_PLAN_ID , COLLECTION_PLAN.NAME COLLECTION_PLAN_NAME , QPCAT.CHAR_ID COLLECTION_ELEMENT_ID , COLLECTION_ELEMENT.NAME COLLECTION_ELEMENT_NAME , QPCAT.LAST_UPDATE_DATE , QPCAT.LAST_UPDATED_BY , QPCAT.CREATION_DATE , QPCAT.CREATED_BY FROM QA_PLAN_CHAR_ACTION_TRIGGERS QPCAT, QA_PLANS COLLECTION_PLAN, QA_CHARS COLLECTION_ELEMENT, MFG_LOOKUPS MF1, MFG_LOOKUPS MF2, MFG_LOOKUPS MF3 WHERE QPCAT.PLAN_ID = COLLECTION_PLAN.PLAN_ID AND QPCAT.CHAR_ID = COLLECTION_ELEMENT.CHAR_ID AND MF1.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE' AND MF1.LOOKUP_CODE (+) = QPCAT.LOW_VALUE_LOOKUP AND MF2.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE' AND MF2.LOOKUP_CODE (+) = QPCAT.HIGH_VALUE_LOOKUP AND MF3.LOOKUP_TYPE = 'QA_OPERATOR' AND MF3.LOOKUP_CODE = QPCAT.OPERATOR WITH READ ONLY

View Text - HTML Formatted

SELECT QPCAT.PLAN_CHAR_ACTION_TRIGGER_ID PLAN_ELEMENT_ACTION_TRIGGER_ID
, MF1.MEANING LOW_VALUE_LIMIT_TYPE
, QPCAT.LOW_VALUE_OTHER LOW_VALUE
, MF2.MEANING HIGH_VALUE_LIMIT_TYPE
, QPCAT.HIGH_VALUE_OTHER HIGH_VALUE
, MF3.MEANING OPERATOR
, QPCAT.TRIGGER_SEQUENCE
, QPCAT.PLAN_ID COLLECTION_PLAN_ID
, COLLECTION_PLAN.NAME COLLECTION_PLAN_NAME
, QPCAT.CHAR_ID COLLECTION_ELEMENT_ID
, COLLECTION_ELEMENT.NAME COLLECTION_ELEMENT_NAME
, QPCAT.LAST_UPDATE_DATE
, QPCAT.LAST_UPDATED_BY
, QPCAT.CREATION_DATE
, QPCAT.CREATED_BY
FROM QA_PLAN_CHAR_ACTION_TRIGGERS QPCAT
, QA_PLANS COLLECTION_PLAN
, QA_CHARS COLLECTION_ELEMENT
, MFG_LOOKUPS MF1
, MFG_LOOKUPS MF2
, MFG_LOOKUPS MF3
WHERE QPCAT.PLAN_ID = COLLECTION_PLAN.PLAN_ID
AND QPCAT.CHAR_ID = COLLECTION_ELEMENT.CHAR_ID
AND MF1.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE'
AND MF1.LOOKUP_CODE (+) = QPCAT.LOW_VALUE_LOOKUP
AND MF2.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE'
AND MF2.LOOKUP_CODE (+) = QPCAT.HIGH_VALUE_LOOKUP
AND MF3.LOOKUP_TYPE = 'QA_OPERATOR'
AND MF3.LOOKUP_CODE = QPCAT.OPERATOR WITH READ ONLY