APPS.INV_PICK_RELEASE_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 132: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl

128: x_min_tolerance OUT NOCOPY NUMBER) IS
129:
130: CURSOR c_mo_type IS
131: SELECT move_order_typE
132: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl
133: WHERE mtrl.header_id = mtrh.header_id
134: AND mtrl.line_id = p_mo_line_id;
135:
136: CURSOR c_detail_info IS

Line 1629: UPDATE mtl_txn_request_lines

1625: p_mo_line_rec.pick_slip_number := l_pick_slip_number;
1626: p_mo_line_rec.pick_slip_date := sysdate;
1627: p_mo_line_rec.line_status := 5;
1628:
1629: UPDATE mtl_txn_request_lines
1630: SET quantity_detailed = p_mo_line_rec.quantity,
1631: quantity_delivered = p_mo_line_rec.quantity,
1632: pick_slip_number = l_pick_slip_number,
1633: pick_slip_date = sysdate,

Line 1871: UPDATE mtl_txn_request_lines

1867:
1868: If p_mo_line_rec.to_locator_id <> l_new_to_locator_id AND
1869: p_mo_line_rec.to_locator_id IS NOT NULL Then
1870:
1871: UPDATE mtl_txn_request_lines
1872: SET to_locator_id = l_new_to_locator_id
1873: WHERE line_id = p_mo_line_rec.line_id;
1874:
1875: p_mo_line_rec.to_locator_id := l_new_to_locator_id;

Line 2550: UPDATE MTL_TXN_REQUEST_LINES

2546: p_mo_line_rec.secondary_quantity_detailed:=NVL(p_mo_line_rec.secondary_quantity_delivered,0);
2547: p_mo_line_rec.txn_source_line_id := l_demand_info.oe_line_id;
2548: p_mo_line_rec.pick_slip_date := SYSDATE;
2549:
2550: UPDATE MTL_TXN_REQUEST_LINES
2551: SET quantity_detailed = NVL(p_mo_line_rec.quantity_delivered,0),
2552: secondary_quantity_detailed = NVL(p_mo_line_rec.secondary_quantity_delivered,0),
2553: txn_source_id = l_mso_header_id,
2554: txn_source_line_id = l_demand_info.oe_line_id,

Line 2902: UPDATE MTL_TXN_REQUEST_LINES

2898: p_mo_line_rec.secondary_quantity_detailed := l_sec_quantity_detailed;
2899: p_mo_line_rec.txn_source_id := l_mso_header_id;
2900: p_mo_line_rec.txn_source_line_id := l_demand_info.oe_line_id;
2901: p_mo_line_rec.pick_slip_date := sysdate;
2902: UPDATE MTL_TXN_REQUEST_LINES
2903: SET quantity_detailed = l_quantity_detailed_conv,
2904: secondary_quantity_detailed = l_sec_quantity_detailed,
2905: txn_source_id = l_mso_header_id,
2906: txn_source_line_id = l_demand_info.oe_line_id,

Line 3272: from mtl_txn_request_lines

3268: select quantity_detailed
3269: , secondary_quantity_detailed
3270: into l_quantity_detailed
3271: , l_sec_quantity_detailed
3272: from mtl_txn_request_lines
3273: WHERE line_id = p_mo_line_rec.line_id;
3274: print_debug('Quantity_detailed is '|| l_quantity_detailed,'Inv_Pick_Release_PVT.Process_Line');
3275: print_debug('2nd after select sec Quantity_detailed is '|| l_sec_quantity_detailed, 'Inv_Pick_Release_PVT.Process_Line');
3276: