VIEW: APPS.QA_CHAR_ACTION_TRIGGERS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'