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.QABV_COLELMACTT

Source

View Text - Preformatted


SELECT QCAT.CHAR_ACTION_TRIGGER_ID ELEMENT_ACTION_TRIGGER_ID , MF1.MEANING LOW_VALUE_LIMIT_TYPE , QCAT.LOW_VALUE_OTHER LOW_VALUE , MF2.MEANING HIGH_VALUE_LIMIT_TYPE , QCAT.HIGH_VALUE_OTHER HIGH_VALUE , MF3.MEANING OPERATOR , QCAT.TRIGGER_SEQUENCE , QCAT.CHAR_ID COLLECTION_ELEMENT_ID , QCAT.LAST_UPDATE_DATE , QCAT.LAST_UPDATED_BY , QCAT.CREATION_DATE , QCAT.CREATED_BY FROM QA_CHAR_ACTION_TRIGGERS QCAT, MFG_LOOKUPS MF1, MFG_LOOKUPS MF2, MFG_LOOKUPS MF3 WHERE MF1.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE' AND MF1.LOOKUP_CODE (+) = QCAT.LOW_VALUE_LOOKUP AND MF2.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE' AND MF2.LOOKUP_CODE (+) = QCAT.HIGH_VALUE_LOOKUP AND MF3.LOOKUP_TYPE = 'QA_OPERATOR' AND MF3.LOOKUP_CODE = QCAT.OPERATOR with read only

View Text - HTML Formatted

SELECT QCAT.CHAR_ACTION_TRIGGER_ID ELEMENT_ACTION_TRIGGER_ID
, MF1.MEANING LOW_VALUE_LIMIT_TYPE
, QCAT.LOW_VALUE_OTHER LOW_VALUE
, MF2.MEANING HIGH_VALUE_LIMIT_TYPE
, QCAT.HIGH_VALUE_OTHER HIGH_VALUE
, MF3.MEANING OPERATOR
, QCAT.TRIGGER_SEQUENCE
, QCAT.CHAR_ID COLLECTION_ELEMENT_ID
, QCAT.LAST_UPDATE_DATE
, QCAT.LAST_UPDATED_BY
, QCAT.CREATION_DATE
, QCAT.CREATED_BY
FROM QA_CHAR_ACTION_TRIGGERS QCAT
, MFG_LOOKUPS MF1
, MFG_LOOKUPS MF2
, MFG_LOOKUPS MF3
WHERE MF1.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE'
AND MF1.LOOKUP_CODE (+) = QCAT.LOW_VALUE_LOOKUP
AND MF2.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE'
AND MF2.LOOKUP_CODE (+) = QCAT.HIGH_VALUE_LOOKUP
AND MF3.LOOKUP_TYPE = 'QA_OPERATOR'
AND MF3.LOOKUP_CODE = QCAT.OPERATOR WITH READ ONLY