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_TASK_LOAD dependencies on WMS_ALLOCATIONS_GTMP

Line 8452: from wms_ALLOCATIONS_GTMP

8448:
8449: --jxlu 10/12/04
8450: CURSOR lot_att IS
8451: SELECT lot_number, sum(transaction_quantity) transaction_quantity
8452: from wms_ALLOCATIONS_GTMP
8453: GROUP BY LOT_NUMBER
8454: ORDER BY LOT_NUMBER;
8455:
8456: --/* Bug 9448490 Lot Substitution Project */ start

Line 11503: DELETE FROM wms_allocations_gtmp;

11499: -- populate the temp table to be used in lot and serial processing
11500: -- ideally this should be done during above process for each case, need
11501: -- revisit them later on
11502:
11503: DELETE FROM wms_allocations_gtmp;
11504:
11505: -- Bug #4141928. No changes required for OPM convergence.
11506: -- Since this is a serial context
11507: IF p_is_sn_alloc = 'Y'

Line 11515: INSERT INTO WMS_ALLOCATIONS_GTMP

11511: END IF;
11512:
11513: IF l_lot_code > 1 AND p_full_lot_allocation IN ('Y', 'P') THEN -- Modified for 14699845 (Flexible Lot Allocation)
11514:
11515: INSERT INTO WMS_ALLOCATIONS_GTMP
11516: (lot_number,
11517: serial_number,
11518: transaction_quantity,
11519: primary_quantity)

Line 11568: INSERT INTO WMS_ALLOCATIONS_GTMP

11564: mydebug('lot controlled. x_trx_qty_alloc:'||x_trx_qty_alloc);
11565: END IF;
11566: --jxlu 10/12/04 end
11567: ELSIF l_lot_code <= 1 THEN -- Added for 14699845 (Flexible Lot Allocation -- not lot controlled
11568: INSERT INTO WMS_ALLOCATIONS_GTMP
11569: (serial_number,
11570: transaction_quantity,
11571: primary_quantity)
11572: SELECT fm_serial_number,1,1

Line 11603: INSERT INTO wms_allocations_gtmp

11599: mydebug('SN control and SN allocation off and x_match=3');
11600: END IF;
11601:
11602: IF l_lot_code > 1 AND p_full_lot_allocation IN ('Y', 'P') THEN -- Modified for 14699845 (Flexible Lot Allocation)
11603: INSERT INTO wms_allocations_gtmp
11604: (lot_number,
11605: serial_number,
11606: transaction_quantity,
11607: primary_quantity)

Line 11617: INSERT INTO wms_allocations_gtmp

11613: AND mtlt.lot_number = msn.lot_number
11614: AND msn.inventory_item_id = p_item_id
11615: AND Nvl(msn.group_mark_id, -1) = -1;
11616: ELSIF l_lot_code <= 1 THEN -- Modified for 14699845 (Flexible Lot Allocation) -- not lot controlled
11617: INSERT INTO wms_allocations_gtmp
11618: (serial_number,
11619: transaction_quantity,
11620: primary_quantity)
11621: SELECT serial_number,1,1

Line 11645: INSERT INTO wms_allocations_gtmp(lot_number, primary_quantity,

11641: IF (l_debug = 1) THEN
11642: mydebug('index is : ' || l_table_count);
11643: END IF;
11644:
11645: INSERT INTO wms_allocations_gtmp(lot_number, primary_quantity,
11646: transaction_quantity, secondary_quantity) -- Bug #4141928
11647: values(t_lpn_lot_qty_table(l_table_count).lot_number,
11648: t_lpn_lot_qty_table(l_table_count).pri_qty,
11649: t_lpn_lot_qty_table(l_table_count).trx_qty,

Line 12084: from wms_ALLOCATIONS_GTMP

12080: ORDER BY LOT_NUMBER;
12081:
12082: CURSOR lot_att IS
12083: SELECT lot_number, sum(transaction_quantity) transaction_quantity
12084: from wms_ALLOCATIONS_GTMP
12085: GROUP BY LOT_NUMBER
12086: ORDER BY LOT_NUMBER;
12087:
12088: CURSOR mmtt_csr IS

Line 12139: DELETE wms_allocations_gtmp;

12135:
12136: x_return_status := fnd_api.g_ret_sts_success;
12137: x_lot_att_vector := null;
12138:
12139: DELETE wms_allocations_gtmp;
12140: t_lpn_lot_qty_table.DELETE;
12141:
12142: x_trx_qty := 0;
12143: x_trx_sec_qty := 0; -- Bug #4141928

Line 12162: INSERT INTO wms_allocations_gtmp

12158: mydebug('SN control and SN allocation on');
12159: END IF;
12160:
12161: IF p_is_lot_control ='true' THEN --{ lot controlled
12162: INSERT INTO wms_allocations_gtmp
12163: (lot_number,
12164: serial_number,
12165: transaction_quantity,
12166: primary_quantity)

Line 12189: INSERT INTO wms_ALLOCATIONS_GTMP

12185: t_lpn_lot_qty_table(l_table_index).lot_number := lot_ATT_rec.lot_number;
12186: t_lpn_lot_qty_table(l_table_index).trx_qty := lot_ATT_rec.transaction_quantity;
12187: END LOOP;
12188: ELSE -- not lot controlled
12189: INSERT INTO wms_ALLOCATIONS_GTMP
12190: (serial_number,
12191: transaction_quantity,
12192: primary_quantity)
12193: SELECT fm_serial_number,1,1

Line 12419: INSERT INTO wms_ALLOCATIONS_GTMP

12415: mydebug('inserting into global temp table for serial is non allocated....');
12416: END IF;
12417: -- If negative Balance allowed then update vikas 09/07/04 V1
12418: IF (p_is_negbal_allowed ='true') THEN
12419: INSERT INTO wms_ALLOCATIONS_GTMP
12420: (lot_number,
12421: primary_quantity,
12422: transaction_quantity,
12423: secondary_quantity) -- Bug #4141928

Line 12431: INSERT INTO wms_ALLOCATIONS_GTMP

12427: l_trx_lot_sec_qty);
12428:
12429: -- vikas 09/07/04 end
12430: ELSE
12431: INSERT INTO wms_ALLOCATIONS_GTMP
12432: (lot_number,
12433: primary_quantity,
12434: transaction_quantity,
12435: secondary_quantity) -- Bug #4141928

Line 15134: INSERT INTO wms_allocations_gtmp(lot_number, primary_quantity,

15130: IF (l_debug = 1) THEN
15131: mydebug('index is : ' || l_table_count);
15132: END IF;
15133:
15134: INSERT INTO wms_allocations_gtmp(lot_number, primary_quantity,
15135: transaction_quantity)
15136: values(t_lpn_lot_qty_table(l_table_count).lot_number,
15137: t_lpn_lot_qty_table(l_table_count).pri_qty,
15138: t_lpn_lot_qty_table(l_table_count).trx_qty);