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.WMS_RETURN_SV dependencies on MTL_LOT_NUMBERS

Line 3215: FROM mtl_lot_numbers

3211: CURSOR c_mtlt(p_lot_number VARCHAR2,p_organization_id NUMBER )
3212: IS
3213: SELECT expiration_date,
3214: origination_date
3215: FROM mtl_lot_numbers
3216: WHERE LOT_NUMBER = p_lot_number
3217: AND ORGANIZATION_ID = p_organization_id ;
3218: CURSOR c_msnt(p_lpn_id NUMBER,p_organization_id NUMBER,p_item_id NUMBER )
3219: IS

Line 4188: l_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE; --Lot Number

4184: l_upd_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
4185: l_upd_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
4186: l_upd_reservation_tbl_cnt NUMBER := 0;
4187: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
4188: l_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE; --Lot Number
4189: l_uom_code VARCHAR2(3); --UOM Code
4190: l_quantity_reserved NUMBER; --Quantity that was reserved
4191: l_reservation_id NUMBER; --Reservation Id
4192: l_error_code NUMBER;