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_CPLPROC_PRIV dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 1752: FROM mtl_transaction_lots_interface mtli,

1748: --ProcessOATxn is used only for MES and discrete jobs, hence checking for only discrete
1749:
1750: SELECT COUNT(1)
1751: INTO l_mti_lot_rec
1752: FROM mtl_transaction_lots_interface mtli,
1753: mtl_transactions_interface mti
1754: WHERE mtli.transaction_interface_id = mti.transaction_interface_id
1755: AND mti.transaction_header_id = p_mtl_header_id
1756: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)

Line 1763: UPDATE mtl_transaction_lots_interface mtli

1759:
1760: IF l_mti_lot_rec>0 THEN
1761:
1762:
1763: UPDATE mtl_transaction_lots_interface mtli
1764: SET lot_expiration_date =
1765: (SELECT MIN(mln.expiration_date)
1766: FROM mtl_transactions_interface mti,
1767: mtl_system_items msi,

Line 1799: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

1795: -- IF debug message level = 2, write statement below to log file
1796: IF (l_log_level <= wip_constants.full_logging) THEN
1797: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1798: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1799: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1800: l_msg := fnd_message.get;
1801: wip_logger.log(p_msg => l_msg,
1802: x_returnStatus => l_return_status);
1803: END IF;

Line 1809: UPDATE mtl_transaction_lots_interface mtli

1805: /* IF Exp date null in MTL_LOT_NUMBERS should I leave it null */
1806: /* Or should I just decode based on exp date null in the temp table? */
1807: /* Removed group by and modIFied select and where conditions to avoid
1808: oracle error 1427. See bugs 866408 and 938422. */
1809: UPDATE mtl_transaction_lots_interface mtli
1810: SET lot_expiration_date =
1811: (SELECT mti.transaction_date + NVL(msi.shelf_life_days,0)
1812: FROM mtl_transactions_interface mti,
1813: mtl_system_items msi

Line 1843: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');

1839: -- IF debug message level = 2, write statement below to log file
1840: IF (l_log_level <= wip_constants.full_logging) THEN
1841: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
1842: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
1843: fnd_message.set_token('ENTITY2', 'MTL_TRANSACTION_LOTS_INTERFACE');
1844: l_msg := fnd_message.get;
1845: wip_logger.log(p_msg => l_msg,
1846: x_returnStatus => l_return_status);
1847: END IF;