Product: | QA - Quality |
---|---|
Description: | Shows action triggers |
Implementation/DBA Data: | APPS.QA_CHAR_ACTION_TRIGGERS_V |
SELECT QCAT.ROWID ROW_ID
, QCAT.CHAR_ACTION_TRIGGER_ID
, QCAT.LAST_UPDATE_DATE
, QCAT.LAST_UPDATED_BY
, QCAT.CREATION_DATE
, QCAT.CREATED_BY
, QCAT.LAST_UPDATE_LOGIN
, QCAT.TRIGGER_SEQUENCE
, QCAT.CHAR_ID
, QC.NAME CHAR_NAME
, QC.VALUES_EXIST_FLAG
, DECODE(QC.SQL_VALIDATION_STRING
, NULL
, 'N'
, 'Y') SQL_STRING_FLAG
, QC.DATATYPE
, QC.DECIMAL_PRECISION
, QCAT.OPERATOR
, ML1.MEANING OPERATOR_MEANING
, QCAT.LOW_VALUE_LOOKUP
, ML2.MEANING LOW_VALUE_MEANING
, QCAT.HIGH_VALUE_LOOKUP
, ML3.MEANING HIGH_VALUE_MEANING
, QCAT.LOW_VALUE_OTHER
, QCAT.LOW_VALUE_OTHER_ID
, QCAT.HIGH_VALUE_OTHER
, QCAT.HIGH_VALUE_OTHER_ID
FROM MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, QA_CHARS QC
, QA_CHAR_ACTION_TRIGGERS QCAT
WHERE QCAT.CHAR_ID = QC.CHAR_ID
AND QCAT.OPERATOR = ML1.LOOKUP_CODE
AND ML1.LOOKUP_TYPE = 'QA_OPERATOR'
AND QCAT.LOW_VALUE_LOOKUP = ML2.LOOKUP_CODE (+)
AND ML2.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE'
AND QCAT.HIGH_VALUE_LOOKUP = ML3.LOOKUP_CODE (+)
AND ML3.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE'