QA Collection Elements

Description

Application: Quality
Source: Collection Elements Report (XML)
Short Name: QLTCHARR_XML
DB package: QA_QLTCHARR_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

select    qcv.CHAR_TYPE_MEANING "Element Type",
                qcv.CHAR_TYPE_DESCRIPTION "Element Type Desc",
                qcv.NAME "Element Name",
                qcv.DATATYPE "Datatype Num",
                qcv.DATATYPE_MEANING "Datatype",
                qcv.DISPLAY_LENGTH "Reporting Length",
                qcv.DECIMAL_PRECISION "Decimal Precision",
                qcv.UOM_CODE "UOM",
                decode(qcv.datatype, 3,
                   qltdate.any_to_user(qcv.default_value),
                   6, qltdate.canon_to_user (qcv.default_value),
                   qcv.DEFAULT_VALUE) "Default Value",
                ml2.meaning "Enabled",
                ml.meaning "Pre-Defined",
                ml3.meaning "Mandatory",
                QA_QLTCHARR_XMLP_PKG.c_default_value_numformula(qcv.DATATYPE, decode ( qcv.datatype , 3 , qltdate.any_to_user ( qcv.default_value ) , 6 , qltdate.canon_to_user ( qcv.default_value ) , qcv.DEFAULT_VALUE )) C_Default_Value_Num
            from    qa_chars_v qcv,
                mfg_lookups ml,
                mfg_lookups ml2,
                mfg_lookups ml3
            where   qcv.CHAR_CONTEXT_CHECKBOX = ml.LOOKUP_CODE
            and     ml.LOOKUP_TYPE = 'SYS_YES_NO'
            and qcv.ENABLED_FLAG = ml2.LOOKUP_CODE
            and     ml2.LOOKUP_TYPE = 'SYS_YES_NO'
            and qcv.MANDATORY_FLAG = ml3.LOOKUP_CODE
            and     ml3.LOOKUP_TYPE = 'SYS_YES_NO'
            &P_Element_Type_Limiter
            &P_Element_Limiter
            &P_Enabled_Limiter
            Order By qcv.CHAR_TYPE_MEANING, qcv.NAME