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

Line 715: INSERT INTO mtl_transaction_lots_temp

711: WHEN NO_DATA_FOUND THEN
712: NULL;
713: END;
714:
715: INSERT INTO mtl_transaction_lots_temp
716: (
717: transaction_temp_id
718: , last_update_date
719: , last_updated_by

Line 1066: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

1062: , l_trx_type_id
1063: , l_subinventory_code
1064: , l_locator_id
1065: , l_lot_number
1066: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
1067: WHERE mtlt.serial_transaction_temp_id = p_trx_tmp_id
1068: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id;
1069:
1070: l_serial_trx_tmp_id := p_trx_tmp_id;

Line 2078: FROM mtl_transaction_lots_temp

2074: lot_line_mark_id = NULL
2075: WHERE inventory_item_id = l_inventory_item_id -- 14259665 Performance Issue
2076: AND current_organization_id = l_organization_id -- 14259665 Performance Issue
2077: AND group_mark_id IN (SELECT serial_transaction_temp_id
2078: FROM mtl_transaction_lots_temp
2079: WHERE transaction_temp_id = p_transaction_temp_id
2080: UNION ALL
2081: SELECT l_txn_hdr_id
2082: FROM dual --Bug#6157372 -- 12419592

Line 2091: FROM mtl_transaction_lots_temp

2087: l_unmarked_count := SQL%ROWCOUNT;
2088:
2089: DELETE mtl_serial_numbers_temp
2090: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id
2091: FROM mtl_transaction_lots_temp
2092: WHERE transaction_temp_id = p_transaction_temp_id
2093: UNION ALL
2094: SELECT p_transaction_temp_id
2095: FROM dual );-- 14259665 Added to select temp id since for unallocated lots the MSNTs are inserted with

Line 2121: DELETE mtl_transaction_lots_temp

2117: END IF;
2118:
2119: -- Deleting all the Lots associated with the Transaction
2120: IF l_lot_control_code = 2 THEN
2121: DELETE mtl_transaction_lots_temp
2122: WHERE transaction_temp_id = p_transaction_temp_id;
2123:
2124: IF l_debug = 1 THEN
2125: TRACE('Records deleted in MTLT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

Line 2165: FROM mtl_transaction_lots_temp

2161: WHERE transaction_temp_id = l_txn_tmp_id;
2162:
2163: CURSOR c_lot(l_txn_tmp_id IN NUMBER) IS
2164: SELECT serial_transaction_temp_id
2165: FROM mtl_transaction_lots_temp
2166: WHERE transaction_temp_id = l_txn_tmp_id;
2167: BEGIN
2168: x_return_status := fnd_api.g_ret_sts_success;
2169: TRACE('parameters passed to delete_lot_ser_trx', 'INVTRXUB', 9);

Line 2216: FROM mtl_transaction_lots_temp mtlt

2212: --Delete records from MSNT and MTLT
2213: DELETE FROM mtl_serial_numbers_temp msnt
2214: WHERE msnt.transaction_temp_id IN(
2215: SELECT mtlt.serial_transaction_temp_id
2216: FROM mtl_transaction_lots_temp mtlt
2217: WHERE mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
2218: AND mtlt.transaction_temp_id = p_trx_tmp_id);
2219:
2220: DELETE FROM mtl_transaction_lots_temp WHERE transaction_temp_id = p_trx_tmp_id;

Line 2220: DELETE FROM mtl_transaction_lots_temp WHERE transaction_temp_id = p_trx_tmp_id;

2216: FROM mtl_transaction_lots_temp mtlt
2217: WHERE mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
2218: AND mtlt.transaction_temp_id = p_trx_tmp_id);
2219:
2220: DELETE FROM mtl_transaction_lots_temp WHERE transaction_temp_id = p_trx_tmp_id;
2221:
2222: --Item is only lot controlled. Not serial controlled.
2223: ELSIF(p_serctrl = 1 AND p_lotctrl = 2) THEN
2224:

Line 2225: DELETE mtl_transaction_lots_temp

2221:
2222: --Item is only lot controlled. Not serial controlled.
2223: ELSIF(p_serctrl = 1 AND p_lotctrl = 2) THEN
2224:
2225: DELETE mtl_transaction_lots_temp
2226: WHERE transaction_temp_id = p_trx_tmp_id;
2227:
2228:
2229: TRACE('Records deleted in MTLT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.delete_lot_ser_trx');

Line 2278: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE; -- added for Bug 11931654

2274: l_parent_uom VARCHAR2(3);
2275:
2276: l_serials_tbl inv_globals.varchar_tbl_type;
2277:
2278: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE; -- added for Bug 11931654
2279:
2280:
2281: CURSOR c_child_details IS
2282: SELECT c.inventory_item_id, c.primary_quantity, c.transaction_quantity, c.secondary_transaction_quantity, c.transaction_uom, p.transaction_uom --BUG12753174

Line 2288: -- adding a cursor to store the lot_number for child record with p_child_line_id as transaction_temp_id in mtl_transaction_lots_temp

2284: WHERE c.transaction_temp_id = p_child_line_id
2285: AND p.transaction_temp_id = p_parent_line_id;
2286:
2287: -- Start 1 of Fix for Bug 11931654
2288: -- adding a cursor to store the lot_number for child record with p_child_line_id as transaction_temp_id in mtl_transaction_lots_temp
2289:
2290: CURSOR c_child_lot_details IS
2291: SELECT c.lot_number
2292: FROM mtl_transaction_lots_temp c

Line 2292: FROM mtl_transaction_lots_temp c

2288: -- adding a cursor to store the lot_number for child record with p_child_line_id as transaction_temp_id in mtl_transaction_lots_temp
2289:
2290: CURSOR c_child_lot_details IS
2291: SELECT c.lot_number
2292: FROM mtl_transaction_lots_temp c
2293: WHERE c.transaction_temp_id = p_child_line_id;
2294:
2295: -- End 1 of Fix of Bug 11931654
2296:

Line 2312: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id FROM mtl_transaction_lots_temp

2308: -- Delete the Serials
2309: IF p_serial_control_code NOT IN (1,6) THEN
2310: IF p_lot_control_code = 2 THEN
2311: DELETE mtl_serial_numbers_temp
2312: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id FROM mtl_transaction_lots_temp
2313: WHERE transaction_temp_id = p_parent_line_id)
2314: AND fm_serial_number IN (SELECT msnt.fm_serial_number
2315: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
2316: WHERE mtlt.transaction_temp_id = p_child_line_id

Line 2315: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

2311: DELETE mtl_serial_numbers_temp
2312: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id FROM mtl_transaction_lots_temp
2313: WHERE transaction_temp_id = p_parent_line_id)
2314: AND fm_serial_number IN (SELECT msnt.fm_serial_number
2315: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
2316: WHERE mtlt.transaction_temp_id = p_child_line_id
2317: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id)
2318: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2319:

