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_TXN_MANAGER_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1844: UPDATE mtl_material_transactions_temp

1840: FROM DUAL;
1841:
1842: p_txn_hdr_id := l_new_hdr_id;
1843:
1844: UPDATE mtl_material_transactions_temp
1845: SET transaction_header_id = l_new_hdr_id
1846: , lock_flag = 'Y'
1847: WHERE process_flag = 'Y'
1848: AND NVL (lock_flag, 'N') = 'N'

Line 1852: , mtl_material_transactions_temp mmtt

1848: AND NVL (lock_flag, 'N') = 'N'
1849: AND transaction_header_id IN (
1850: SELECT mmtt.transaction_header_id
1851: FROM mtl_material_transactions mmt
1852: , mtl_material_transactions_temp mmtt
1853: WHERE mmt.transaction_set_id = l_old_hdr_id
1854: AND mmt.completion_transaction_id =
1855: mmtt.completion_transaction_id);
1856:

Line 2184: FROM mtl_material_transactions_temp

2180:
2181: /*Bug:5276191. Added the following cursor. */
2182: CURSOR c_mmtt IS
2183: SELECT *
2184: FROM mtl_material_transactions_temp
2185: WHERE transaction_header_id = p_header_id
2186: AND NVL(transaction_status, 1) <> 2 -- don't consider suggestions
2187: AND process_flag = 'Y'
2188: ORDER BY transaction_batch_id;

Line 2273: UPDATE mtl_material_transactions_temp

2269: , 9
2270: );
2271: END IF;
2272:
2273: UPDATE mtl_material_transactions_temp
2274: SET last_update_date = SYSDATE
2275: , transaction_temp_id =
2276: NVL (transaction_temp_id, mtl_material_transactions_s.NEXTVAL)
2277: , last_updated_by = l_userid

Line 2290: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

2286: AND NVL (transaction_status, ts_default) <> ts_save_only /* 2STEP */
2287: AND transaction_header_id = l_header_id;
2288:
2289: --Bug 4586255, support 6 decimals for wip
2290: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
2291: SET PRIMARY_QUANTITY = ROUND(PRIMARY_QUANTITY,5),
2292: TRANSACTION_QUANTITY = ROUND(TRANSACTION_QUANTITY,5)
2293: WHERE PROCESS_FLAG = 'Y'
2294: AND NVL(TRANSACTION_STATUS,TS_DEFAULT) <> TS_SAVE_ONLY /* 2STEP */

Line 2303: FROM mtl_material_transactions_temp

2299: SET PRIMARY_QUANTITY = ROUND(PRIMARY_QUANTITY,5),
2300: TRANSACTION_QUANTITY = ROUND(TRANSACTION_QUANTITY,5)
2301: WHERE transaction_temp_id
2302: IN ( SELECT transaction_temp_id
2303: FROM mtl_material_transactions_temp
2304: WHERE PROCESS_FLAG = 'Y'
2305: AND NVL(TRANSACTION_STATUS,TS_DEFAULT) <> TS_SAVE_ONLY /* 2STEP */
2306: AND TRANSACTION_HEADER_ID = l_header_id
2307: AND transaction_source_type_id <> 5);

Line 2310: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

2306: AND TRANSACTION_HEADER_ID = l_header_id
2307: AND transaction_source_type_id <> 5);
2308:
2309:
2310: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
2311: SET PRIMARY_QUANTITY = ROUND(PRIMARY_QUANTITY,6),
2312: TRANSACTION_QUANTITY = ROUND(TRANSACTION_QUANTITY,6)
2313: WHERE PROCESS_FLAG = 'Y'
2314: AND NVL(TRANSACTION_STATUS,TS_DEFAULT) <> TS_SAVE_ONLY /* 2STEP */

Line 2323: FROM mtl_material_transactions_temp

2319: SET PRIMARY_QUANTITY = ROUND(PRIMARY_QUANTITY,6),
2320: TRANSACTION_QUANTITY = ROUND(TRANSACTION_QUANTITY,6)
2321: WHERE transaction_temp_id
2322: IN( SELECT transaction_temp_id
2323: FROM mtl_material_transactions_temp
2324: WHERE PROCESS_FLAG = 'Y'
2325: AND NVL(TRANSACTION_STATUS,TS_DEFAULT) <> TS_SAVE_ONLY /* 2STEP */
2326: AND TRANSACTION_HEADER_ID = l_header_id
2327: AND transaction_source_type_id = 5);

