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_DISPATCH_GEN dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 764: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid

760: --and rownum<2;
761:
762: END IF;
763:
764: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
765: INTO l_txn_hdr_id
766: FROM DUAL;
767:
768: UPDATE mtl_material_transactions_temp

Line 1320: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid

1316: WHERE inventory_item_id = l_eqp_id
1317: AND ROWNUM < 2;
1318: END IF;
1319:
1320: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
1321: INTO l_txn_hdr_id
1322: FROM DUAL;
1323:
1324: UPDATE mtl_material_transactions_temp

Line 2177: SELECT mtl_material_transactions_s.NEXTVAL

2173: WHERE transaction_temp_id = l_temp_id
2174: AND lot_number = l_lot;
2175:
2176: IF l_lot_ser_seq = 0 THEN
2177: SELECT mtl_material_transactions_s.NEXTVAL
2178: INTO l_ser_seq
2179: FROM DUAL;
2180: ELSE
2181: l_ser_seq := l_lot_ser_seq;

Line 6228: SELECT mtl_material_transactions_s.NEXTVAL

6224: AND organization_id = l_org_id;
6225: END IF;
6226: END IF;
6227:
6228: SELECT mtl_material_transactions_s.NEXTVAL
6229: INTO l_new_temp_id
6230: FROM DUAL;
6231:
6232: INSERT INTO mtl_material_transactions_temp

Line 7003: SELECT mtl_material_transactions_s.NEXTVAL

6999: END IF;
7000:
7001: -- Create new MMTT line with qty and primary qty in the LPN, content_lpn_id, transfer_lpn_id
7002:
7003: SELECT mtl_material_transactions_s.NEXTVAL
7004: INTO l_new_temp_id
7005: FROM DUAL;
7006:
7007: IF (l_debug = 1) THEN

Line 7493: SELECT mtl_material_transactions_s.NEXTVAL

7489: l_mtlt_rec.transaction_quantity := l_lpn_lot_primary_qty *(l_qty / l_pr_qty);
7490:
7491: -- get new serial_transaction_id
7492:
7493: SELECT mtl_material_transactions_s.NEXTVAL
7494: INTO l_new_serial_temp_id
7495: FROM DUAL;
7496:
7497: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;

Line 7597: SELECT mtl_material_transactions_s.NEXTVAL

7593:
7594: /* Moved the selection of serial temp id here */
7595: IF (l_serial_code > 1
7596: AND l_serial_code <> 6) THEN
7597: SELECT mtl_material_transactions_s.NEXTVAL
7598: INTO l_new_serial_temp_id
7599: FROM DUAL;
7600:
7601: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;

Line 7682: SELECT mtl_material_transactions_s.NEXTVAL

7678: END IF;
7679:
7680: IF (l_serial_code > 1
7681: AND l_serial_code <> 6) THEN
7682: SELECT mtl_material_transactions_s.NEXTVAL
7683: INTO l_new_serial_temp_id
7684: FROM DUAL;
7685: ELSE
7686: l_new_serial_temp_id := NULL;

Line 9400: SELECT mtl_material_transactions_s.NEXTVAL

9396: END IF;
9397:
9398: -- Create new MMTT line with qty and primary qty picked
9399:
9400: SELECT mtl_material_transactions_s.NEXTVAL
9401: INTO l_new_temp_id
9402: FROM DUAL;
9403:
9404: l_progress := '210';

Line 9854: SELECT mtl_material_transactions_s.NEXTVAL

9850: IF (l_debug = 1) THEN
9851: mydebug('multiple_pick: lot/serial controlled and allocate to serial ON');
9852: END IF;
9853:
9854: SELECT mtl_material_transactions_s.NEXTVAL
9855: INTO l_new_serial_temp_id
9856: FROM DUAL;
9857:
9858: l_progress := '310';

Line 9876: SELECT mtl_material_transactions_s.NEXTVAL

9872: IF (l_debug = 1) THEN
9873: mydebug('multiple_pick: lot controlled only OR lot/serial controlled but Allocate to serial OFF');
9874: END IF;
9875:
9876: SELECT mtl_material_transactions_s.NEXTVAL
9877: INTO l_new_serial_temp_id
9878: FROM DUAL;
9879:
9880: l_progress := '330';

Line 10113: SELECT mtl_material_transactions_s.NEXTVAL

10109:
10110: l_progress := '450';
10111:
10112: IF l_lot_ser_seq = 0 THEN
10113: SELECT mtl_material_transactions_s.NEXTVAL
10114: INTO l_new_serial_temp_id
10115: FROM DUAL;
10116: ELSE
10117: l_new_serial_temp_id := l_lot_ser_seq;

Line 10300: SELECT mtl_material_transactions_s.NEXTVAL

10296:
10297: l_progress := '560';
10298:
10299: IF l_lot_ser_seq = 0 THEN
10300: SELECT mtl_material_transactions_s.NEXTVAL
10301: INTO l_new_serial_temp_id
10302: FROM DUAL;
10303: ELSE
10304: l_new_serial_temp_id := l_lot_ser_seq;

Line 12629: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid

12625: and rownum<2;
12626: */
12627: END IF;
12628:
12629: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
12630: INTO l_txn_hdr_id
12631: FROM DUAL;
12632:
12633: UPDATE mtl_material_transactions_temp

Line 13003: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid

12999: FROM DUAL;
13000:
13001: --mydebug('manual_pick: Before Insert into WMSDT');
13002:
13003: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
13004: INTO l_txn_hdr_id
13005: FROM DUAL;
13006:
13007: UPDATE mtl_material_transactions_temp

Line 14407: SELECT mtl_material_transactions_s.NEXTVAL

14403: IF l_debug = 1 THEN
14404: mydebug('Dispatching Bulk Pick Tasks for TxnHdrID = ' || p_txn_hdr_id || ' : TxnTempID = ' || p_temp_id);
14405: END IF;
14406:
14407: SELECT mtl_material_transactions_s.NEXTVAL
14408: INTO x_new_txn_hdr_id
14409: FROM DUAL;
14410:
14411: OPEN c_parent_mmtt_lines;

Line 14473: select mtl_material_transactions_s.NEXTVAL

14469: l_child_pri_qty := 0;
14470: EXIT WHEN l_parent_txn_qty = 0;
14471: ELSE -- Current Child Qty is greater than Parent Picked Qty
14472:
14473: select mtl_material_transactions_s.NEXTVAL
14474: into l_new_temp_id
14475: from dual; --Added bug3765153
14476:
14477: INSERT INTO mtl_material_transactions_temp

Line 14677: , l_new_temp_id --Changed from mtl_material_transactions_s.NEXTVAL bug3765153

14673: , operation_plan_id
14674: , parent_line_id
14675: )
14676: (SELECT transaction_header_id
14677: , l_new_temp_id --Changed from mtl_material_transactions_s.NEXTVAL bug3765153
14678: , source_code
14679: , source_line_id
14680: , transaction_mode
14681: , lock_flag