Product: | QA - Quality |
---|---|
Description: | shows collection plans and triggers associated |
Implementation/DBA Data: | APPS.QA_PLAN_COLLECTION_TRIGGERS_V |
SELECT QPCT.ROWID ROW_ID
, QPCT.TXN_TRIGGER_ID
, QPCT.LAST_UPDATE_DATE
, QPCT.LAST_UPDATED_BY
, QPCT.CREATION_DATE
, QPCT.CREATED_BY
, QPCT.LAST_UPDATE_LOGIN
, QPT.PLAN_ID
, QPCT.PLAN_TRANSACTION_ID
, QPCT.COLLECTION_TRIGGER_ID
, QPT.TRANSACTION_NUMBER
, QP.NAME PLAN_NAME
, ML1.DESCRIPTION TRANSACTION_DESCRIPTION
, QC.NAME COLLECTION_TRIGGER_DESCRIPTION
, QC.DATATYPE
, QC.DECIMAL_PRECISION
, QPCT.OPERATOR
, ML2.MEANING OPERATOR_MEANING
, QPCT.LOW_VALUE
, QPCT.LOW_VALUE_ID
, QPCT.HIGH_VALUE
, QPCT.HIGH_VALUE_ID
FROM QA_PLAN_TRANSACTIONS QPT
, QA_PLANS QP
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, QA_CHARS QC
, QA_PLAN_COLLECTION_TRIGGERS QPCT
WHERE QPCT.PLAN_TRANSACTION_ID = QPT.PLAN_TRANSACTION_ID
AND QPT.PLAN_ID = QP.PLAN_ID
AND QPT.TRANSACTION_NUMBER = ML1.LOOKUP_CODE
AND ML1.LOOKUP_TYPE = 'QA_TXN_NAME'
AND QPCT.OPERATOR = ML2.LOOKUP_CODE
AND ML2.LOOKUP_TYPE = 'QA_OPERATOR'
AND QPCT.COLLECTION_TRIGGER_ID = QC.CHAR_ID