View: QABV_COLPLNTXN

Product:	QA - Quality
Description:	- Retrofitted
Implementation/DBA Data:	APPS.QABV_COLPLNTXN

View Text

SELECT QPT.PLAN_TRANSACTION_ID
, MF1.MEANING BACKGROUND_COLLECTION_FLAG
, MF2.MEANING MANDATORY_COLLECTION_FLAG
, MF3.MEANING ENABLED_FLAG
, MF4.DESCRIPTION PARENT_TRANSACTION
, QPT.PLAN_ID COLLECTION_PLAN_ID
, QPT.LAST_UPDATE_DATE
, QPT.LAST_UPDATED_BY
, QPT.CREATION_DATE
, QPT.CREATED_BY
FROM QA_PLAN_TRANSACTIONS QPT
, MFG_LOOKUPS MF1
, MFG_LOOKUPS MF2
, MFG_LOOKUPS MF3
, MFG_LOOKUPS MF4
WHERE MF1.LOOKUP_TYPE (+) = 'SYS_YES_NO'
AND MF1.LOOKUP_CODE (+) = QPT.BACKGROUND_COLLECTION_FLAG
AND MF2.LOOKUP_TYPE (+) = 'SYS_YES_NO'
AND MF2.LOOKUP_CODE (+) = QPT.MANDATORY_COLLECTION_FLAG
AND MF3.LOOKUP_TYPE (+) = 'SYS_YES_NO'
AND MF3.LOOKUP_CODE (+) = QPT.ENABLED_FLAG
AND MF4.LOOKUP_TYPE = 'QA_TXN_NAME'
AND MF4.LOOKUP_CODE = QPT.TRANSACTION_NUMBER WITH READ ONLY

Columns