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

Line 1364: l_trans_serial_number mtl_serial_numbers.serial_number%TYPE;

1360: l_is_ib_trackable VARCHAR2(1);
1361: l_IB_subtrns_inst_rec get_IB_subtrns_inst_dtls_csr%ROWTYPE;
1362: l_osp_order_id NUMBER;
1363: l_osp_order_type VARCHAR2(30);
1364: l_trans_serial_number mtl_serial_numbers.serial_number%TYPE;
1365: l_trans_lot_number mtl_lot_numbers.lot_number%TYPE;
1366: l_osp_line_id NUMBER;
1367: l_oe_order_line_rec oe_order_line_details_csr%ROWTYPE;
1368: l_oe_lot_serial_rec ahl_oe_lot_serial_id_csr%ROWTYPE;

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,