QA Collection Plan Transactions

Description
Categories: BI Publisher, Manufacturing
Application: Quality
Source: Collection Plan Transactions Report (XML)
Short Name: QLTPLTXR_XML
DB package: QA_QLTPLTXR_XMLP_PKG
SELECT qp.name         plan_name, 
              mfgl.meaning    transaction,
              qc.name         trigger_name,
              mfgl2.meaning   operator,
              qpct.low_value,
              qpct.high_value,
              decode(qpt.mandatory_collection_flag, 1, 'Yes', 2, 'No'),
              decode(qpt.background_collection_flag,1, 'Yes', 2, 'No'),
              decode(qpt.enabled_flag, 1, 'Yes', 2, 'No')
FROM    qa_plans qp,
              qa_plan_transactions qpt,
              qa_plan_collection_triggers qpct,
              qa_chars qc,
              mfg_lookups mfgl,
              mfg_lookups mfgl2
WHERE  qp.plan_id = qpt.plan_id
       and qpt.plan_transaction_id = qpct.plan_transaction_id (+)
       and qc.char_id (+) = qpct.collection_trigger_id
       and mfgl.lookup_type = 'QA_TXN_NAME'
       and mfgl.enabled_flag = 'Y'
       and mfgl.lookup_code = qpt.transaction_number
       and mfgl2.lookup_type(+) = 'QA_OPERATOR'
       and mfgl2.lookup_code(+) = nvl(qpct.operator, -1)
       and qp.name like :plan_name_1
	   order by 1,2,3,4
Parameter Name SQL text Validation
Plan Name
 
LOV Oracle