VIEW: APPS.QAFV_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 , COLLECTION_ELEMENT.NAME COLLECTION_ELEMENT_NAME , QCAT.LAST_UPDATE_DATE , QCAT.LAST_UPDATED_BY , QCAT.CREATION_DATE , QCAT.CREATED_BY FROM QA_CHAR_ACTION_TRIGGERS QCAT, QA_CHARS COLLECTION_ELEMENT, MFG_LOOKUPS MF1, MFG_LOOKUPS MF2, MFG_LOOKUPS MF3 WHERE QCAT.CHAR_ID = COLLECTION_ELEMENT.CHAR_ID AND 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
, COLLECTION_ELEMENT.NAME COLLECTION_ELEMENT_NAME
, QCAT.LAST_UPDATE_DATE
, QCAT.LAST_UPDATED_BY
, QCAT.CREATION_DATE
, QCAT.CREATED_BY
FROM QA_CHAR_ACTION_TRIGGERS QCAT
, QA_CHARS COLLECTION_ELEMENT
, MFG_LOOKUPS MF1
, MFG_LOOKUPS MF2
, MFG_LOOKUPS MF3
WHERE QCAT.CHAR_ID = COLLECTION_ELEMENT.CHAR_ID
AND 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