DBA Data[Home] [Help]

APPS.INV_RCV_TXN_MATCH dependencies on MTL_UNITS_OF_MEASURE

Line 2260: FROM mtl_units_of_measure WHERE unit_of_measure=temp_cascaded_table(current_n).unit_of_measure AND ROWNUM=1;

2256: print_debug('unit_of_measure : ' || temp_cascaded_table(current_n).unit_of_measure); --14776842
2257: END IF;
2258:
2259: SELECT uom_code INTO l_rma_uom -- 14776842 In oe_order_lines_all, it only keep uom code
2260: FROM mtl_units_of_measure WHERE unit_of_measure=temp_cascaded_table(current_n).unit_of_measure AND ROWNUM=1;
2261: IF (l_debug = 1) THEN
2262: print_debug('l_rma_uom : ' || l_rma_uom);
2263: END IF;
2264:

Line 3137: FROM mtl_units_of_measure

3133: l_parent_id := x_MatchedRec.oe_order_line_id;
3134: --bug3592116 for RMA the uom code is got from oe_order_lines_all but we need to get
3135: --unit_of_measure to convert the rma line quantity to user input qty.
3136: SELECT unit_of_measure INTO l_rma_uom
3137: FROM mtl_units_of_measure
3138: WHERE uom_code = x_MatchedRec.unit_of_measure;
3139: x_MatchedRec.unit_of_measure := l_rma_uom;
3140: -- bug3592116
3141: