Product: | QA - Quality |
---|---|
Description: | Shows collection plan , elements and action triggers |
Implementation/DBA Data: | APPS.QA_PLAN_CHAR_ACTION_TRIGGERS_V |
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'