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.AHL_OSP_RCV_PVT dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 2174: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE

2170: DELETE FROM PO_INTERFACE_ERRORS
2171: WHERE INTERFACE_LINE_ID = l_err_intf_trans_id
2172: AND INTERFACE_HEADER_ID = l_err_intf_hdr_id;
2173:
2174: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
2175: WHERE PRODUCT_TRANSACTION_ID = l_err_intf_trans_id;
2176:
2177: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
2178: WHERE PRODUCT_TRANSACTION_ID = l_err_intf_trans_id;

Line 2433: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE

2429: END IF;
2430:
2431:
2432: IF(l_trans_serial_number is not null) THEN
2433: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE
2434: (
2435: TRANSACTION_INTERFACE_ID,
2436: LAST_UPDATE_DATE,
2437: LAST_UPDATED_BY,