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.OE_ORDER_PURGE_PVT dependencies on OE_LOT_SERIAL_NUMBERS

Line 3524: FROM oe_lot_serial_numbers

3520: RETURN VARCHAR2
3521: IS
3522: CURSOR c_line_lot_serials IS
3523: SELECT lot_serial_id
3524: FROM oe_lot_serial_numbers
3525: WHERE LINE_ID = p_line_id;
3526:
3527: l_lot_serial_id NUMBER;
3528: l_lock_lot_serial_id NUMBER;

Line 3545: FROM oe_lot_serial_numbers

3541:
3542: -- Lock the sales credits record.
3543: SELECT lot_serial_id
3544: INTO l_lock_lot_serial_id
3545: FROM oe_lot_serial_numbers
3546: WHERE lot_serial_id = l_lot_serial_id
3547: FOR UPDATE NOWAIT;
3548:
3549: delete from oe_lot_serial_numbers

Line 3549: delete from oe_lot_serial_numbers

3545: FROM oe_lot_serial_numbers
3546: WHERE lot_serial_id = l_lot_serial_id
3547: FOR UPDATE NOWAIT;
3548:
3549: delete from oe_lot_serial_numbers
3550: where lot_serial_id = l_lot_serial_id;
3551:
3552: END LOOP;
3553: