OPM_LOT_UPDATE

--/update MTL_LOT_NUMBERS set creation_date='31/MAR/2011'
where inventory_item_id=33064 and
lot_number='12031020-OLD-LOT'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33043 and
lot_number='11700394-Backlog'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='31/MAR/2011'
where inventory_item_id=33033 and
lot_number='11700315-OLD-LOT'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='31/MAR/2011'
where inventory_item_id=33034 and
lot_number='11700316-OLD-LOT'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33034 and
lot_number='11700316-BACKLOG-LOT'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='31/MAR/2011'
where inventory_item_id=33035 and
lot_number='11700317-OLD-LOT'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33035 and
lot_number='11700317-BACKLOG-LOT'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33036 and
lot_number='11700318-BACKLOG-LOT'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33055 and
lot_number='11700319-BACKLOG-LOT'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33037 and
lot_number='11700320-BACKLOG-LOT'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33022 and
lot_number='11010020-Backlog'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33044 and
lot_number='11700416-Backlog'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33038 and
lot_number='11700351-Backlog'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33023 and
lot_number='11700141-Backlog'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33039 and
lot_number='11700369-Backlog'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='31/MAR/2011'
where inventory_item_id=33039 and
lot_number='11700369-OLD-LOT'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='31/MAR/2011'
where inventory_item_id=33041 and
lot_number='11700371-OLD-LOT'
AND ORGANIZATION_ID=135

--update MTL_LOT_NUMBERS set creation_date='31/MAR/2011'
where inventory_item_id=33057 and
lot_number='11700356-OLD-LOT'
AND ORGANIZATION_ID=135

update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33020 and
lot_number='11000001-BACKLOG-LOT'
AND ORGANIZATION_ID=135

update MTL_LOT_NUMBERS set creation_date='29/APR/2011'
where inventory_item_id=33020 and
lot_number='11000001-Backlog'
AND ORGANIZATION_ID=135

update MTL_LOT_NUMBERS set creation_date='31/MAR/2011'
where inventory_item_id=33022 and
lot_number='11010020-OLD-LOT'
AND ORGANIZATION_ID=135

update MTL_LOT_NUMBERS set creation_date='30/JUL/2011'
where inventory_item_id=33033 and
lot_number='11700315-BACKLOG-LOT'
AND ORGANIZATION_ID=135

update MTL_LOT_NUMBERS set creation_date='01/APR/2011'
where inventory_item_id=33037 and
lot_number='11700320-OLD-LOT'
AND ORGANIZATION_ID=135

update MTL_LOT_NUMBERS set creation_date='01/APR/2011'
where inventory_item_id=33021 and
lot_number='11000050-OLD-LOT'
AND ORGANIZATION_ID=135