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 |
