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_MISSING_QTY_ACTIONS_ENGINE dependencies on MTL_SERIAL_NUMBERS

Line 166: FROM mtl_serial_numbers msn

162: ELSIF p_lot_control_code = 1 AND p_serial_control_code NOT IN(1, 6) THEN
163: DELETE mtl_allocations_gtmp
164: WHERE transaction_temp_id = p_transaction_temp_id
165: AND serial_number IN( SELECT msn.serial_number
166: FROM mtl_serial_numbers msn
167: WHERE msn.group_mark_id = p_transaction_temp_id);
168: l_deleted_count := SQL%ROWCOUNT;
169: ELSIF p_lot_control_code = 2 AND p_serial_control_code NOT IN(1, 6) THEN
170: DELETE mtl_allocations_gtmp

Line 173: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn

169: ELSIF p_lot_control_code = 2 AND p_serial_control_code NOT IN(1, 6) THEN
170: DELETE mtl_allocations_gtmp
171: WHERE transaction_temp_id = p_transaction_temp_id
172: AND serial_number IN( SELECT msn.serial_number
173: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn
174: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
175: AND msn.group_mark_id = mtlt.serial_transaction_temp_id);
176: l_deleted_count := SQL%ROWCOUNT;
177:

Line 512: INSERT INTO mtl_serial_numbers_temp(

508: print_debug('Lot Secondary Qty = ' || l_lot_sec_qty, l_api_name, g_info);
509: END IF;
510:
511: IF p_serial_control_code NOT IN (1,6) THEN
512: INSERT INTO mtl_serial_numbers_temp(
513: transaction_temp_id
514: , fm_serial_number, to_serial_number, serial_prefix
515: , last_update_date, last_updated_by, creation_date, created_by
516: )

Line 529: UPDATE mtl_serial_numbers

525:
526: --Bug #4929806
527: --Need to set line_mark_id also since the user may change allocated serials
528: --after splitting the allocation
529: UPDATE mtl_serial_numbers
530: SET group_mark_id = l_serial_txn_temp_id
531: , line_mark_id = l_serial_txn_temp_id
532: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
533: WHERE transaction_temp_id = l_serial_txn_temp_id)

Line 532: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp

528: --after splitting the allocation
529: UPDATE mtl_serial_numbers
530: SET group_mark_id = l_serial_txn_temp_id
531: , line_mark_id = l_serial_txn_temp_id
532: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
533: WHERE transaction_temp_id = l_serial_txn_temp_id)
534: AND inventory_item_id = l_item_id;
535: l_update_count := SQL%ROWCOUNT;
536:

Line 551: INSERT INTO mtl_serial_numbers_temp(

547: EXIT WHEN l_rem_txn_qty <= 0;
548: END LOOP;
549: ELSIF p_serial_control_code NOT IN (1,6) THEN
550: -- If Serial Controlled, create Serial Records
551: INSERT INTO mtl_serial_numbers_temp(
552: transaction_temp_id
553: , fm_serial_number, to_serial_number, serial_prefix
554: , last_update_date, last_updated_by, creation_date, created_by
555: )

Line 567: UPDATE mtl_serial_numbers

563:
564: --Bug #4929806
565: --Need to set line_mark_id also since the user may change allocated serials
566: --after splitting the allocation
567: UPDATE mtl_serial_numbers
568: SET group_mark_id = x_new_txn_temp_id
569: , line_mark_id= x_new_txn_temp_id
570: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
571: WHERE transaction_temp_id = x_new_txn_temp_id)

Line 570: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp

566: --after splitting the allocation
567: UPDATE mtl_serial_numbers
568: SET group_mark_id = x_new_txn_temp_id
569: , line_mark_id= x_new_txn_temp_id
570: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
571: WHERE transaction_temp_id = x_new_txn_temp_id)
572: AND inventory_item_id = l_item_id;
573: l_update_count := SQL%ROWCOUNT;
574:

Line 1161: FROM mtl_serial_numbers msn

1157: END IF;
1158:
1159: INSERT INTO mtl_allocations_gtmp(transaction_temp_id, serial_number)
1160: SELECT p_transaction_temp_id, msn.serial_number
1161: FROM mtl_serial_numbers msn
1162: WHERE p_transaction_temp_id IS NOT NULL
1163: AND msn.group_mark_id = p_transaction_temp_id
1164: UNION ALL
1165: SELECT mmtt.transaction_temp_id, msn.serial_number

Line 1166: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn

1162: WHERE p_transaction_temp_id IS NOT NULL
1163: AND msn.group_mark_id = p_transaction_temp_id
1164: UNION ALL
1165: SELECT mmtt.transaction_temp_id, msn.serial_number
1166: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn
1167: WHERE p_transaction_temp_id IS NULL AND p_mo_line_id IS NOT NULL
1168: AND mmtt.move_order_line_id = p_mo_line_id
1169: AND msn.group_mark_id = mmtt.transaction_temp_id;
1170:

Line 1202: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn

1198: END IF;
1199:
1200: INSERT INTO mtl_allocations_gtmp(transaction_temp_id, lot_number, serial_number, transaction_quantity, primary_quantity)
1201: SELECT p_transaction_temp_id, mtlt.lot_number, msn.serial_number, 1, 1
1202: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn
1203: WHERE p_transaction_temp_id IS NOT NULL
1204: AND mtlt.transaction_temp_id = p_transaction_temp_id
1205: AND msn.group_mark_id = mtlt.serial_transaction_temp_id
1206: UNION ALL

Line 1208: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn

1204: AND mtlt.transaction_temp_id = p_transaction_temp_id
1205: AND msn.group_mark_id = mtlt.serial_transaction_temp_id
1206: UNION ALL
1207: SELECT mmtt.transaction_temp_id, mtlt.lot_number, msn.serial_number, 1, 1
1208: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn
1209: WHERE p_transaction_temp_id IS NULL and p_mo_line_id IS NOT NULL
1210: AND mmtt.move_order_line_id = p_mo_line_id
1211: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1212: AND msn.group_mark_id = mtlt.serial_transaction_temp_id;