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.WMS_ITEM_LOAD dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1922: UPDATE mtl_transaction_lots_temp

1918: -- If not serial controlled, don't need the serial txn temp ID
1919: IF (p_serial_txn_temp_id IS NULL) THEN
1920: -- Update the MTLT record to clear out the serial_transaction_temp_id column
1921: -- since insert_lot_trx by default will insert a value for it.
1922: UPDATE mtl_transaction_lots_temp
1923: SET serial_transaction_temp_id = NULL
1924: WHERE transaction_temp_id = l_txn_temp_id;
1925: IF (l_debug = 1) THEN
1926: print_debug('Cleared out the serial txn temp ID column in MTLT record');

Line 2181: mtl_transaction_lots_temp mtlt

2177: mmtt.transfer_lpn_id,
2178: mtlt.lot_number,
2179: mtlt.serial_transaction_temp_id
2180: FROM mtl_material_transactions_temp mmtt,
2181: mtl_transaction_lots_temp mtlt
2182: WHERE mmtt.organization_id = p_organization_id
2183: AND mmtt.transaction_header_id = p_txn_header_id
2184: AND (mmtt.transaction_source_type_id = 13 AND
2185: mmtt.transaction_type_id IN (89, 2) AND

Line 2975: DELETE FROM mtl_transaction_lots_temp

2971: IF (l_lot_control_code = 2) THEN
2972: IF (l_debug = 1) THEN
2973: print_debug('Delete the dummy MTLT records: ' || l_mmtt_temp_id);
2974: END IF;
2975: DELETE FROM mtl_transaction_lots_temp
2976: WHERE transaction_temp_id = l_mmtt_temp_id;
2977: END IF;
2978:
2979: IF (l_debug = 1) THEN