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 2200: FROM mtl_material_transactions_temp

2196:
2197: /*Bug:5276191. Added the following cursor. */
2198: CURSOR c_mmtt IS
2199: SELECT *
2200: FROM mtl_material_transactions_temp
2201: WHERE transaction_header_id = p_header_id
2202: AND NVL(transaction_status, 1) <> 2 -- don't consider suggestions
2203: AND process_flag = 'Y'
2204: ORDER BY transaction_batch_id;

Line 2289: UPDATE mtl_material_transactions_temp

2285: , 9
2286: );
2287: END IF;
2288:
2289: UPDATE mtl_material_transactions_temp
2290: SET last_update_date = SYSDATE
2291: , transaction_temp_id =
2292: NVL (transaction_temp_id, mtl_material_transactions_s.NEXTVAL)
2293: , last_updated_by = l_userid

Line 2306: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

2302: AND NVL (transaction_status, ts_default) <> ts_save_only /* 2STEP */
2303: AND transaction_header_id = l_header_id;
2304:
2305: --Bug 4586255, support 6 decimals for wip
2306: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
2307: SET PRIMARY_QUANTITY = ROUND(PRIMARY_QUANTITY,5),
2308: TRANSACTION_QUANTITY = ROUND(TRANSACTION_QUANTITY,5)
2309: WHERE PROCESS_FLAG = 'Y'
2310: AND NVL(TRANSACTION_STATUS,TS_DEFAULT) <> TS_SAVE_ONLY /* 2STEP */

Line 2319: FROM mtl_material_transactions_temp

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

Line 2326: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

2322: AND TRANSACTION_HEADER_ID = l_header_id
2323: AND transaction_source_type_id <> 5);
2324:
2325:
2326: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
2327: SET PRIMARY_QUANTITY = ROUND(PRIMARY_QUANTITY,6),
2328: TRANSACTION_QUANTITY = ROUND(TRANSACTION_QUANTITY,6)
2329: WHERE PROCESS_FLAG = 'Y'
2330: AND NVL(TRANSACTION_STATUS,TS_DEFAULT) <> TS_SAVE_ONLY /* 2STEP */

Line 2339: FROM mtl_material_transactions_temp

2335: SET PRIMARY_QUANTITY = ROUND(PRIMARY_QUANTITY,6),
2336: TRANSACTION_QUANTITY = ROUND(TRANSACTION_QUANTITY,6)
2337: WHERE transaction_temp_id
2338: IN( SELECT transaction_temp_id
2339: FROM mtl_material_transactions_temp
2340: WHERE PROCESS_FLAG = 'Y'
2341: AND NVL(TRANSACTION_STATUS,TS_DEFAULT) <> TS_SAVE_ONLY /* 2STEP */
2342: AND TRANSACTION_HEADER_ID = l_header_id
2343: AND transaction_source_type_id = 5);

Line 2355: FROM mtl_material_transactions_temp

2351: END IF;
2352:
2353: SELECT COUNT (1)
2354: INTO l_process
2355: FROM mtl_material_transactions_temp
2356: WHERE transaction_header_id = l_header_id
2357: AND process_flag = 'Y'
2358: AND transaction_status = 3 /* not able to use the TS_PROCESS macro */
2359: AND ROWNUM < 2;

Line 2384: FROM mtl_material_transactions_temp

2380: END IF;
2381:
2382: SELECT COUNT (*)
2383: INTO l_totrows
2384: FROM mtl_material_transactions_temp
2385: WHERE transaction_header_id = l_header_id
2386: AND process_flag = 'Y'
2387: AND NVL (transaction_status, ts_default) <> ts_save_only; /* 2STEP */
2388:

Line 2418: FROM mtl_material_transactions_temp

2414: +-----------------------------------------------------------------+*/
2415: -- Pawan added wip_entity_type for gme_inventory convergence
2416: SELECT transaction_source_type_id, wip_entity_type
2417: INTO l_srctypeid, l_wip_entity_type
2418: FROM mtl_material_transactions_temp
2419: WHERE transaction_header_id = l_header_id AND ROWNUM < 2;
2420:
2421: done := FALSE;
2422: FIRST := TRUE;

Line 2570: FROM mtl_material_transactions_temp

2566: END IF;
2567:
2568: SELECT COUNT (*)
2569: INTO l_totrows
2570: FROM mtl_material_transactions_temp
2571: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
2572:
2573: IF (l_totrows > 200)
2574: THEN

Line 2575: UPDATE mtl_material_transactions_temp

2571: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
2572:
2573: IF (l_totrows > 200)
2574: THEN
2575: UPDATE mtl_material_transactions_temp
2576: SET transaction_header_id = (-1) * l_header_id
2577: WHERE transaction_header_id = l_header_id
2578: AND process_flag = 'Y';
2579:

Line 2580: UPDATE mtl_material_transactions_temp

2576: SET transaction_header_id = (-1) * l_header_id
2577: WHERE transaction_header_id = l_header_id
2578: AND process_flag = 'Y';
2579:
2580: UPDATE mtl_material_transactions_temp
2581: SET transaction_header_id = ABS (l_header_id)
2582: WHERE transaction_header_id = (-1) * (l_header_id)
2583: AND process_flag = 'Y'
2584: AND ROWNUM < 201;

Line 2602: UPDATE mtl_material_transactions_temp

2598: END IF;
2599:
2600: FIRST := FALSE;
2601: ELSE
2602: UPDATE mtl_material_transactions_temp
2603: SET transaction_header_id = ABS (l_header_id)
2604: WHERE transaction_header_id = (-1) * (l_header_id)
2605: AND process_flag = 'Y'
2606: AND ROWNUM < 201;

