VIEW: APPS.QA_PLAN_CHAR_ACTION_TRIGGERS_V

Source

View Text - Preformatted

SELECT QPCAT.ROWID ROW_ID , QPCAT.PLAN_CHAR_ACTION_TRIGGER_ID , QPCAT.LAST_UPDATE_DATE , QPCAT.LAST_UPDATED_BY , QPCAT.CREATION_DATE , QPCAT.CREATED_BY , QPCAT.LAST_UPDATE_LOGIN , QPCAT.TRIGGER_SEQUENCE , QPCAT.PLAN_ID , QP.NAME PLAN_NAME , QPC.VALUES_EXIST_FLAG , DECODE(QC.SQL_VALIDATION_STRING, NULL, 'N', 'Y') SQL_STRING_FLAG , QC.DATATYPE , NVL(QPC.DECIMAL_PRECISION, QC.DECIMAL_PRECISION) DECIMAL_PRECISION , QPCAT.CHAR_ID , QC.NAME CHAR_NAME , QPCAT.OPERATOR , ML1.MEANING OPERATOR_MEANING , QPCAT.LOW_VALUE_LOOKUP , ML2.MEANING LOW_VALUE_MEANING , QPCAT.HIGH_VALUE_LOOKUP , ML3.MEANING HIGH_VALUE_MEANING , QPCAT.LOW_VALUE_OTHER , QPCAT.LOW_VALUE_OTHER_ID , QPCAT.HIGH_VALUE_OTHER , QPCAT.HIGH_VALUE_OTHER_ID FROM QA_PLANS QP,QA_CHARS QC,QA_PLAN_CHARS QPC,MFG_LOOKUPS ML1,MFG_LOOKUPS ML2,MFG_LOOKUPS ML3,QA_PLAN_CHAR_ACTION_TRIGGERS QPCAT WHERE QPCAT.PLAN_ID = QP.PLAN_ID AND QPCAT.CHAR_ID = QC.CHAR_ID AND QPC.CHAR_ID = QC.CHAR_ID AND QPC.PLAN_ID = QP.PLAN_ID AND QPCAT.OPERATOR = ML1.LOOKUP_CODE AND ML1.LOOKUP_TYPE = 'QA_OPERATOR' AND QPCAT.LOW_VALUE_LOOKUP = ML2.LOOKUP_CODE (+) AND ML2.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE' AND QPCAT.HIGH_VALUE_LOOKUP = ML3.LOOKUP_CODE (+) AND ML3.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE'

View Text - HTML Formatted

SELECT QPCAT.ROWID ROW_ID
, QPCAT.PLAN_CHAR_ACTION_TRIGGER_ID
, QPCAT.LAST_UPDATE_DATE
, QPCAT.LAST_UPDATED_BY
, QPCAT.CREATION_DATE
, QPCAT.CREATED_BY
, QPCAT.LAST_UPDATE_LOGIN
, QPCAT.TRIGGER_SEQUENCE
, QPCAT.PLAN_ID
, QP.NAME PLAN_NAME
, QPC.VALUES_EXIST_FLAG
, DECODE(QC.SQL_VALIDATION_STRING
, NULL
, 'N'
, 'Y') SQL_STRING_FLAG
, QC.DATATYPE
, NVL(QPC.DECIMAL_PRECISION
, QC.DECIMAL_PRECISION) DECIMAL_PRECISION
, QPCAT.CHAR_ID
, QC.NAME CHAR_NAME
, QPCAT.OPERATOR
, ML1.MEANING OPERATOR_MEANING
, QPCAT.LOW_VALUE_LOOKUP
, ML2.MEANING LOW_VALUE_MEANING
, QPCAT.HIGH_VALUE_LOOKUP
, ML3.MEANING HIGH_VALUE_MEANING
, QPCAT.LOW_VALUE_OTHER
, QPCAT.LOW_VALUE_OTHER_ID
, QPCAT.HIGH_VALUE_OTHER
, QPCAT.HIGH_VALUE_OTHER_ID
FROM QA_PLANS QP
, QA_CHARS QC
, QA_PLAN_CHARS QPC
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, QA_PLAN_CHAR_ACTION_TRIGGERS QPCAT
WHERE QPCAT.PLAN_ID = QP.PLAN_ID
AND QPCAT.CHAR_ID = QC.CHAR_ID
AND QPC.CHAR_ID = QC.CHAR_ID
AND QPC.PLAN_ID = QP.PLAN_ID
AND QPCAT.OPERATOR = ML1.LOOKUP_CODE
AND ML1.LOOKUP_TYPE = 'QA_OPERATOR'
AND QPCAT.LOW_VALUE_LOOKUP = ML2.LOOKUP_CODE (+)
AND ML2.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE'
AND QPCAT.HIGH_VALUE_LOOKUP = ML3.LOOKUP_CODE (+)
AND ML3.LOOKUP_TYPE (+) = 'QA_ACTION_TRIGGER_VALUE'