QA Collection Plan Summary

Description
Categories: BI Publisher, Manufacturing
Application: Quality
Source: Collection Plan Summary Report (XML)
Short Name: QLTPLANR_XML
DB package: QA_QLTPLANR_XMLP_PKG
select  	qpv.PLAN_TYPE_MEANING "Plan Type",     
	qpv.PLAN_TYPE_DESCRIPTION "Plan Type Desc",
	qpv.NAME "Plan Name", 
	qpv.DESCRIPTION "Description",
	qpv.VIEW_NAME "View Name",
	qpv.SPEC_ASSIGNMENT_MEANING "Specification Type",
	qpv.EFFECTIVE_FROM "Effective From",
	qpv.EFFECTIVE_TO "Effective To"
from 	qa_plans_v qpv
Where 	1 = 1
&P_Org_delimiter
&P_PLAN_TYPE_DELIMITER
ORDER BY 1 ASC,2 ASC
Parameter NameSQL textValidation
Organization Id
 
Number
Collection Plan Type
 
LOV Oracle