Line 2339: FROM mtl_material_transactions_temp

2335: END IF;
2336:
2337: SELECT COUNT (1)
2338: INTO l_process
2339: FROM mtl_material_transactions_temp
2340: WHERE transaction_header_id = l_header_id
2341: AND process_flag = 'Y'
2342: AND transaction_status = 3 /* not able to use the TS_PROCESS macro */
2343: AND ROWNUM < 2;

Line 2368: FROM mtl_material_transactions_temp

2364: END IF;
2365:
2366: SELECT COUNT (*)
2367: INTO l_totrows
2368: FROM mtl_material_transactions_temp
2369: WHERE transaction_header_id = l_header_id
2370: AND process_flag = 'Y'
2371: AND NVL (transaction_status, ts_default) <> ts_save_only; /* 2STEP */
2372:

Line 2402: FROM mtl_material_transactions_temp

2398: +-----------------------------------------------------------------+*/
2399: -- Pawan added wip_entity_type for gme_inventory convergence
2400: SELECT transaction_source_type_id, wip_entity_type
2401: INTO l_srctypeid, l_wip_entity_type
2402: FROM mtl_material_transactions_temp
2403: WHERE transaction_header_id = l_header_id AND ROWNUM < 2;
2404:
2405: done := FALSE;
2406: FIRST := TRUE;

Line 2554: FROM mtl_material_transactions_temp

2550: END IF;
2551:
2552: SELECT COUNT (*)
2553: INTO l_totrows
2554: FROM mtl_material_transactions_temp
2555: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
2556:
2557: IF (l_totrows > 200)
2558: THEN

Line 2559: UPDATE mtl_material_transactions_temp

2555: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
2556:
2557: IF (l_totrows > 200)
2558: THEN
2559: UPDATE mtl_material_transactions_temp
2560: SET transaction_header_id = (-1) * l_header_id
2561: WHERE transaction_header_id = l_header_id
2562: AND process_flag = 'Y';
2563:

Line 2564: UPDATE mtl_material_transactions_temp

2560: SET transaction_header_id = (-1) * l_header_id
2561: WHERE transaction_header_id = l_header_id
2562: AND process_flag = 'Y';
2563:
2564: UPDATE mtl_material_transactions_temp
2565: SET transaction_header_id = ABS (l_header_id)
2566: WHERE transaction_header_id = (-1) * (l_header_id)
2567: AND process_flag = 'Y'
2568: AND ROWNUM < 201;

Line 2586: UPDATE mtl_material_transactions_temp

2582: END IF;
2583:
2584: FIRST := FALSE;
2585: ELSE
2586: UPDATE mtl_material_transactions_temp
2587: SET transaction_header_id = ABS (l_header_id)
2588: WHERE transaction_header_id = (-1) * (l_header_id)
2589: AND process_flag = 'Y'
2590: AND ROWNUM < 201;

Line 4433: FROM mtl_material_transactions_temp

4429: END IF;
4430:
4431: SELECT COUNT (*)
4432: INTO l_midtotrows
4433: FROM mtl_material_transactions_temp
4434: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
4435:
4436: DELETE FROM mtl_material_transactions_temp
4437: WHERE transaction_header_id = l_header_id

Line 4436: DELETE FROM mtl_material_transactions_temp

4432: INTO l_midtotrows
4433: FROM mtl_material_transactions_temp
4434: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
4435:
4436: DELETE FROM mtl_material_transactions_temp
4437: WHERE transaction_header_id = l_header_id
4438: AND shippable_flag = 'N'
4439: AND process_flag = 'Y';
4440:

Line 4476: FROM mtl_material_transactions_temp

4472: --l_disp := FND_MESSAGE.get;
4473: --inv_log_util.trace(l_disp, 'INV_TXN_MANAGER_PUB',9);
4474: SELECT COUNT (*)
4475: INTO l_totrows
4476: FROM mtl_material_transactions_temp
4477: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
4478:
4479: x_trans_count := l_totrows;
4480:

Line 4577: from mtl_material_transactions_temp mmtt

