APPS.INV_PICK_RELEASE_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 146: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl

142: x_min_tolerance2 OUT NOCOPY NUMBER ) IS
143:
144: CURSOR c_mo_type IS
145: SELECT move_order_typE
146: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl
147: WHERE mtrl.header_id = mtrh.header_id
148: AND mtrl.line_id = p_mo_line_id;
149:
150: CURSOR c_detail_info IS

Line 1922: UPDATE mtl_txn_request_lines

1918: print_debug('p_mo_line_rec.quantity '|| p_mo_line_rec.quantity, 'Inv_Pick_Release_Pvt.Process_Unreservable_Items');
1919: print_debug('p_mo_line_rec.quantity '|| p_mo_line_rec.quantity, 'Inv_Pick_Release_Pvt.Process_Unreservable_Items');
1920: END IF;
1921:
1922: UPDATE mtl_txn_request_lines
1923: SET quantity_detailed = p_mo_line_rec.quantity,
1924: quantity_delivered = p_mo_line_rec.quantity,
1925: pick_slip_number = l_pick_slip_number,
1926: pick_slip_date = sysdate,

Line 2165: UPDATE mtl_txn_request_lines

2161:
2162: If p_mo_line_rec.to_locator_id <> l_new_to_locator_id AND
2163: p_mo_line_rec.to_locator_id IS NOT NULL Then
2164:
2165: UPDATE mtl_txn_request_lines
2166: SET to_locator_id = l_new_to_locator_id
2167: WHERE line_id = p_mo_line_rec.line_id;
2168:
2169: p_mo_line_rec.to_locator_id := l_new_to_locator_id;

Line 2937: UPDATE MTL_TXN_REQUEST_LINES

2933: IF (is_debug) THEN
2934: print_debug('p_mo_line_rec.quantity_delivered '||p_mo_line_rec.quantity_delivered, 'Inv_Pick_Release_PVT.Process_Line');
2935: print_debug('p_mo_line_rec.secondary_quantity_delivered '||p_mo_line_rec.secondary_quantity_delivered, 'Inv_Pick_Release_PVT.Process_Line');
2936: end if;
2937: UPDATE MTL_TXN_REQUEST_LINES
2938: SET quantity_detailed = NVL(p_mo_line_rec.quantity_delivered,0),
2939: secondary_quantity_detailed = NVL(p_mo_line_rec.secondary_quantity_delivered,0),
2940: txn_source_id = l_mso_header_id,
2941: txn_source_line_id = l_demand_info.oe_line_id,

Line 3353: UPDATE MTL_TXN_REQUEST_LINES

3349: print_debug('Quantity_detailed is '|| l_quantity_detailed_conv, 'Inv_Pick_Release_PVT.Process_Line');
3350: print_debug('sec Quantity_detailed is '|| l_sec_quantity_detailed, 'Inv_Pick_Release_PVT.Process_Line');
3351: END IF;
3352:
3353: UPDATE MTL_TXN_REQUEST_LINES
3354: SET quantity_detailed = l_quantity_detailed_conv,
3355: secondary_quantity_detailed = l_sec_quantity_detailed,
3356: txn_source_id = l_mso_header_id,
3357: txn_source_line_id = l_demand_info.oe_line_id,

Line 3759: from mtl_txn_request_lines

3755: select quantity_detailed
3756: , secondary_quantity_detailed
3757: into l_quantity_detailed
3758: , l_sec_quantity_detailed
3759: from mtl_txn_request_lines
3760: WHERE line_id = p_mo_line_rec.line_id;
3761: print_debug('Quantity_detailed is '|| l_quantity_detailed,'Inv_Pick_Release_PVT.Process_Line');
3762: print_debug('2nd after select sec Quantity_detailed is '|| l_sec_quantity_detailed, 'Inv_Pick_Release_PVT.Process_Line');
3763: