APPS.INV_RCV_STD_DELIVER_APIS dependencies on MTL_UNITS_OF_MEASURE

Line 130: l_uom_code mtl_units_of_measure.uom_code%TYPE;

126: l_lpn_group_id NUMBER;
127:
128: l_operating_unit_id MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE; --
129: --Bug #4348794
130: l_uom_code mtl_units_of_measure.uom_code%TYPE;
131:
132:
133: -- For Bug 7440217
134: v_lcm_enabled_org varchar2(1);

Line 256: FROM mtl_units_of_measure muom

252: --Bug #4348794 - Populate RTI with uom code
253: BEGIN
254: SELECT muom.uom_code
255: INTO l_uom_code
256: FROM mtl_units_of_measure muom
257: WHERE muom.unit_of_measure = l_uom;
258: IF (l_debug = 1) THEN
259: print_debug('Unit of measure: ' || l_uom || ', UOM Code: ' || l_uom_code, 1);
260: END IF;

Line 2419: FROM mtl_units_of_measure

2415: IF (p_rcvtxn_uom_code IS NULL) THEN
2416: BEGIN
2417: SELECT uom_code
2418: INTO l_rcvtxn_uom_code
2419: FROM mtl_units_of_measure
2420: WHERE unit_of_measure = p_rcvtxn_uom
2421: AND ROWNUM < 2;
2422: EXCEPTION
2423: WHEN OTHERS THEN

Line 2435: FROM mtl_units_of_measure

2431:
2432: BEGIN
2433: SELECT uom_code
2434: INTO l_prim_uom_code
2435: FROM mtl_units_of_measure
2436: WHERE unit_of_measure = l_rcvtxn_match_table_detail(match_result_count).primary_unit_of_measure
2437: AND ROWNUM < 2;
2438: EXCEPTION
2439: WHEN OTHERS THEN

Line 3147: FROM MTL_UNITS_OF_MEASURE_VL

3143: SELECT unit_of_measure,
3144: uom_code
3145: INTO l_rcv_transaction_rec.secondary_uom,
3146: l_rcv_transaction_rec.secondary_uom_code
3147: FROM MTL_UNITS_OF_MEASURE_VL
3148: WHERE unit_of_measure = p_secondary_uom
3149: OR uom_code = p_secondary_uom;
3150:
3151: l_rcv_transaction_rec.sec_transaction_quantity := p_sec_rcvtxn_qty;