Product: | QA - Quality |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.QABV_COLELMACTT |
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