eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_TRANSACTIONS_PVT dependencies on MTL_LOT_NUMBERS

Line 4426: FROM mtl_lot_numbers

4422: l_expire_date DATE;
4423: l_api_name CONSTANT VARCHAR2 (30) := 'is_lot_expired';
4424: CURSOR Cur_lot_expire IS
4425: SELECT expiration_date
4426: FROM mtl_lot_numbers
4427: WHERE organization_id = p_organization_id
4428: AND inventory_item_id = p_inventory_item_id
4429: AND lot_number = p_lot_number;
4430: BEGIN

Line 4698: FROM mtl_lot_numbers

4694: p_lot_number IN VARCHAR2,
4695: x_return_status OUT NOCOPY VARCHAR2) IS
4696: CURSOR Cur_get_lot IS
4697: SELECT expiration_date
4698: FROM mtl_lot_numbers
4699: WHERE organization_id = p_organization_id
4700: AND inventory_item_id = p_inventory_item_id
4701: AND lot_number = p_lot_number;
4702: l_api_name CONSTANT VARCHAR2(30) := 'validate_lot_for_ing';