Product: | QA - Quality |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.QAFV_COLPLNTXN |
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