DBA Data[Home] [Help]

APPS.MTL_QP_PRICE dependencies on MTL_UNITS_OF_MEASURE

Line 2373: FROM mtl_units_of_measure

2369: g_line_quantity_tbl(px_line_index) := p_line_rec.quantity;
2370:
2371: SELECT uom_code
2372: INTO g_line_uom_code_tbl(px_line_index)
2373: FROM mtl_units_of_measure
2374: WHERE unit_of_measure = p_line_rec.unit_meas_lookup_code;
2375:
2376: /* Bug Fix: 4324982*/
2377: /* Commenting out the below assignment since it is just populated correctly by the above SQL */

Line 2527: FROM rcv_transactions rcv, po_lines_all pol, mtl_units_of_measure um

2523: SELECT rcv.po_line_id
2524: , rcv.po_header_id
2525: INTO l_line_id
2526: , l_header_id
2527: FROM rcv_transactions rcv, po_lines_all pol, mtl_units_of_measure um
2528: WHERE rcv.transaction_id = p_transaction_id
2529: AND rcv.po_line_id = pol.po_line_id
2530: AND rcv.unit_of_measure = um.unit_of_measure;
2531: