Product: | QA - Quality |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.QABV_PLNELMACTT |
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
, QPCAT.CHAR_ID COLLECTION_ELEMENT_ID
, QPCAT.LAST_UPDATE_DATE
, QPCAT.LAST_UPDATED_BY
, QPCAT.CREATION_DATE
, QPCAT.CREATED_BY
FROM QA_PLAN_CHAR_ACTION_TRIGGERS QPCAT
, MFG_LOOKUPS MF1
, MFG_LOOKUPS MF2
, MFG_LOOKUPS MF3
WHERE 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