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 1597: l_trans_serial_number mtl_serial_numbers.serial_number%TYPE;

1593: l_is_ib_trackable VARCHAR2(1);
1594: l_IB_subtrns_inst_rec get_IB_subtrns_inst_dtls_csr%ROWTYPE;
1595: l_osp_order_id NUMBER;
1596: l_osp_order_type VARCHAR2(30);
1597: l_trans_serial_number mtl_serial_numbers.serial_number%TYPE;
1598: l_trans_lot_number mtl_lot_numbers.lot_number%TYPE;
1599: l_osp_line_id NUMBER;
1600: l_oe_order_line_rec oe_order_line_details_csr%ROWTYPE;
1601: l_oe_lot_serial_rec ahl_oe_lot_serial_id_csr%ROWTYPE;

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,