APPS.INV_STATUS_PKG dependencies on MTL_LOT_NUMBERS

Line 77: MTL_LOT_NUMBERS mln

73:
74: select mms.status_code
75: into x_status_code
76: from mtl_material_statuses mms ,
77: MTL_LOT_NUMBERS mln
78: where mms.status_id = mln.status_id
79: and mln.LOT_NUMBER = p_lot
80: and mln.organization_id = p_org_id
81: and mln.inventory_item_id = p_item_id;

Line 172: FROM MTL_LOT_NUMBERS

168:
169:
170: cursor lot_cur is
171: SELECT status_id
172: FROM MTL_LOT_NUMBERS
173: WHERE organization_id = p_org_id
174: AND inventory_item_id = p_item_id
175: AND lot_number BETWEEN p_from_lot AND p_to_lot;
176: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 374: select mln.rowid FROM mtl_lot_numbers mln,

370: FOR UPDATE NOWAIT;
371:
372:
373: CURSOR cur_Lot IS
374: select mln.rowid FROM mtl_lot_numbers mln,
375: mtl_material_status_history mmsh
376: where mln.organization_id = mmsh.organization_id
377: and mln.inventory_item_id = mmsh.inventory_item_id
378: AND mln.lot_number = mmsh.lot_number

Line 507: update mtl_lot_numbers

503: OPEN cur_Lot;
504: FETCH cur_Lot BULK COLLECT INTO rowid_list ;
505:
506: FORALL j in rowid_list.first .. rowid_list.last
507: update mtl_lot_numbers
508: set status_id = p_status_id
509: , last_updated_by = FND_GLOBAL.USER_ID
510: , last_update_date = SYSDATE
511: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 619: FROM MTL_LOT_NUMBERS

615: rowid_list1 rowidtab1;
616:
617: cursor cur_lot_number is
618: SELECT lot_number
619: FROM MTL_LOT_NUMBERS
620: WHERE organization_id = p_organization_id
621: AND inventory_item_id = p_inventory_item_id
622: AND lot_number between p_from_lot_number and p_to_lot_number;
623:

Line 908: update mtl_lot_numbers

904:
905: --ERES Deferred
906:
907: IF p_pending_status = 0 THEN --ERES Deferred
908: update mtl_lot_numbers
909: set status_id = p_lot_status_id
910: , last_updated_by = FND_GLOBAL.USER_ID
911: , last_update_date = SYSDATE
912: , last_update_login = FND_GLOBAL.LOGIN_ID