4573: -- get deleted in TM.
4574: delete from mtl_serial_numbers_temp
4575: where transaction_temp_id in (
4576: select mmtt.transaction_temp_id
4577: from mtl_material_transactions_temp mmtt
4578: where mmtt.transaction_header_id = l_header_id );
4579:
4580: delete from mtl_serial_numbers_temp
4581: where transaction_temp_id in (

Line 4586: from mtl_material_transactions_temp mmtt

4582: select mtlt.serial_transaction_temp_id
4583: from mtl_transaction_lots_temp mtlt
4584: where mtlt.transaction_temp_id in (
4585: select mmtt.transaction_temp_id
4586: from mtl_material_transactions_temp mmtt
4587: where mmtt.transaction_header_id = l_header_id));
4588:
4589: DELETE from mtl_transaction_lots_temp
4590: where transaction_temp_id in

Line 4592: from MTL_MATERIAL_TRANSACTIONS_TEMP mmtt

4588:
4589: DELETE from mtl_transaction_lots_temp
4590: where transaction_temp_id in
4591: (select mmtt.transaction_temp_id
4592: from MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
4593: WHERE mmtt.TRANSACTION_HEADER_ID = l_header_id );
4594:
4595: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
4596: WHERE TRANSACTION_HEADER_ID = l_header_id;

Line 4595: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP

4591: (select mmtt.transaction_temp_id
4592: from MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
4593: WHERE mmtt.TRANSACTION_HEADER_ID = l_header_id );
4594:
4595: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
4596: WHERE TRANSACTION_HEADER_ID = l_header_id;
4597:
4598: IF (l_debug = 1) THEN
4599: inv_log_util.trace('Deleted MSNT/MTLT/MMTT for header_id ' || l_header_id, 'INV_TXN_MANAGER_PUB',1);

Line 4664: FROM mtl_material_transactions_temp

4660: END IF;
4661:
4662: SELECT COUNT (*)
4663: INTO l_totrows
4664: FROM mtl_material_transactions_temp
4665: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
4666:
4667: IF (l_debug = 1)
4668: THEN

Line 4677: UPDATE mtl_material_transactions_temp

4673: END IF;
4674:
4675: IF (l_totrows > 200)
4676: THEN
4677: UPDATE mtl_material_transactions_temp
4678: SET transaction_header_id = (-1) * l_header_id
4679: WHERE transaction_header_id = l_header_id
4680: AND process_flag = 'Y';
4681:

Line 4682: UPDATE mtl_material_transactions_temp

4678: SET transaction_header_id = (-1) * l_header_id
4679: WHERE transaction_header_id = l_header_id
4680: AND process_flag = 'Y';
4681:
4682: UPDATE mtl_material_transactions_temp
4683: SET transaction_header_id = ABS (l_header_id)
4684: WHERE transaction_header_id = (-1) * (l_header_id)
4685: AND process_flag = 'Y'
4686: AND ROWNUM < 201;

Line 4703: UPDATE mtl_material_transactions_temp

4699: done := TRUE;
4700: FIRST := FALSE;
4701: END IF;
4702: ELSE
4703: UPDATE mtl_material_transactions_temp
4704: SET transaction_header_id = ABS (l_header_id)
4705: WHERE transaction_header_id = (-1) * (l_header_id)
4706: AND process_flag = 'Y'
4707: AND ROWNUM < 201;

Line 5083: , mtl_material_transactions_temp a

5079: , a.transaction_date
5080: , a.content_lpn_id
5081: FROM mtl_system_items c
5082: , mtl_transaction_lots_temp b
5083: , mtl_material_transactions_temp a
5084: WHERE a.transaction_header_id = p_line_rec_type.transaction_header_id
5085: AND a.transaction_temp_id =
5086: p_line_rec_type.transaction_interface_id
5087: AND a.organization_id = c.organization_id

Line 5628: , mtl_material_transactions_temp a

5624: , b.transaction_temp_id --lot record identifier in MTLT
5625: , a.relieve_high_level_rsv_flag /*** {{ R12 Enhanced reservations code changes ***/
5626: FROM mtl_system_items c
5627: , mtl_transaction_lots_temp b
5628: , mtl_material_transactions_temp a
5629: WHERE a.transaction_header_id = p_header_id
5630: AND a.transaction_temp_id = p_transaction_temp_id
5631: AND a.organization_id = c.organization_id
5632: AND a.inventory_item_id = c.inventory_item_id