[Home] [Help]
View: 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
Name |
PLAN_TRANSACTION_ID |
BACKGROUND_COLLECTION_FLAG |
MANDATORY_COLLECTION_FLAG |
ENABLED_FLAG |
PARENT_TRANSACTION |
COLLECTION_PLAN_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |