APPS.WMS_PACKING_WORKBENCH_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1841: l_table_name := 'MTL_SERIAL_NUMBERS';

1837: l_table_name := 'MTL_LOT_NUMBERS';
1838: l_flex_name := 'Lot Attributes';
1839: l_context_column := 'LOT_ATTRIBUTE_CATEGORY';
1840: ELSIF p_lot_or_serial = 'SERIAL' THEN
1841: l_table_name := 'MTL_SERIAL_NUMBERS';
1842: l_flex_name := 'Serial Attributes';
1843: l_context_column := 'SERIAL_ATTRIBUTE_CATEGORY';
1844: END IF;
1845:

Line 3388: from mtl_serial_numbers a

3384: , inspection_status
3385: INTO l_current_status
3386: , l_ser_lot_number
3387: , l_ser_inspection_status
3388: from mtl_serial_numbers a
3389: where serial_number = p_fm_serial_number
3390: and current_organization_id = p_organization_id
3391: and inventory_item_id = p_inventory_item_id
3392: and rownum<2;

Line 3757: FROM mtl_serial_numbers

3753: -- Get default attribute if it is a new serial
3754: l_new_serial := 0;
3755: BEGIN
3756: SELECT 1 INTO l_new_serial
3757: FROM mtl_serial_numbers
3758: WHERE current_organization_id = p_organization_id
3759: AND inventory_item_id = p_inventory_item_id
3760: AND nvl(lot_number, '#$%') = nvl(p_lot_number, nvl(lot_number, '#$%'))
3761: AND serial_number = p_fm_serial_number;

Line 3878: UPDATE mtl_serial_numbers

3874: END IF;
3875: x_serial_transaction_temp_id := nvl(l_ser_txn_id,l_txn_tmp_id);
3876: -- Mark Serial Number
3877: BEGIN
3878: UPDATE mtl_serial_numbers
3879: SET GROUP_MARK_ID = l_txn_tmp_id
3880: WHERE current_organization_id = p_organization_id
3881: AND inventory_item_id = p_inventory_item_id
3882: --AND nvl(lot_number, '#$%') = nvl(p_lot_number, nvl(lot_number, '#$%'))

Line 3965: FROM mtl_serial_numbers

3961: -- Get default attribute if it is a new serial
3962: l_new_serial := 0;
3963: BEGIN
3964: SELECT 1 INTO l_new_serial
3965: FROM mtl_serial_numbers
3966: WHERE current_organization_id = p_organization_id
3967: AND inventory_item_id = p_inventory_item_id
3968: AND nvl(lot_number, '#$%') = nvl(p_lot_number, nvl(lot_number, '#$%'))
3969: AND serial_number = p_fm_serial_number;

Line 4104: UPDATE mtl_serial_numbers

4100: END IF;*/
4101: x_serial_transaction_temp_id := nvl(l_cur_rec.serial_transaction_temp_id, p_transaction_temp_id);
4102: -- Mark Serial Number
4103: BEGIN
4104: UPDATE mtl_serial_numbers
4105: SET GROUP_MARK_ID = p_transaction_temp_id
4106: WHERE current_organization_id = p_organization_id
4107: AND inventory_item_id = p_inventory_item_id
4108: --AND nvl(lot_number, '#$%') = nvl(p_lot_number, nvl(lot_number, '#$%'))

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