QA Collection Plan Details

Description

Categories: BI Publisher
Columns: Plan Type, Plan Type Desc, Plan Name, Plan Description, View Name, Effective From, Effective To, Element Name, Prompt, Prompt Sequence ...

Application: Quality
Source: Collection Plan Details Report (XML)
Short Name: QLTPLCHR_XML
DB package: QA_QLTPLCHR_XMLP_PKG

Copy

select  	qpv.PLAN_TYPE_MEANING "Plan Type", 
	qpv.PLAN_TYPE_DESCRIPTION "Plan Type Desc",
	qpv.NAME "Plan Name", 
	qpv.DESCRIPTION "Plan Description",
	qpv.VIEW_NAME "View Name", 
	qpv.EFFECTIVE_FROM "Effective From",
	qpv.EFFECTIVE_TO "Effective To",
	qpcv.CHAR_NAME "Element Name",
	qpcv.PROMPT "Prompt",
	qpcv.PROMPT_SEQUENCE "Prompt Sequence",
	qpcv.CHAR_TYPE_MEANING "Element Type",
	qpcv.DATATYPE "Datatype Num",
                decode(qpcv.datatype, 
	   3, qltdate.any_to_user(qpcv.default_value),
	   6, qltdate.canon_to_user(qpcv.default_value),
	   qpcv.DEFAULT_VALUE) "Default Value",
	qpcv.ENABLED_MEANING "Enabled",
	qpcv.MANDATORY_MEANING "Mandatory",
	qpcv.DISPLAYED_MEANING "Displayed",
	qpcv.DECIMAL_PRECISION "Decimal Precision",
	qpcv.READ_ONLY_MEANING "READ_ONLY",
	qpcv.SS_POPLIST_MEANING "SELF_SERVICE_POPLIST",
	qpcv.INFORMATION_MEANING "INFORMATION",
	qpcv.device_meaning "Device Enabled",
	qpcv.device "Device Name",
	qpcv.override_meaning "Override", 
	QA_QLTPLCHR_XMLP_PKG.c_default_value_numformula(qpcv.DATATYPE, decode ( qpcv.datatype , 3 , qltdate.any_to_user ( qpcv.default_value ) , 6 , qltdate.canon_to_user ( qpcv.default_value ) , qpcv.DEFAULT_VALUE )) C_Default_Value_Num,
	qa_common_xmlp_pkg.get_precision(qpcv.DECIMAL_PRECISION) qty_precision
from 	qa_plan_chars_v qpcv,
	qa_plans_v qpv
where	qpv.Plan_id = qpcv.Plan_id
&P_org_limiter
&P_plan_type_desc_limiter
&P_plan_limiter
&P_plan_enabled_limiter
order by	qpv.PLAN_TYPE_MEANING, qpv.NAME, qpcv.PROMPT_SEQUENCE