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

Line 1627: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE

1623: * tables - MSNI, MTLI *
1624: * - bbaby, dsoosai 12/11/97 *
1625: ******************************************************************/
1626:
1627: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
1628: WHERE TRANSACTION_INTERFACE_ID IN (
1629: SELECT MTI.TRANSACTION_INTERFACE_ID
1630: FROM MTL_TRANSACTIONS_INTERFACE MTI
1631: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id

Line 1634: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE MSNI

1630: FROM MTL_TRANSACTIONS_INTERFACE MTI
1631: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id
1632: AND MTI.PROCESS_FLAG = 1);
1633:
1634: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE MSNI
1635: WHERE TRANSACTION_INTERFACE_ID IN (
1636: SELECT MTLI.SERIAL_TRANSACTION_TEMP_ID
1637: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
1638: MTL_TRANSACTIONS_INTERFACE MTI