QA Collection Element Usages
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Quality
Source: Collection Element Usages Report (XML)
Short Name: QLTCHWUR_XML
DB package: QA_QLTCHWUR_XMLP_PKG
Application: Quality
Source: Collection Element Usages Report (XML)
Short Name: QLTCHWUR_XML
DB package: QA_QLTCHWUR_XMLP_PKG
Run
QA Collection Element Usages and other Oracle EBS reports with Blitz Report™ on our demo environment
select fcl.MEANING "Quality Element Type", fcl.DESCRIPTION "Element Type Desc", qc.name "Quality Element", ml.MEANING "Element Enabled" , qpcv.plan_name "Collection Plan Name", qpcv.MANDATORY_MEANING "Element Mandatory", qpcv.DISPLAYED_MEANING "Element Displayed", qpcv.PROMPT "Collection Prompt", 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.DATATYPE "Datatype", qpcv.DECIMAL_PRECISION "Decimal Precision", qa_common_xmlp_pkg.get_precision(qpcv.DECIMAL_PRECISION) qty_precision, qpcv.ENABLED_MEANING "Plan Char Enabled", 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_QLTCHWUR_XMLP_PKG.c_def_value_numberformula(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_Def_Value_Number from qa_chars qc, fnd_common_lookups fcl, mfg_lookups ml, qa_plan_chars_v qpcv where qpcv.char_id = qc.char_id and qc.char_type_code = fcl.lookup_code and fcl.lookup_type = 'ELEMENT_TYPE' and qc.enabled_flag = ml.lookup_code and ml.lookup_type = 'SYS_YES_NO' &P_characteristic_limiter &P_ORG_DELIMITER &P_Char_Enabled_Delimiter &P_Plan_Enabled_Delimiter ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Collection Element |
|
LOV Oracle | |
Enabled Collection Elements Only |
|
LOV Oracle | |
Enabled Plan Elements Only |
|
LOV Oracle |