APPS.WMS_PACKING_WORKBENCH_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 4843: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

4839: SELECT mtlt_row_id, mtlt_qty, msnt_row_id
4840: INTO l_mtlt_row_id, l_mtlt_qty, l_msnt_row_id
4841: FROM
4842: (SELECT mtlt.rowid mtlt_row_id, mtlt.primary_quantity mtlt_qty, msnt.rowid msnt_row_id
4843: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
4844: WHERE msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
4845: AND mtlt.transaction_temp_id = p_transaction_temp_id
4846: AND mtlt.lot_number = p_lot_number
4847: AND msnt.fm_serial_number = p_serial_number

Line 4877: FROM mtl_serial_numbers_temp

4873: SELECT t.msnt_row_id
4874: INTO l_msnt_row_id
4875: FROM
4876: (SELECT rowid msnt_row_id
4877: FROM mtl_serial_numbers_temp
4878: WHERE transaction_temp_id = p_transaction_temp_id
4879: AND fm_serial_number = p_serial_number
4880: order by creation_date desc) t
4881: WHERE rownum < 2;

Line 4923: DELETE mtl_serial_numbers_temp

4919: IF p_serial_number IS NOT NULL THEN
4920: IF l_debug = 1 THEN
4921: trace('Deleting MSNT');
4922: END IF;
4923: DELETE mtl_serial_numbers_temp
4924: WHERE rowid = l_msnt_row_id;
4925: l_row_count := SQL%ROWCOUNT;
4926: IF l_debug = 1 THEN
4927: trace(l_row_count||' rows of MSNT deleted with row_id '||l_msnt_row_id);