View: QAFV_COLELMACTT

Product:	QA - Quality
Description:	- Retrofitted
Implementation/DBA Data:	APPS.QAFV_COLELMACTT

View Text

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

Columns