[Home] [Help]
20: --
21: -- Procedure : create_pick
22: -- Purpose : Creates picklist headers and details for spares
23: -- It calls the Auto_Detail API of Oracle Inventory
24: -- which creates records in mtl_material_transactions_temp
25: -- and the lot and serial temp tables
26: --
27: -- MODIFICATION HISTORY
28: -- Person Date Comments
298: ,inventory_item_id
299: ,revision
300: ,transaction_quantity
301: ,transaction_uom
302: FROM mtl_material_transactions_temp
303: WHERE move_order_line_id = l_line_id
304: --AND transfer_subinventory = decode(l_to_sub, null, transfer_subinventory, l_to_sub)
305: --AND subinventory_code = decode(l_from_sub, null, subinventory_code, l_from_sub)
306: AND transaction_type_id = 64
522: (p_order_by = 5 and mo_line_cur_created_by%NOTFOUND));
523:
524: l_line_id := mo_line_rec.line_id;
525:
526: SELECT mtl_material_transactions_s.nextval
527: INTO l_txn_header_id
528: FROM dual;
529:
530: -- This code is used for auto detailing serial numbers
857: WHERE picklist_header_id = p_picklist_header_id;
858:
859: CURSOR l_Get_Mmtt_Csr (l_transaction_temp_id NUMBER) IS
860: SELECT item_serial_control_code, item_lot_control_code
861: FROM mtl_material_transactions_temp
862: WHERE organization_id = p_organization_id
863: AND transaction_temp_id = l_transaction_temp_id;
864:
865: CURSOR l_Get_Mtlt_Csr (l_transaction_temp_id NUMBER) IS
1545: -- ADDED by phegde 02/23
1546: WMS_TASK_TYPE ,
1547: PARENT_LINE_ID
1548: --SOURCE_LOT_NUMBER
1549: FROM mtl_material_transactions_temp
1550: WHERE transaction_temp_id = p_transaction_temp_id
1551: AND organization_id = p_organization_id;
1552: BEGIN
1553: SAVEPOINT Update_Misc_MMTT_PUB;
2499: oe_order_lines_all oola,
2500: rcv_shipment_lines rsl,
2501: (SELECT transaction_date,
2502: transaction_source_id
2503: FROM mtl_material_transactions
2504: WHERE transaction_source_type_id IN (3, 7)
2505: AND transaction_action_id = 12
2506: ) mmt
2507: WHERE prl.requisition_line_id = rsl.requisition_line_id