eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.QABV_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.MEANING 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

View Text - HTML Formatted

SELECT QPT.PLAN_TRANSACTION_ID
, MF1.MEANING BACKGROUND_COLLECTION_FLAG
, MF2.MEANING MANDATORY_COLLECTION_FLAG
, MF3.MEANING ENABLED_FLAG
, MF4.MEANING 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