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_LOT_NUMBERS

Line 1768: mtl_lot_numbers mln

1764: SET lot_expiration_date =
1765: (SELECT MIN(mln.expiration_date)
1766: FROM mtl_transactions_interface mti,
1767: mtl_system_items msi,
1768: mtl_lot_numbers mln
1769: WHERE mti.organization_id = msi.organization_id
1770: AND mti.inventory_item_id = msi.inventory_item_id
1771: AND mti.transaction_header_id = p_mtl_header_id
1772: AND mti.transaction_action_id in (WIP_CONSTANTS.RETASSY_ACTION,WIP_CONSTANTS.CPLASSY_ACTION)

Line 1805: /* IF Exp date null in MTL_LOT_NUMBERS should I leave it null */

1801: wip_logger.log(p_msg => l_msg,
1802: x_returnStatus => l_return_status);
1803: END IF;
1804:
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