QA Collection Plan Summary

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Collection Plan Summary Report
Application: Quality
Source: Collection Plan Summary Report (XML)
Short Name: QLTPLANR_XML
DB package: QA_QLTPLANR_XMLP_PKG
Run QA Collection Plan Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
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 Name SQL text Validation
Collection Plan Type
 
LOV Oracle
Blitz Report™