QA Collection Plan Summary

➜ Back to Library
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
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
Collection Plan Type
 
LOV Oracle
Download
Related Blitz Reports
QA Collection Plan Upload QA: Senfor Intl - Quality Collection Plan Details Extract QA Collection Plan Details QA Plan Relationship Upload QA Collection Plan Transactions FND Attached Documents QA Quality Specifications QA Collection Plan Action Rules MRP Financial Analysis
Blitz Report™