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 ...
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
Source: Collection Plan Details Report (XML)
Short Name: QLTPLCHR_XML
DB package: QA_QLTPLCHR_XMLP_PKG
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 | |
---|---|---|---|
Collection Plan Type | LOV Oracle | ||
Collection Plan | LOV Oracle | ||
Collection Plan Enabled | LOV Oracle | ||
Organization Id | Number |