APPS.WMS_UT_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 2108: --delete mtl_material_transactions_temp where move_order_line_id = g_trolin_tbl(1).line_id;

2104: l_simulation_mode := 0;
2105: l_simulation_id := 0;
2106:
2107:
2108: --delete mtl_material_transactions_temp where move_order_line_id = g_trolin_tbl(1).line_id;
2109:
2110: l_rule_param := get_value_list(p_data,'RULES');
2111: IF l_rule_param.count > 0 THEN
2112: l_simulation_id := to_number(l_rule_param(1)(3));

Line 2306: FROM mtl_material_transactions_temp mmtt, wms_rules wr1, wms_rules wr2, mtl_transaction_lots_temp mtlt,

2302: mil.segment1 || '.' || mil.segment2 || '.' || mil.segment3 || ', ' || mil2.segment1 || '.' || mil2.segment2 || '.' || mil2.segment3 || ', ' ||
2303: mmtt.TRANSACTION_QUANTITY || ', ' || mmtt.TRANSACTION_UOM || ', ' || mmtt.RESERVATION_ID || ', ' || wr1.name || ', ' || wr2.name as ptext,
2304: nvl(mtlt.LOT_NUMBER,mmtt.lot_number) || ', ' || nvl(mtlt.TRANSACTION_QUANTITY,mmtt.transaction_quantity) as ltext,
2305: mmtt.transaction_temp_id as transaction_temp_id, mtlt.lot_number as lot_number
2306: FROM mtl_material_transactions_temp mmtt, wms_rules wr1, wms_rules wr2, mtl_transaction_lots_temp mtlt,
2307: mtl_item_locations mil, mtl_item_locations mil2
2308: WHERE (p_use_mol = 'Y' AND (mmtt.move_order_line_id = g_demand_tbl(p_di).mo_line_id)
2309: OR (p_use_mol = 'N' AND g_demand_tbl(p_di).demand_source_type_id = mmtt.transaction_source_type_id
2310: AND nvl(g_demand_tbl(p_di).demand_source_header_id,-9999) = nvl(mmtt.transaction_source_id, -9999)

Line 2322: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt

2318: AND mil2.inventory_location_id (+) = mmtt.transfer_to_location;
2319:
2320: CURSOR c_get_msnt_lines(p_tid NUMBER) IS
2321: SELECT msnt.fm_serial_number || ',' || msnt.to_serial_number as stext
2322: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt
2323: WHERE mmtt.transaction_temp_id = p_tid
2324: AND msnt.transaction_temp_id = mmtt.transaction_temp_id
2325: AND msn.serial_number = msnt.fm_serial_number
2326: AND msn.inventory_item_id = mmtt.inventory_item_id;

Line 2330: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt

2326: AND msn.inventory_item_id = mmtt.inventory_item_id;
2327:
2328: CURSOR c_get_msnt_lines_wlot(p_tid NUMBER, p_lot_number VARCHAR2) IS
2329: SELECT msnt.fm_serial_number || ',' || msnt.to_serial_number as stext
2330: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn, mtl_material_transactions_temp mmtt
2331: WHERE mmtt.transaction_temp_id = p_tid
2332: AND msnt.transaction_temp_id = mmtt.transaction_temp_id
2333: AND msn.serial_number = msnt.fm_serial_number
2334: AND msn.lot_number (+) = nvl(p_lot_number,'###')

Line 2593: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

2589: AND inventory_item_id = p_item_id;
2590:
2591: CURSOR c_mmtt (p_item_id NUMBER) IS
2592: SELECT transaction_temp_id
2593: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
2594: WHERE organization_id = p_org_id
2595: AND inventory_item_id = p_item_id;
2596:
2597: CURSOR c_sol (p_item_id NUMBER) IS

Line 2665: DELETE FROM mtl_material_transactions_temp

2661: DELETE FROM mtl_transaction_lots_temp
2662: WHERE transaction_temp_id = c_rec.transaction_temp_id;
2663: END LOOP;
2664:
2665: DELETE FROM mtl_material_transactions_temp
2666: WHERE organization_id = p_org_id
2667: AND inventory_item_id = l_item_id;
2668:
2669: DELETE FROM mtl_reservations