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.RCV_OPSM_DLV_BE_PKG dependencies on RCV_OPSM_LOT_SERIAL_V

Line 244: FROM RCV_OPSM_LOT_SERIAL_V ROLSV

240: ROLSV.ORIGINATION_DATE,
241: ROLSV.BEST_BY_DATE,
242: ROLSV.RETEST_DATE,
243: ROLSV.EXPIRATION_DATE
244: FROM RCV_OPSM_LOT_SERIAL_V ROLSV
245: WHERE ROLSV.SHIPMENT_HEADER_ID=p_header_id
246: AND ROLSV.SHIPMENT_LINE_ID=p_line_id;
247:
248: CURSOR cur_serial_info(p_shipment_line_id in number,p_transaction_id in NUMBER,p_lotnum in varchar2) IS

Line 253: FROM RCV_OPSM_LOT_SERIAL_V ROLSV

249: SELECT ROLSV.SHIPMENT_LINE_ID,
250: ROLSV.TRANSACTION_ID,
251: ROLSV.LOT_NUM,
252: ROLSV.SERIAL_NUM
253: FROM RCV_OPSM_LOT_SERIAL_V ROLSV
254: WHERE ROLSV.SHIPMENT_LINE_ID=p_shipment_line_id
255: AND ROLSV.TRANSACTION_ID= p_transaction_id
256: AND NVL(ROLSV.LOT_NUM,-999)=NVL(p_lotnum,-999);
257: