APPS.WMS_PACKING_WORKBENCH_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1912: l_table_name := 'MTL_SERIAL_NUMBERS';

1908: l_table_name := 'MTL_LOT_NUMBERS';
1909: l_flex_name := 'Lot Attributes';
1910: l_context_column := 'LOT_ATTRIBUTE_CATEGORY';
1911: ELSIF p_lot_or_serial = 'SERIAL' THEN
1912: l_table_name := 'MTL_SERIAL_NUMBERS';
1913: l_flex_name := 'Serial Attributes';
1914: l_context_column := 'SERIAL_ATTRIBUTE_CATEGORY';
1915: END IF;
1916:

Line 3554: from mtl_serial_numbers a

3550: , inspection_status
3551: INTO l_current_status
3552: , l_ser_lot_number
3553: , l_ser_inspection_status
3554: from mtl_serial_numbers a
3555: where serial_number = p_fm_serial_number
3556: and current_organization_id = p_organization_id
3557: and inventory_item_id = p_inventory_item_id
3558: and rownum<2;

Line 3923: FROM mtl_serial_numbers

3919: -- Get default attribute if it is a new serial
3920: l_new_serial := 0;
3921: BEGIN
3922: SELECT 1 INTO l_new_serial
3923: FROM mtl_serial_numbers
3924: WHERE current_organization_id = p_organization_id
3925: AND inventory_item_id = p_inventory_item_id
3926: AND nvl(lot_number, '#$%') = nvl(p_lot_number, nvl(lot_number, '#$%'))
3927: AND serial_number = p_fm_serial_number;

Line 4044: UPDATE mtl_serial_numbers

4040: END IF;
4041: x_serial_transaction_temp_id := nvl(l_ser_txn_id,l_txn_tmp_id);
4042: -- Mark Serial Number
4043: BEGIN
4044: UPDATE mtl_serial_numbers
4045: SET GROUP_MARK_ID = l_txn_tmp_id
4046: WHERE current_organization_id = p_organization_id
4047: AND inventory_item_id = p_inventory_item_id
4048: --AND nvl(lot_number, '#$%') = nvl(p_lot_number, nvl(lot_number, '#$%'))

Line 4131: FROM mtl_serial_numbers

4127: -- Get default attribute if it is a new serial
4128: l_new_serial := 0;
4129: BEGIN
4130: SELECT 1 INTO l_new_serial
4131: FROM mtl_serial_numbers
4132: WHERE current_organization_id = p_organization_id
4133: AND inventory_item_id = p_inventory_item_id
4134: AND nvl(lot_number, '#$%') = nvl(p_lot_number, nvl(lot_number, '#$%'))
4135: AND serial_number = p_fm_serial_number;

Line 4270: UPDATE mtl_serial_numbers

4266: END IF;*/
4267: x_serial_transaction_temp_id := nvl(l_cur_rec.serial_transaction_temp_id, p_transaction_temp_id);
4268: -- Mark Serial Number
4269: BEGIN
4270: UPDATE mtl_serial_numbers
4271: SET GROUP_MARK_ID = p_transaction_temp_id
4272: WHERE current_organization_id = p_organization_id
4273: AND inventory_item_id = p_inventory_item_id
4274: --AND nvl(lot_number, '#$%') = nvl(p_lot_number, nvl(lot_number, '#$%'))

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);