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 1897: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE

1893: DELETE FROM PO_INTERFACE_ERRORS
1894: WHERE INTERFACE_LINE_ID = l_err_intf_trans_id
1895: AND INTERFACE_HEADER_ID = l_err_intf_hdr_id;
1896:
1897: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
1898: WHERE PRODUCT_TRANSACTION_ID = l_err_intf_trans_id;
1899:
1900: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
1901: WHERE PRODUCT_TRANSACTION_ID = l_err_intf_trans_id;

Line 2154: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE

2150: END IF;
2151:
2152:
2153: IF(l_trans_serial_number is not null) THEN
2154: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE
2155: (
2156: TRANSACTION_INTERFACE_ID,
2157: LAST_UPDATE_DATE,
2158: LAST_UPDATED_BY,