Line 4574: FROM mtl_material_transactions_temp

4570: END IF;
4571:
4572: SELECT COUNT (*)
4573: INTO l_midtotrows
4574: FROM mtl_material_transactions_temp
4575: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
4576:
4577: DELETE FROM mtl_material_transactions_temp
4578: WHERE transaction_header_id = l_header_id

Line 4577: DELETE FROM mtl_material_transactions_temp

4573: INTO l_midtotrows
4574: FROM mtl_material_transactions_temp
4575: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
4576:
4577: DELETE FROM mtl_material_transactions_temp
4578: WHERE transaction_header_id = l_header_id
4579: AND shippable_flag = 'N'
4580: AND process_flag = 'Y';
4581:

Line 4617: FROM mtl_material_transactions_temp

4613: --l_disp := FND_MESSAGE.get;
4614: --inv_log_util.trace(l_disp, 'INV_TXN_MANAGER_PUB',9);
4615: SELECT COUNT (*)
4616: INTO l_totrows
4617: FROM mtl_material_transactions_temp
4618: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
4619:
4620: x_trans_count := l_totrows;
4621:

Line 4718: from mtl_material_transactions_temp mmtt

4714: -- get deleted in TM.
4715: delete from mtl_serial_numbers_temp
4716: where transaction_temp_id in (
4717: select mmtt.transaction_temp_id
4718: from mtl_material_transactions_temp mmtt
4719: where mmtt.transaction_header_id = l_header_id );
4720:
4721: delete from mtl_serial_numbers_temp
4722: where transaction_temp_id in (

Line 4727: from mtl_material_transactions_temp mmtt

4723: select mtlt.serial_transaction_temp_id
4724: from mtl_transaction_lots_temp mtlt
4725: where mtlt.transaction_temp_id in (
4726: select mmtt.transaction_temp_id
4727: from mtl_material_transactions_temp mmtt
4728: where mmtt.transaction_header_id = l_header_id));
4729:
4730: DELETE from mtl_transaction_lots_temp
4731: where transaction_temp_id in

Line 4733: from MTL_MATERIAL_TRANSACTIONS_TEMP mmtt

4729:
4730: DELETE from mtl_transaction_lots_temp
4731: where transaction_temp_id in
4732: (select mmtt.transaction_temp_id
4733: from MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
4734: WHERE mmtt.TRANSACTION_HEADER_ID = l_header_id );
4735:
4736: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
4737: WHERE TRANSACTION_HEADER_ID = l_header_id;

Line 4736: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP

4732: (select mmtt.transaction_temp_id
4733: from MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
4734: WHERE mmtt.TRANSACTION_HEADER_ID = l_header_id );
4735:
4736: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
4737: WHERE TRANSACTION_HEADER_ID = l_header_id;
4738:
4739: IF (l_debug = 1) THEN
4740: inv_log_util.trace('Deleted MSNT/MTLT/MMTT for header_id ' || l_header_id, 'INV_TXN_MANAGER_PUB',1);

Line 4805: FROM mtl_material_transactions_temp

4801: END IF;
4802:
4803: SELECT COUNT (*)
4804: INTO l_totrows
4805: FROM mtl_material_transactions_temp
4806: WHERE transaction_header_id = l_header_id AND process_flag = 'Y';
4807:
4808: IF (l_debug = 1)
4809: THEN

Line 4818: UPDATE mtl_material_transactions_temp

4814: END IF;
4815:
4816: IF (l_totrows > 200)
4817: THEN
4818: UPDATE mtl_material_transactions_temp
4819: SET transaction_header_id = (-1) * l_header_id
4820: WHERE transaction_header_id = l_header_id
4821: AND process_flag = 'Y';
4822:

Line 4823: UPDATE mtl_material_transactions_temp

4819: SET transaction_header_id = (-1) * l_header_id
4820: WHERE transaction_header_id = l_header_id
4821: AND process_flag = 'Y';
4822:
4823: UPDATE mtl_material_transactions_temp
4824: SET transaction_header_id = ABS (l_header_id)
4825: WHERE transaction_header_id = (-1) * (l_header_id)
4826: AND process_flag = 'Y'
4827: AND ROWNUM < 201;

Line 4844: UPDATE mtl_material_transactions_temp

4840: done := TRUE;
4841: FIRST := FALSE;
4842: END IF;
4843: ELSE
4844: UPDATE mtl_material_transactions_temp
4845: SET transaction_header_id = ABS (l_header_id)
4846: WHERE transaction_header_id = (-1) * (l_header_id)
4847: AND process_flag = 'Y'
4848: AND ROWNUM < 201;

Line 5224: , mtl_material_transactions_temp a

5220: , a.transaction_date
5221: , a.content_lpn_id
5222: FROM mtl_system_items c
5223: , mtl_transaction_lots_temp b
5224: , mtl_material_transactions_temp a
5225: WHERE a.transaction_header_id = p_line_rec_type.transaction_header_id
5226: AND a.transaction_temp_id =
5227: p_line_rec_type.transaction_interface_id
5228: AND a.organization_id = c.organization_id

Line 5824: , mtl_material_transactions_temp a

5820: , b.transaction_temp_id --lot record identifier in MTLT
5821: , a.relieve_high_level_rsv_flag /*** {{ R12 Enhanced reservations code changes ***/
5822: FROM mtl_system_items c
5823: , mtl_transaction_lots_temp b
5824: , mtl_material_transactions_temp a
5825: WHERE a.transaction_header_id = p_header_id
5826: AND a.transaction_temp_id = p_transaction_temp_id
5827: AND a.organization_id = c.organization_id
5828: AND a.inventory_item_id = c.inventory_item_id