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_MOVPROC_PRIV dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 466: DELETE FROM mtl_transaction_lots_temp mtlt

462: After bug fix 8663842, when transaction_batch_id is not populated,
463: records that pass inventory validation can be moved to MMTT and MTLT,
464: we need to delete them also for the same transaction_header_id*/
465: -- Delete error records from MTLT
466: DELETE FROM mtl_transaction_lots_temp mtlt
467: WHERE mtlt.transaction_temp_id IN
468: (SELECT mmtt.transaction_temp_id
469: FROM mtl_material_transactions_temp mmtt
470: WHERE mmtt.transaction_header_id = p_mtl_header_id

Line 479: ' rows deleted from mtl_transaction_lots_temp';

475: AND mti.transaction_header_id = p_mtl_header_id));
476:
477: IF (l_logLevel <= wip_constants.full_logging) THEN
478: l_msg := SQL%ROWCOUNT ||
479: ' rows deleted from mtl_transaction_lots_temp';
480: wip_logger.log(p_msg => l_msg,
481: x_returnStatus => l_returnStatus);
482: END IF;
483:

Line 8624: * MTL_TRANSACTION_LOTS_TEMP

8620: /*****************************************************************************
8621: * This procedure is equivalent to witpscp_completion in wiltps5.ppc
8622: * This procedure is used to do easy completion and easy return
8623: * This procedure insert into MTL_MATERIAL_TRANSACTIONS_TEMP and
8624: * MTL_TRANSACTION_LOTS_TEMP
8625: ****************************************************************************/
8626: PROCEDURE ez_completion(p_gib IN OUT NOCOPY group_rec_t,
8627: p_txn_type IN NUMBER,
8628: x_returnStatus OUT NOCOPY VARCHAR2) IS