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 1983: update mtl_txn_request_lines

1979: end if;
1980:
1981: --close the move order line
1982: -- HW INVCONV Update Qty2
1983: update mtl_txn_request_lines
1984: set quantity = 0
1985: ,quantity_detailed = 0
1986: ,secondary_quantity = decode(secondary_quantity,fnd_api.g_miss_num, NULL, 0)
1987: ,secondary_quantity_detailed = decode(secondary_quantity_detailed,fnd_api.g_miss_num, NULL, 0)

Line 2355: update mtl_txn_request_lines

2351:
2352: -- Update mo line with new quantity and model quantity;
2353: --If mo line quantity is 0, close the move order line
2354: IF l_new_line_quantity = 0 THEN
2355: update mtl_txn_request_lines
2356: set quantity = 0
2357: ,quantity_detailed = 0
2358: ,line_status = 5
2359: ,model_quantity = l_new_model_quantity

Line 2364: update mtl_txn_request_lines

2360: where line_id = l_mo_line.line_id;
2361: l_mo_line_tbl(l_set_index).quantity_detailed := 0;
2362: l_mo_line_tbl(l_set_index).line_status := 5;
2363: ELSE
2364: update mtl_txn_request_lines
2365: set quantity = l_new_line_quantity
2366: ,quantity_detailed = NULL
2367: ,model_quantity = l_new_model_quantity
2368: where line_id = l_mo_line.line_id;

Line 2777: UPDATE mtl_txn_request_lines

2773: -- Update the current move order line depending on how much quantity
2774: -- was successfully allocated from inventory.
2775: IF (l_transaction_quantity = 0) THEN
2776: -- Close the move order line created since no quantity was allocated
2777: UPDATE mtl_txn_request_lines
2778: SET line_status = 5,
2779: quantity = l_transaction_quantity,
2780: secondary_quantity = DECODE(secondary_quantity, fnd_api.g_miss_num, NULL,
2781: l_transaction_quantity2)

Line 2801: UPDATE mtl_txn_request_lines

2797: p_wsh_release_table(l_wdd_index_tbl(l_delivery_detail_id)).released_status := 'B';
2798: END IF;
2799: ELSE
2800: -- Update the move order line to the partial quantity that was allocated
2801: UPDATE mtl_txn_request_lines
2802: SET quantity = l_transaction_quantity,
2803: secondary_quantity = DECODE(secondary_quantity, fnd_api.g_miss_num, NULL,
2804: l_transaction_quantity2)
2805: WHERE line_id = l_mo_line.line_id;

Line 2899: DELETE FROM mtl_txn_request_lines mtrl

2895: IF is_debug THEN
2896: print_debug('Deleting MOLs in status 5','Inv_Pick_Release_Pub.Pick_Release');
2897: END IF;
2898: FORALL ii IN l_mol_id_tbl.FIRST..l_mol_id_tbl.LAST
2899: DELETE FROM mtl_txn_request_lines mtrl
2900: WHERE line_status = 5
2901: AND line_id = l_mol_id_tbl(ii)
2902: AND EXISTS
2903: ( SELECT 'x'