Line 2322: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id FROM mtl_transaction_lots_temp

2318: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2319:
2320: IF SQL%ROWCOUNT = 0 THEN
2321: DELETE mtl_serial_numbers_temp
2322: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id FROM mtl_transaction_lots_temp
2323: WHERE transaction_temp_id = p_parent_line_id)
2324: AND ROWNUM <= l_child_pri_qty
2325: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2326: END IF;

Line 2360: UPDATE mtl_transaction_lots_temp p

2356: LOOP
2357: FETCH c_child_lot_details INTO l_lot_number;
2358: EXIT WHEN c_child_lot_details%NOTFOUND;
2359:
2360: UPDATE mtl_transaction_lots_temp p
2361: SET (p.primary_quantity, p.transaction_quantity, p.secondary_quantity) =
2362: (SELECT p.primary_quantity - SUM(c.primary_quantity)
2363: , p.transaction_quantity - inv_convert.inv_um_convert(l_item_id, NULL, SUM(c.transaction_quantity), l_child_uom, l_parent_uom, NULL, NULL)
2364: , p.secondary_quantity - SUM(c.secondary_quantity) --BUG12753174

Line 2365: FROM mtl_transaction_lots_temp c

2361: SET (p.primary_quantity, p.transaction_quantity, p.secondary_quantity) =
2362: (SELECT p.primary_quantity - SUM(c.primary_quantity)
2363: , p.transaction_quantity - inv_convert.inv_um_convert(l_item_id, NULL, SUM(c.transaction_quantity), l_child_uom, l_parent_uom, NULL, NULL)
2364: , p.secondary_quantity - SUM(c.secondary_quantity) --BUG12753174
2365: FROM mtl_transaction_lots_temp c
2366: WHERE c.transaction_temp_id = p_child_line_id
2367: AND c.lot_number = l_lot_number
2368: GROUP BY c.lot_number)
2369: WHERE p.transaction_temp_id = p_parent_line_id AND p.lot_number = l_lot_number;

Line 2376: UPDATE mtl_transaction_lots_temp p

2372: CLOSE c_child_lot_details;
2373: -- End 2 of fix for Bug 11931654
2374:
2375: /*
2376: UPDATE mtl_transaction_lots_temp p
2377: SET (p.primary_quantity, p.transaction_quantity) =
2378: (SELECT p.primary_quantity - SUM(c.primary_quantity)
2379: , p.transaction_quantity - inv_convert.inv_um_convert(l_item_id, NULL, SUM(c.transaction_quantity), l_child_uom, l_parent_uom, NULL, NULL)
2380: FROM mtl_transaction_lots_temp c

Line 2380: FROM mtl_transaction_lots_temp c

2376: UPDATE mtl_transaction_lots_temp p
2377: SET (p.primary_quantity, p.transaction_quantity) =
2378: (SELECT p.primary_quantity - SUM(c.primary_quantity)
2379: , p.transaction_quantity - inv_convert.inv_um_convert(l_item_id, NULL, SUM(c.transaction_quantity), l_child_uom, l_parent_uom, NULL, NULL)
2380: FROM mtl_transaction_lots_temp c
2381: WHERE c.transaction_temp_id = p_child_line_id
2382: AND c.lot_number = p.lot_number
2383: GROUP BY c.lot_number)
2384: WHERE p.transaction_temp_id = p_parent_line_id;

Line 2387: DELETE mtl_transaction_lots_temp

2383: GROUP BY c.lot_number)
2384: WHERE p.transaction_temp_id = p_parent_line_id;
2385: */
2386:
2387: DELETE mtl_transaction_lots_temp
2388: WHERE transaction_temp_id = p_parent_line_id
2389: AND primary_quantity <= 0;
2390: END IF;
2391: