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 595: INSERT INTO mtl_serial_numbers_temp(

591: print_debug('Lot Secondary Qty = ' || l_lot_sec_qty, l_api_name, g_info);
592: END IF;
593:
594: IF p_serial_control_code NOT IN (1,6) THEN
595: INSERT INTO mtl_serial_numbers_temp(
596: transaction_temp_id
597: , fm_serial_number, to_serial_number, serial_prefix
598: , last_update_date, last_updated_by, creation_date, created_by
599: )

Line 612: UPDATE mtl_serial_numbers

608:
609: --Bug #4929806
610: --Need to set line_mark_id also since the user may change allocated serials
611: --after splitting the allocation
612: UPDATE mtl_serial_numbers
613: SET group_mark_id = l_serial_txn_temp_id
614: , line_mark_id = l_serial_txn_temp_id
615: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
616: WHERE transaction_temp_id = l_serial_txn_temp_id)

Line 615: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp

611: --after splitting the allocation
612: UPDATE mtl_serial_numbers
613: SET group_mark_id = l_serial_txn_temp_id
614: , line_mark_id = l_serial_txn_temp_id
615: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
616: WHERE transaction_temp_id = l_serial_txn_temp_id)
617: AND inventory_item_id = l_item_id;
618: l_update_count := SQL%ROWCOUNT;
619:

Line 634: INSERT INTO mtl_serial_numbers_temp(

630: EXIT WHEN l_rem_txn_qty <= 0;
631: END LOOP;
632: ELSIF p_serial_control_code NOT IN (1,6) THEN
633: -- If Serial Controlled, create Serial Records
634: INSERT INTO mtl_serial_numbers_temp(
635: transaction_temp_id
636: , fm_serial_number, to_serial_number, serial_prefix
637: , last_update_date, last_updated_by, creation_date, created_by
638: )

Line 650: UPDATE mtl_serial_numbers

646:
647: --Bug #4929806
648: --Need to set line_mark_id also since the user may change allocated serials
649: --after splitting the allocation
650: UPDATE mtl_serial_numbers
651: SET group_mark_id = x_new_txn_temp_id
652: , line_mark_id= x_new_txn_temp_id
653: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
654: WHERE transaction_temp_id = x_new_txn_temp_id)

Line 653: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp

649: --after splitting the allocation
650: UPDATE mtl_serial_numbers
651: SET group_mark_id = x_new_txn_temp_id
652: , line_mark_id= x_new_txn_temp_id
653: WHERE serial_number IN (SELECT fm_serial_number FROM mtl_serial_numbers_temp
654: WHERE transaction_temp_id = x_new_txn_temp_id)
655: AND inventory_item_id = l_item_id;
656: l_update_count := SQL%ROWCOUNT;
657:

Line 1308: FROM mtl_serial_numbers msn

1304: END IF;
1305:
1306: INSERT INTO mtl_allocations_gtmp(transaction_temp_id, serial_number)
1307: SELECT p_transaction_temp_id, msn.serial_number
1308: FROM mtl_serial_numbers msn
1309: WHERE p_transaction_temp_id IS NOT NULL
1310: AND msn.group_mark_id = p_transaction_temp_id
1311: UNION ALL
1312: SELECT mmtt.transaction_temp_id, msn.serial_number

Line 1313: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn

1309: WHERE p_transaction_temp_id IS NOT NULL
1310: AND msn.group_mark_id = p_transaction_temp_id
1311: UNION ALL
1312: SELECT mmtt.transaction_temp_id, msn.serial_number
1313: FROM mtl_material_transactions_temp mmtt, mtl_serial_numbers msn
1314: WHERE p_transaction_temp_id IS NULL AND p_mo_line_id IS NOT NULL
1315: AND mmtt.move_order_line_id = p_mo_line_id
1316: AND msn.group_mark_id = mmtt.transaction_temp_id;
1317:

Line 1349: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn

1345: END IF;
1346:
1347: INSERT INTO mtl_allocations_gtmp(transaction_temp_id, lot_number, serial_number, transaction_quantity, primary_quantity)
1348: SELECT p_transaction_temp_id, mtlt.lot_number, msn.serial_number, 1, 1
1349: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn
1350: WHERE p_transaction_temp_id IS NOT NULL
1351: AND mtlt.transaction_temp_id = p_transaction_temp_id
1352: AND msn.group_mark_id = mtlt.serial_transaction_temp_id
1353: UNION ALL

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

1351: AND mtlt.transaction_temp_id = p_transaction_temp_id
1352: AND msn.group_mark_id = mtlt.serial_transaction_temp_id
1353: UNION ALL
1354: SELECT mmtt.transaction_temp_id, mtlt.lot_number, msn.serial_number, 1, 1
1355: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers msn
1356: WHERE p_transaction_temp_id IS NULL and p_mo_line_id IS NOT NULL
1357: AND mmtt.move_order_line_id = p_mo_line_id
1358: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
1359: AND msn.group_mark_id = mtlt.serial_transaction_temp_id;