INV Lot Upload

➜ Back to Library
Description
Categories: Enginatics, Upload
Repository: Github
Updates the expiration and other dates of existing lots, as in the Lot Numbers form (Inventory > On-hand, Availability > Lots).

Download existing lots with Upload Mode Create, Update, or use Create for an empty sheet and paste Organization Code, Item, Lot Number and the new dates. Every row updates an existing lot; new lots are created by receipt transactions.

Expiration Date, Expira ...  Updates the expiration and other dates of existing lots, as in the Lot Numbers form (Inventory > On-hand, Availability > Lots).

Download existing lots with Upload Mode Create, Update, or use Create for an empty sheet and paste Organization Code, Item, Lot Number and the new dates. Every row updates an existing lot; new lots are created by receipt transactions.

Expiration Date, Expiration Action Date and Retest Date can be changed only for items under shelf life control, and the Expiration Date of such an item cannot be cleared. Changing the Origination Date does not recalculate the other dates. Clearing the Expiration Action Date also clears the Expiration Action.   more 
select
null action_,
null status_,
null message_,
to_number(null) request_id_,
null modified_columns_,
mp.organization_code,
msiv.concatenated_segments item,
msiv.description item_description,
mln.lot_number,
mln.parent_lot_number parent_lot,
xxen_util.meaning(msiv.shelf_life_code,'MTL_SHELF_LIFE',700) shelf_life_control,
mln.origination_date,
mln.expiration_date,
mln.expiration_action_code expiration_action,
mln.expiration_action_date,
mln.retest_date,
mln.maturity_date,
mln.hold_date,
to_number(null) upload_row
from
mtl_parameters mp,
mtl_system_items_vl msiv,
mtl_lot_numbers mln
where
mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
mp.organization_id=msiv.organization_id and
msiv.organization_id=mln.organization_id and
msiv.inventory_item_id=mln.inventory_item_id and
:p_upload_mode like '%'||xxen_upload.action_update and
1=1
Parameter NameSQL textValidation
Upload Mode
 
LOV
Organization Code
mp.organization_code=:organization_code
LOV
Item
msiv.concatenated_segments=:item
LOV
Lot Number
mln.lot_number=:lot_number
LOV
Expiration Date From
mln.expiration_date>=:expiration_date_from
Date
Expiration Date To
mln.expiration_date<:expiration_date_to+1
Date
Download
Related Blitz Reports
INV Material Transactions2 CAC Onhand Lot Value (Real-Time) INV Material Transactions INV Item Upload CAC Inventory Lot and Locator OPM Value (Period-End) CAC Material Account Alias with Lot Numbers EC: INV Item Upload INV Physical Inventory Locator Count Sheet OPM Batch Lot Genealogy
Blitz Report™