VIEW: APPS.QA_PLAN_TRANSACTIONS_V

Source

View Text - Preformatted

SELECT QPT.ROWID ROW_ID , QPT.PLAN_TRANSACTION_ID , QPT.LAST_UPDATE_DATE , QPT.LAST_UPDATED_BY , QPT.CREATION_DATE , QPT.CREATED_BY , QPT.LAST_UPDATE_LOGIN , QPT.PLAN_ID , QPT.TRANSACTION_NUMBER , QP.NAME PLAN_NAME , QP.DESCRIPTION PLAN_DESCRIPTION , ML.DESCRIPTION TRANSACTION_DESCRIPTION , QPT.MANDATORY_COLLECTION_FLAG , ML2.MEANING MANDATORY_MEANING , QPT.BACKGROUND_COLLECTION_FLAG , ML3.MEANING BACKGROUND_MEANING ,QPT.ENABLED_FLAG ,ML4.MEANING ENABLED_MEANING ,QPT.EQR_LAYOUT_MODE FROM QA_PLANS QP,MFG_LOOKUPS ML,MFG_LOOKUPS ML2,QA_PLAN_TRANSACTIONS QPT,MFG_LOOKUPS ML3,MFG_LOOKUPS ML4 WHERE QPT.PLAN_ID = QP.PLAN_ID AND QPT.TRANSACTION_NUMBER = ML.LOOKUP_CODE AND ML.LOOKUP_TYPE = 'QA_TXN_NAME' AND QPT.MANDATORY_COLLECTION_FLAG = ML2.LOOKUP_CODE AND ML2.LOOKUP_TYPE = 'SYS_YES_NO' AND QPT.BACKGROUND_COLLECTION_FLAG = ML3.LOOKUP_CODE AND ML3.LOOKUP_TYPE = 'SYS_YES_NO' AND QPT.ENABLED_FLAG = ML4.LOOKUP_CODE AND ML4.LOOKUP_TYPE = 'SYS_YES_NO'

View Text - HTML Formatted

SELECT QPT.ROWID ROW_ID
, QPT.PLAN_TRANSACTION_ID
, QPT.LAST_UPDATE_DATE
, QPT.LAST_UPDATED_BY
, QPT.CREATION_DATE
, QPT.CREATED_BY
, QPT.LAST_UPDATE_LOGIN
, QPT.PLAN_ID
, QPT.TRANSACTION_NUMBER
, QP.NAME PLAN_NAME
, QP.DESCRIPTION PLAN_DESCRIPTION
, ML.DESCRIPTION TRANSACTION_DESCRIPTION
, QPT.MANDATORY_COLLECTION_FLAG
, ML2.MEANING MANDATORY_MEANING
, QPT.BACKGROUND_COLLECTION_FLAG
, ML3.MEANING BACKGROUND_MEANING
, QPT.ENABLED_FLAG
, ML4.MEANING ENABLED_MEANING
, QPT.EQR_LAYOUT_MODE
FROM QA_PLANS QP
, MFG_LOOKUPS ML
, MFG_LOOKUPS ML2
, QA_PLAN_TRANSACTIONS QPT
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
WHERE QPT.PLAN_ID = QP.PLAN_ID
AND QPT.TRANSACTION_NUMBER = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'QA_TXN_NAME'
AND QPT.MANDATORY_COLLECTION_FLAG = ML2.LOOKUP_CODE
AND ML2.LOOKUP_TYPE = 'SYS_YES_NO'
AND QPT.BACKGROUND_COLLECTION_FLAG = ML3.LOOKUP_CODE
AND ML3.LOOKUP_TYPE = 'SYS_YES_NO'
AND QPT.ENABLED_FLAG = ML4.LOOKUP_CODE
AND ML4.LOOKUP_TYPE = 'SYS_YES_NO'