QA Collection Plan Details
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Collection Plan Details Report
Application: Quality
Source: Collection Plan Details Report (XML)
Short Name: QLTPLCHR_XML
DB package: QA_QLTPLCHR_XMLP_PKG
Description: Collection Plan Details Report
Application: Quality
Source: Collection Plan Details Report (XML)
Short Name: QLTPLCHR_XML
DB package: QA_QLTPLCHR_XMLP_PKG
Run
QA Collection Plan Details 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 "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 |