[Home] [Help]
115: ,mtrl.quantity
116: FROM mtl_item_locations_kfv milk,
117: mtl_system_items_b_kfv msibk,
118: csp_moveorder_lines cmol,
119: mtl_txn_request_lines mtrl,
120: mtl_txn_request_headers mtrh
121: WHERE mtrl.line_status in (3,7)
122: AND mtrl.transaction_type_id = 64 -- Subinventory Transfer = 64, Account Transfer = 63
123: AND ( (p_move_order_type = 1 and mtrh.move_order_type = 1) -- Move Order Requistion
152: ,mtrl.quantity
153: FROM mtl_item_locations_kfv milk,
154: mtl_system_items_b_kfv msibk,
155: csp_moveorder_lines cmol,
156: mtl_txn_request_lines mtrl,
157: mtl_txn_request_headers mtrh
158: WHERE mtrl.line_status in (3,7)
159: AND mtrl.transaction_type_id = 64 -- Subinventory Transfer = 64, Account Transfer = 63
160: AND ( (p_move_order_type = 1 and mtrh.move_order_type = 1) -- Move Order Requistion
189: ,mtrl.quantity
190: FROM mtl_item_locations_kfv milk,
191: mtl_system_items_b_kfv msibk,
192: csp_moveorder_lines cmol,
193: mtl_txn_request_lines mtrl,
194: mtl_txn_request_headers mtrh
195: WHERE mtrl.line_status in (3,7)
196: AND mtrl.transaction_type_id = 64 -- Subinventory Transfer = 64, Account Transfer = 63
197: AND ( (p_move_order_type = 1 and mtrh.move_order_type = 1) -- Move Order Requistion
226: ,mtrl.quantity
227: FROM mtl_item_locations_kfv milk,
228: mtl_system_items_b_kfv msibk,
229: csp_moveorder_lines cmol,
230: mtl_txn_request_lines mtrl,
231: mtl_txn_request_headers mtrh
232: WHERE mtrl.line_status in (3,7)
233: AND mtrl.transaction_type_id = 64 -- Subinventory Transfer = 64, Account Transfer = 63
234: AND ( (p_move_order_type = 1 and mtrh.move_order_type = 1) -- Move Order Requistion
263: ,mtrl.quantity
264: FROM mtl_item_locations_kfv milk,
265: mtl_system_items_b_kfv msibk,
266: csp_moveorder_lines cmol,
267: mtl_txn_request_lines mtrl,
268: mtl_txn_request_headers mtrh
269: WHERE mtrl.line_status in (3,7)
270: AND mtrl.transaction_type_id = 64 -- Subinventory Transfer = 64, Account Transfer = 63
271: AND ( (p_move_order_type = 1 and mtrh.move_order_type = 1) -- Move Order Requistion
309: CURSOR mo_replen_cur IS
310: SELECT mtrl.header_id
311: ,mtrl.line_id
312: FROM mtl_txn_request_headers mtrh
313: ,mtl_txn_request_lines mtrl
314: WHERE mtrl.header_id = mtrh.header_id
315: AND mtrl.line_status = 7
316: AND mtrh.move_order_type = 2
317: AND mtrl.from_subinventory_code = nvl(p_from_subinventory, mtrl.from_subinventory_code)
585: END IF;
586:
587: IF (l_num_of_rows >= 1) THEN
588:
589: -- update mtl_txn_request_lines with the detailed quantity
590: l_trolin_rec := INV_Trolin_util.Query_Row( mo_line_rec.line_id );
591: l_trolin_rec.quantity_detailed := l_detailed_qty;
592: l_trolin_rec.last_update_date := SYSDATE;
593: l_trolin_rec.last_updated_by := FND_GLOBAL.USER_ID;
594: l_trolin_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
595:
596: INV_Trolin_Util.Update_Row(l_trolin_rec);
597:
598: /* update mtl_txn_request_lines
599: set quantity_detailed = l_detailed_qty
600: where line_id = mo_line_rec.line_id; */
601:
602:
1249: IF l_Get_Picklist_Lines_Csr%ISOPEN THEN
1250: CLOSE l_Get_Picklist_Lines_Csr;
1251: END IF;
1252:
1253: -- update the quantity_detailed in the mtl_txn_request_lines
1254: /* Save_Pick (
1255: P_Api_Version_Number => l_api_version_number
1256: ,P_Init_Msg_List => FND_API.G_TRUE
1257: ,P_Commit => FND_API.G_FALSE
1689: ------------------------
1690: -- Start of Comments
1691: -- Procedure : Save_Pick
1692: -- Purpose : This procedure saves the headers and lines for the specified
1693: -- picklist and updates the quantity detailed in mtl_txn_request_lines
1694: --
1695: -- History :
1696: -- UserID Date Comments
1697: -- ----------- -------- --------------------------