QA Collection Element Usages

Description
Categories: BI Publisher, Manufacturing
Application: Quality
Source: Collection Element Usages Report (XML)
Short Name: QLTCHWUR_XML
DB package: QA_QLTCHWUR_XMLP_PKG
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
Organization Id
 
Number
Enabled Plan Elements Only
 
LOV Oracle
Enabled Collection Elements Only
 
LOV Oracle
Collection Element
 
LOV Oracle