DBA Data[Home] [Help]

APPS.MTL_MATERIAL_STATUSES_PKG dependencies on MTL_LOT_NUMBERS

Line 488: UPDATE MTL_LOT_NUMBERS SET INVENTORY_ATP_CODE =X_INVENTORY_ATP_CODE,

484: --INVCONV KKILLAMS
485: --Update the Sub Inventory, Lot Number, Serial Number and Location table only if
486: --ATP, Availablity type, Reservable flags modified.
487: IF cur_status%FOUND THEN
488: UPDATE MTL_LOT_NUMBERS SET INVENTORY_ATP_CODE =X_INVENTORY_ATP_CODE,
489: AVAILABILITY_TYPE =X_RESERVABLE_TYPE,
490: RESERVABLE_TYPE =X_AVAILABILITY_TYPE
491: WHERE STATUS_ID = X_STATUS_ID;
492: UPDATE MTL_ITEM_LOCATIONS SET INVENTORY_ATP_CODE =X_INVENTORY_ATP_CODE,