VIEW: APPS.QAFV_COLPLNTXNT

Source

View Text - Preformatted

SELECT QP.NAME PLAN_NAME , QP.PLAN_ID PLAN_ID , QPCT.TXN_TRIGGER_ID PLAN_TRANSACTION_TRIGGER_ID , QPCT.LOW_VALUE , QPCT.HIGH_VALUE , MF.MEANING OPERATOR , QPCT.COLLECTION_TRIGGER_ID COLLECTION_ELEMENT_ID , COLLECTION_ELEMENT.NAME COLLECTION_ELEMENT_NAME , QPCT.PLAN_TRANSACTION_ID , QPCT.LAST_UPDATE_DATE , QPCT.LAST_UPDATED_BY , QPCT.CREATION_DATE , QPCT.CREATED_BY FROM QA_PLANS QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT, QA_CHARS COLLECTION_ELEMENT, MFG_LOOKUPS MF WHERE COLLECTION_ELEMENT.CHAR_ID = QPCT.COLLECTION_TRIGGER_ID AND MF.LOOKUP_TYPE = 'QA_OPERATOR' AND MF.LOOKUP_CODE = QPCT.OPERATOR AND QPCT. PLAN_TRANSACTION_ID = QPT.PLAN_TRANSACTION_ID AND QPT.PLAN_ID = QP.PLAN_ID WITH READ ONLY

View Text - HTML Formatted

SELECT QP.NAME PLAN_NAME
, QP.PLAN_ID PLAN_ID
, QPCT.TXN_TRIGGER_ID PLAN_TRANSACTION_TRIGGER_ID
, QPCT.LOW_VALUE
, QPCT.HIGH_VALUE
, MF.MEANING OPERATOR
, QPCT.COLLECTION_TRIGGER_ID COLLECTION_ELEMENT_ID
, COLLECTION_ELEMENT.NAME COLLECTION_ELEMENT_NAME
, QPCT.PLAN_TRANSACTION_ID
, QPCT.LAST_UPDATE_DATE
, QPCT.LAST_UPDATED_BY
, QPCT.CREATION_DATE
, QPCT.CREATED_BY
FROM QA_PLANS QP
, QA_PLAN_TRANSACTIONS QPT
, QA_PLAN_COLLECTION_TRIGGERS QPCT
, QA_CHARS COLLECTION_ELEMENT
, MFG_LOOKUPS MF
WHERE COLLECTION_ELEMENT.CHAR_ID = QPCT.COLLECTION_TRIGGER_ID
AND MF.LOOKUP_TYPE = 'QA_OPERATOR'
AND MF.LOOKUP_CODE = QPCT.OPERATOR
AND QPCT. PLAN_TRANSACTION_ID = QPT.PLAN_TRANSACTION_ID
AND QPT.PLAN_ID = QP.PLAN_ID WITH READ ONLY