VIEW: APPS.QA_PLAN_COLLECTION_TRIGGERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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