APPS.WMS_UT_PKG dependencies on MTL_TRANSACTION_LOTS_TEMP

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 2339: FROM mtl_transaction_lots_temp

2335: AND msn.inventory_item_id = mmtt.inventory_item_id;
2336:
2337: CURSOR c_get_mtlt_lines(p_tid NUMBER) IS
2338: SELECT 'MTLT ' || ROWNUM || ' : ' || TRANSACTION_TEMP_ID || ', ' || LOT_NUMBER || ', ' || TRANSACTION_QUANTITY as ptext
2339: FROM mtl_transaction_lots_temp
2340: WHERE transaction_temp_id = p_tid;
2341:
2342: l_ix NUMBER;
2343: l_mo_line_id NUMBER;

Line 2661: DELETE FROM mtl_transaction_lots_temp

2657: FOR c_rec in c_mmtt(l_item_id) LOOP
2658: DELETE FROM mtl_serial_numbers_temp
2659: WHERE transaction_temp_id = c_rec.transaction_temp_id;
2660:
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