APPS.INV_PICK_RELEASE_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 360: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,wsh_inv_delivery_details_v wdd

356: , mmtt.project_id
357: , mmtt.task_id
358: , mmtt.inventory_item_id
359: , mmtt.revision
360: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,wsh_inv_delivery_details_v wdd
361: WHERE mmtt.move_order_line_id = mol.line_id
362: AND mol.header_id = p_move_order_header_id
363: AND wdd.move_order_line_id = mol.line_id
364: AND mmtt.pick_slip_number IS NULL;

Line 2071: update mtl_txn_request_lines

2067: end if;
2068:
2069: --close the move order line
2070: -- HW INVCONV Update Qty2
2071: update mtl_txn_request_lines
2072: set quantity = 0
2073: ,quantity_detailed = 0
2074: ,secondary_quantity = decode(secondary_quantity,fnd_api.g_miss_num, NULL, 0)
2075: ,secondary_quantity_detailed = decode(secondary_quantity_detailed,fnd_api.g_miss_num, NULL, 0)

Line 2444: update mtl_txn_request_lines

2440:
2441: -- Update mo line with new quantity and model quantity;
2442: --If mo line quantity is 0, close the move order line
2443: IF l_new_line_quantity = 0 THEN
2444: update mtl_txn_request_lines
2445: set quantity = 0
2446: ,quantity_detailed = 0
2447: ,line_status = 5
2448: ,status_date =sysdate --BUG 7560455

Line 2454: update mtl_txn_request_lines

2450: where line_id = l_mo_line.line_id;
2451: l_mo_line_tbl(l_set_index).quantity_detailed := 0;
2452: l_mo_line_tbl(l_set_index).line_status := 5;
2453: ELSE
2454: update mtl_txn_request_lines
2455: set quantity = l_new_line_quantity
2456: ,quantity_detailed = NULL
2457: ,model_quantity = l_new_model_quantity
2458: where line_id = l_mo_line.line_id;

Line 2922: UPDATE mtl_txn_request_lines

2918: -- Update the current move order line depending on how much quantity
2919: -- was successfully allocated from inventory.
2920: IF (l_transaction_quantity = 0) THEN
2921: -- Close the move order line created since no quantity was allocated
2922: UPDATE mtl_txn_request_lines
2923: SET line_status = 5,
2924: status_date =sysdate, --BUG 7560455
2925: quantity = l_transaction_quantity,
2926: secondary_quantity = DECODE(secondary_quantity, fnd_api.g_miss_num, NULL,

Line 2949: UPDATE mtl_txn_request_lines

2945: ELSE
2946: --Bug 9199956 The primary quantity in mtrl should match the quantity in primary uom. Since for Pick Wave move orders
2947: --The uom is always primary uom setting it to quantity value.
2948: -- Update the move order line to the partial quantity that was allocated
2949: UPDATE mtl_txn_request_lines
2950: SET quantity = l_transaction_quantity,
2951: secondary_quantity = DECODE(secondary_quantity, fnd_api.g_miss_num, NULL,
2952: l_transaction_quantity2)
2953: ,primary_quantity=l_transaction_quantity

Line 3073: DELETE FROM mtl_txn_request_lines mtrl

3069: IF is_debug THEN
3070: print_debug('Deleting MOLs in status 5','Inv_Pick_Release_Pub.Pick_Release');
3071: END IF;
3072: FORALL ii IN l_mol_id_tbl.FIRST..l_mol_id_tbl.LAST
3073: DELETE FROM mtl_txn_request_lines mtrl
3074: WHERE line_status = 5
3075: AND line_id = l_mol_id_tbl(ii)
3076: AND EXISTS
3077: ( SELECT 'x'