APPS.OPI_DBI_REP_UOM_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

        SELECT  uom_class
        FROM    mtl_units_of_measure
        WHERE   uom_code = p_code
        AND     rownum < 2;

Line: 41

        SELECT  uom_code
        FROM    mtl_units_of_measure
                WHERE   uom_class = p_class
        AND     base_uom_flag = 'Y'
        AND     rownum < 2;

Line: 48

        SELECT  decode(from_base_uom_code, l_from_base_code, 1, 2) flag,
                conv_rate
        FROM    opi_dbi_uom_class_std_conv
        WHERE   (from_base_uom_code = l_from_base_code
                AND to_base_uom_code = l_to_base_code)
        OR      (from_base_uom_code = l_to_base_code
                AND to_base_uom_code = l_from_base_code);

Line: 173

        SELECT  rep_uom_code
        FROM    opi_dbi_rep_uoms
        WHERE   measure_code = p_measure;

Line: 207

        SELECT  uoms.unit_of_measure_tl
        FROM    opi_dbi_rep_uoms        rep_uoms,
                mtl_units_of_measure_vl uoms
        WHERE   rep_uoms.measure_code = 'WT'
        AND     rep_uoms.rep_uom_code = uoms.uom_code;

Line: 237

        SELECT  uoms.unit_of_measure_tl
        FROM    opi_dbi_rep_uoms        rep_uoms,
                mtl_units_of_measure_vl uoms
        WHERE   rep_uoms.measure_code = 'VOL'
          AND   rep_uoms.rep_uom_code = uoms.uom_code;

Line: 266

        SELECT  uoms.unit_of_measure_tl
        FROM    opi_dbi_rep_uoms        rep_uoms,
                mtl_units_of_measure_vl uoms
        WHERE   rep_uoms.measure_code = 'DIS'
          AND   rep_uoms.rep_uom_code = uoms.uom_code;

Line: 361

        SELECT  unit_of_measure_tl, uom_class
        FROM    mtl_units_of_measure_vl
        WHERE   uom_code = p_code
        AND     rownum < 2;