APPS.INV_STATUS_PKG dependencies on MTL_LOT_NUMBERS

Line 56: MTL_LOT_NUMBERS mln

52:
53: select mms.status_code
54: into x_status_code
55: from mtl_material_statuses mms ,
56: MTL_LOT_NUMBERS mln
57: where mms.status_id = mln.status_id
58: and mln.LOT_NUMBER = p_lot
59: and mln.organization_id = p_org_id
60: and mln.inventory_item_id = p_item_id;

Line 116: FROM MTL_LOT_NUMBERS

112:
113:
114: cursor lot_cur is
115: SELECT status_id
116: FROM MTL_LOT_NUMBERS
117: WHERE organization_id = p_org_id
118: AND inventory_item_id = p_item_id
119: AND lot_number BETWEEN p_from_lot AND p_to_lot;
120: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 296: FROM MTL_LOT_NUMBERS

292: rowid_list1 rowidtab1;
293:
294: cursor cur_lot_number is
295: SELECT lot_number
296: FROM MTL_LOT_NUMBERS
297: WHERE organization_id = p_organization_id
298: AND inventory_item_id = p_inventory_item_id
299: AND lot_number between p_from_lot_number and p_to_lot_number;
300:

Line 424: update mtl_lot_numbers

420: IF (l_debug = 1) THEN
421: mdebug('p_lot_status_id: '||p_lot_status_id);
422: END IF;
423: if p_lot_status_id >0 then
424: update mtl_lot_numbers
425: set status_id = p_lot_status_id
426: , last_updated_by = FND_GLOBAL.USER_ID
427: , last_update_date = SYSDATE
428: , last_update_login = FND_GLOBAL.LOGIN_ID