APPS.WMS_PACKING_WORKBENCH_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 4677: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

4673: SELECT mtlt_row_id, mtlt_qty, msnt_row_id
4674: INTO l_mtlt_row_id, l_mtlt_qty, l_msnt_row_id
4675: FROM
4676: (SELECT mtlt.rowid mtlt_row_id, mtlt.primary_quantity mtlt_qty, msnt.rowid msnt_row_id
4677: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
4678: WHERE msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
4679: AND mtlt.transaction_temp_id = p_transaction_temp_id
4680: AND mtlt.lot_number = p_lot_number
4681: AND msnt.fm_serial_number = p_serial_number

Line 4711: FROM mtl_serial_numbers_temp

4707: SELECT t.msnt_row_id
4708: INTO l_msnt_row_id
4709: FROM
4710: (SELECT rowid msnt_row_id
4711: FROM mtl_serial_numbers_temp
4712: WHERE transaction_temp_id = p_transaction_temp_id
4713: AND fm_serial_number = p_serial_number
4714: order by creation_date desc) t
4715: WHERE rownum < 2;

Line 4757: DELETE mtl_serial_numbers_temp

4753: IF p_serial_number IS NOT NULL THEN
4754: IF l_debug = 1 THEN
4755: trace('Deleting MSNT');
4756: END IF;
4757: DELETE mtl_serial_numbers_temp
4758: WHERE rowid = l_msnt_row_id;
4759: l_row_count := SQL%ROWCOUNT;
4760: IF l_debug = 1 THEN
4761: trace(l_row_count||' rows of MSNT deleted with row_id '||l_msnt_row_id);