VIEW: APPS.QAFV_COLPLNTXN

Source

View Text - Preformatted

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 , COLLECTION_PLAN.NAME COLLECTION_PLAN_NAME , QPT.LAST_UPDATE_DATE , QPT.LAST_UPDATED_BY , QPT.CREATION_DATE , QPT.CREATED_BY FROM QA_PLAN_TRANSACTIONS QPT, QA_PLANS COLLECTION_PLAN, MFG_LOOKUPS MF1, MFG_LOOKUPS MF2, MFG_LOOKUPS MF3, MFG_LOOKUPS MF4 WHERE COLLECTION_PLAN.PLAN_ID = QPT.PLAN_ID AND 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

View Text - HTML Formatted

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
, COLLECTION_PLAN.NAME COLLECTION_PLAN_NAME
, QPT.LAST_UPDATE_DATE
, QPT.LAST_UPDATED_BY
, QPT.CREATION_DATE
, QPT.CREATED_BY
FROM QA_PLAN_TRANSACTIONS QPT
, QA_PLANS COLLECTION_PLAN
, MFG_LOOKUPS MF1
, MFG_LOOKUPS MF2
, MFG_LOOKUPS MF3
, MFG_LOOKUPS MF4
WHERE COLLECTION_PLAN.PLAN_ID = QPT.PLAN_ID
AND 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