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.INV_ENHANCED_TM_PERF dependencies on MTL_TRANSACTIONS_INTERFACE

Line 32: select rowid from mtl_transactions_interface mti

28:
29: l_mti_rec mti_rec_table;
30:
31: cursor mti_so_rec is
32: select rowid from mtl_transactions_interface mti
33: where PROCESS_FLAG = 1
34: AND NVL(LOCK_FLAG,2) = 2
35: AND TRANSACTION_MODE = 3
36: AND EXISTS (

Line 49: select rowid from mtl_transactions_interface mti

45: and nvl(ood.disable_date, sysdate + 1) > sysdate)
46: order by mti.inventory_item_id;
47:
48: cursor mti_inv_rec is
49: select rowid from mtl_transactions_interface mti
50: where PROCESS_FLAG = 1
51: AND NVL(LOCK_FLAG,2) = 2
52: AND TRANSACTION_MODE = 3
53: AND EXISTS (

Line 101: from mtl_transactions_interface mti

97: print_debug('Processing SO source type transactions');
98:
99: select inventory_item_id, count(1) record_count
100: bulk collect into l_mti_rec
101: from mtl_transactions_interface mti
102: where PROCESS_FLAG = 1
103: AND NVL(LOCK_FLAG,2) = 2
104: AND TRANSACTION_MODE = 3
105: AND EXISTS (

Line 128: update mtl_transactions_interface mti

124: print_debug('updating item_id '|| l_mti_rec(i).item_id || ' with header_id '||l_header_id);
125:
126: l_rowcount := 0;
127:
128: update mtl_transactions_interface mti
129: set transaction_header_id = l_header_id,
130: last_update_date = sysdate,
131: last_updated_by = p_userid,
132: LAST_UPDATE_LOGIN = p_loginid,

Line 159: update mtl_transactions_interface mti

155: l_rowcount := l_rowcount + sql%rowcount;
156: print_debug('l_rowcount is '||l_rowcount);
157:
158: print_debug('updating rows with same batch_id ');
159: update mtl_transactions_interface mti
160: set transaction_header_id = l_header_id,
161: last_update_date = sysdate,
162: last_updated_by = p_userid,
163: LAST_UPDATE_LOGIN = p_loginid,

Line 182: from mtl_transactions_interface mti2

178: and mtt.transaction_source_type_id in (2,8,16))
179: and transaction_batch_id is not null
180: and transaction_batch_id in (
181: select mti2.transaction_batch_id
182: from mtl_transactions_interface mti2
183: where mti2.transaction_header_id = l_header_id
184: and mti2.transaction_batch_id is not null
185: and mti2.lock_flag = 1
186: and mti2.error_code is null

Line 244: update mtl_transactions_interface

240:
241: l_rowcount := 0;
242:
243: forall j in l_rowid.first..l_rowid.last
244: update mtl_transactions_interface
245: SET transaction_header_id = l_header_id,
246: last_update_date = sysdate,
247: last_updated_by = p_userid,
248: LAST_UPDATE_LOGIN = p_loginid,

Line 269: update mtl_transactions_interface mti

265: end if;
266:
267: print_debug('updating rows with same item_id ');
268:
269: update mtl_transactions_interface mti
270: SET TRANSACTION_HEADER_ID = l_header_id,
271: last_update_date = sysdate,
272: last_updated_by = p_userid,
273: LAST_UPDATE_LOGIN = p_loginid,

Line 291: from mtl_transactions_interface mti2

287: where mtt.transaction_type_id = mti.transaction_type_id
288: and mtt.transaction_source_type_id in (2,8,16))
289: and inventory_item_id in (
290: select mti2.inventory_item_id
291: from mtl_transactions_interface mti2
292: where mti2.transaction_header_id = l_header_id
293: and mti2.LOCK_FLAG = 1
294: and mti2.error_code is null
295: and mti2.ERROR_EXPLANATION is NULL)

Line 308: update mtl_transactions_interface mti

304: print_debug('l_rowcount is ' || l_rowcount);
305:
306: print_debug('updating rows with same batch_id ');
307:
308: update mtl_transactions_interface mti
309: set transaction_header_id = l_header_id,
310: last_update_date = sysdate,
311: last_updated_by = p_userid,
312: last_update_login = p_loginid,

Line 331: from mtl_transactions_interface mti2

327: and mtt.transaction_source_type_id in (2,8,16))
328: and transaction_batch_id is not null
329: and transaction_batch_id in (
330: select mti2.transaction_batch_id
331: from mtl_transactions_interface mti2
332: where mti2.transaction_header_id = l_header_id
333: and mti2.transaction_batch_id is not null
334: and mti2.lock_flag = 1
335: and mti2.error_code is null

Line 376: from mtl_transactions_interface mti

372: print_debug('Processing INV source type transactions');
373:
374: select inventory_item_id, count(1) record_count
375: bulk collect into l_mti_rec
376: from mtl_transactions_interface mti
377: where PROCESS_FLAG = 1
378: AND NVL(LOCK_FLAG,2) = 2
379: AND TRANSACTION_MODE = 3
380: AND EXISTS (

Line 403: update mtl_transactions_interface mti

399: print_debug('updating item_id '|| l_mti_rec(i).item_id || ' with header_id '||l_header_id);
400:
401: l_rowcount := 0;
402:
403: update mtl_transactions_interface mti
404: set transaction_header_id = l_header_id,
405: last_update_date = sysdate,
406: last_updated_by = p_userid,
407: LAST_UPDATE_LOGIN = p_loginid,

Line 434: update mtl_transactions_interface mti

430: l_rowcount := l_rowcount + sql%rowcount;
431: print_debug('l_rowcount is '||l_rowcount);
432:
433: print_debug('updating rows with same batch_id ');
434: update mtl_transactions_interface mti
435: set transaction_header_id = l_header_id,
436: last_update_date = sysdate,
437: last_updated_by = p_userid,
438: LAST_UPDATE_LOGIN = p_loginid,

Line 457: from mtl_transactions_interface mti2

453: and mtt.transaction_source_type_id not in (2,5,8,16))
454: and transaction_batch_id is not null
455: and transaction_batch_id in (
456: select mti2.transaction_batch_id
457: from mtl_transactions_interface mti2
458: where mti2.transaction_header_id = l_header_id
459: and mti2.transaction_batch_id is not null
460: and mti2.lock_flag = 1
461: and mti2.error_code is null

Line 519: update mtl_transactions_interface

515:
516: l_rowcount := 0;
517:
518: forall j in l_rowid.first..l_rowid.last
519: update mtl_transactions_interface
520: SET transaction_header_id = l_header_id,
521: last_update_date = sysdate,
522: last_updated_by = p_userid,
523: LAST_UPDATE_LOGIN = p_loginid,

Line 544: update mtl_transactions_interface mti

540: end if;
541:
542: print_debug('updating rows with same item_id ');
543:
544: update mtl_transactions_interface mti
545: SET TRANSACTION_HEADER_ID = l_header_id,
546: last_update_date = sysdate,
547: last_updated_by = p_userid,
548: LAST_UPDATE_LOGIN = p_loginid,

Line 566: from mtl_transactions_interface mti2

562: where mtt.transaction_type_id = mti.transaction_type_id
563: and mtt.transaction_source_type_id not in (2,5,8,16))
564: and inventory_item_id in (
565: select mti2.inventory_item_id
566: from mtl_transactions_interface mti2
567: where mti2.transaction_header_id = l_header_id
568: and mti2.LOCK_FLAG = 1
569: and mti2.error_code is null
570: and mti2.ERROR_EXPLANATION is NULL)

Line 583: update mtl_transactions_interface mti

579: print_debug('l_rowcount is ' || l_rowcount);
580:
581: print_debug('updating rows with same batch_id ');
582:
583: update mtl_transactions_interface mti
584: set transaction_header_id = l_header_id,
585: last_update_date = sysdate,
586: last_updated_by = p_userid,
587: last_update_login = p_loginid,

Line 606: from mtl_transactions_interface mti2

602: and mtt.transaction_source_type_id not in (2,5,8,16))
603: and transaction_batch_id is not null
604: and transaction_batch_id in (
605: select mti2.transaction_batch_id
606: from mtl_transactions_interface mti2
607: where mti2.transaction_header_id = l_header_id
608: and mti2.transaction_batch_id is not null
609: and mti2.lock_flag = 1
610: and mti2.error_code is null