QA Collection Plan Details

➜ Back to Library

Description
Categories: BI Publisher, Manufacturing Application: Quality Source: Collection Plan Details Report (XML) Short Name: QLTPLCHR_XML DB package: QA_QLTPLCHR_XMLP_PKG more less

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

Parameter Name

SQL text

Validation

Organization Id

Number

Collection Plan Enabled

LOV Oracle

Collection Plan

LOV Oracle

Collection Plan Type

LOV Oracle

Download

Related Blitz Reports
QA Collection Plan Transactions QA Sequence Element Audit QA Collection Element Usages QA Collection Plan Action Rules QA Collection Plan Summary QA Quality Specifications QA Collection Element Action Rules QA Collection Elements OTA Budget and Cost Reconciliation