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

Line 225: FROM mtl_serial_numbers_temp msnt

221: -- Start Bug 4434111
222: CURSOR c_get_serials(p_transaction_temp_id NUMBER) IS
223: SELECT msnt.fm_serial_number,
224: msnt.to_serial_number
225: FROM mtl_serial_numbers_temp msnt
226: WHERE msnt.transaction_temp_id = p_transaction_temp_id;
227: --
228: l_serial_alloc_flag mtl_material_transactions_temp.serial_allocated_flag%TYPE := 'N';
229: l_user_id NUMBER;

Line 235: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

231: l_to_serial_number VARCHAR2(30);
232: --
233: CURSOR c_get_serialLots(p_transaction_temp_id NUMBER) IS
234: SELECT msnt.fm_serial_number, msnt.to_serial_number
235: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
236: WHERE msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
237: AND mtlt.transaction_temp_id = p_transaction_temp_id;
238: -- End Bug 4434111
239: BEGIN

Line 488: FROM mtl_serial_numbers_temp msnt

484: BEGIN
485: IF l_lot_control_code = 1 THEN -- not lot controlled
486: SELECT msnt.transaction_temp_id
487: INTO l_serial_temp_id
488: FROM mtl_serial_numbers_temp msnt
489: WHERE msnt.transaction_temp_id = l_transaction_temp_id
490: AND ROWNUM < 2;
491: ELSE -- lot controlled
492: SELECT msnt.transaction_temp_id

Line 494: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

490: AND ROWNUM < 2;
491: ELSE -- lot controlled
492: SELECT msnt.transaction_temp_id
493: INTO l_serial_temp_id
494: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
495: WHERE msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, -1)
496: AND mtlt.transaction_temp_id = l_transaction_temp_id
497: AND ROWNUM < 2;
498: END IF;

Line 534: UPDATE mtl_serial_numbers

530: mydebug('Inventory Item ID = ' || l_inventory_item_id, l_api_name);
531: mydebug('Org ID = ' || l_org_id, l_api_name);
532: END IF;
533: --
534: UPDATE mtl_serial_numbers
535: SET group_mark_id = NULL,
536: last_update_date = Sysdate,
537: last_updated_by = l_user_id
538: WHERE serial_number >= l_fm_serial_number

Line 550: DELETE FROM mtl_serial_numbers_temp

546: --}
547: END LOOP;
548: CLOSE c_get_serials;
549: --
550: DELETE FROM mtl_serial_numbers_temp
551: WHERE transaction_temp_id = l_transaction_temp_id;
552: --
553: IF (l_debug = 1) THEN
554: mydebug('Rows deleted ' || sql%rowcount, l_api_name);

Line 576: UPDATE mtl_serial_numbers

572: mydebug('Inventory Item ID = ' || l_inventory_item_id, l_api_name);
573: mydebug('Org ID = ' || l_org_id, l_api_name);
574: END IF;
575: --
576: UPDATE mtl_serial_numbers
577: SET group_mark_id = NULL,
578: last_update_date = Sysdate,
579: last_updated_by = l_user_id
580: WHERE serial_number >= l_fm_serial_number

Line 592: DELETE FROM mtl_serial_numbers_temp

588: --}
589: END LOOP;
590: CLOSE c_get_serialLots;
591: --
592: DELETE FROM mtl_serial_numbers_temp
593: WHERE transaction_temp_id IN
594: (
595: SELECT serial_transaction_temp_id
596: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

Line 596: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

592: DELETE FROM mtl_serial_numbers_temp
593: WHERE transaction_temp_id IN
594: (
595: SELECT serial_transaction_temp_id
596: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
597: WHERE msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
598: AND mtlt.transaction_temp_id = l_transaction_temp_id
599: );
600: --

Line 679: UPDATE mtl_serial_numbers

675: exit when c_same_lot_csr%NOTFOUND;
676: l_sum_same_lot_pri_qty := l_sum_same_lot_pri_qty + l_same_lot_pri_qty;
677: l_sum_same_lot_tra_qty := l_sum_same_lot_tra_qty + l_same_lot_tra_qty;
678:
679: UPDATE mtl_serial_numbers
680: SET group_mark_id = l_new_serial_temp_id
681: WHERE current_organization_id = l_org_id
682: AND inventory_item_id = l_inventory_item_id
683: AND serial_number in (select fm_serial_number

Line 684: from mtl_serial_numbers_temp

680: SET group_mark_id = l_new_serial_temp_id
681: WHERE current_organization_id = l_org_id
682: AND inventory_item_id = l_inventory_item_id
683: AND serial_number in (select fm_serial_number
684: from mtl_serial_numbers_temp
685: where transaction_temp_id = l_serial_temp_id);
686: UPDATE mtl_serial_numbers_temp
687: SET transaction_temp_id = l_new_serial_temp_id
688: WHERE transaction_temp_id = l_serial_temp_id;

Line 686: UPDATE mtl_serial_numbers_temp

682: AND inventory_item_id = l_inventory_item_id
683: AND serial_number in (select fm_serial_number
684: from mtl_serial_numbers_temp
685: where transaction_temp_id = l_serial_temp_id);
686: UPDATE mtl_serial_numbers_temp
687: SET transaction_temp_id = l_new_serial_temp_id
688: WHERE transaction_temp_id = l_serial_temp_id;
689:
690: end loop;

Line 1772: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

1768: l_txn_temp_id NUMBER;
1769:
1770: CURSOR c_serial_list(p_txn_temp_id IN NUMBER, p_lot_num IN VARCHAR2) IS
1771: SELECT msnt.fm_serial_number
1772: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
1773: WHERE p_lot_num IS NOT NULL
1774: AND mtlt.transaction_temp_id = p_txn_temp_id
1775: AND mtlt.lot_number = p_lot_num
1776: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 1779: FROM mtl_serial_numbers_temp msnt

1775: AND mtlt.lot_number = p_lot_num
1776: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
1777: UNION ALL
1778: SELECT msnt.fm_serial_number
1779: FROM mtl_serial_numbers_temp msnt
1780: WHERE p_lot_num IS NULL
1781: AND msnt.transaction_temp_id = p_txn_temp_id
1782: ORDER BY 1;
1783: BEGIN

Line 1869: FROM mtl_serial_numbers_temp msnt

1865: CURSOR c_fm_to_serial_number IS
1866: SELECT
1867: msnt.fm_serial_number,
1868: msnt.to_serial_number
1869: FROM mtl_serial_numbers_temp msnt
1870: WHERE msnt.transaction_temp_id = p_transaction_temp_id;
1871:
1872: CURSOR c_fm_to_lot_serial_number IS
1873: SELECT

Line 1877: mtl_serial_numbers_temp msnt,

1873: SELECT
1874: msnt.fm_serial_number,
1875: msnt.to_serial_number
1876: FROM
1877: mtl_serial_numbers_temp msnt,
1878: mtl_transaction_lots_temp mtlt
1879: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
1880: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
1881:

Line 1885: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;

1881:
1882: l_item_id NUMBER := NULL;
1883: l_serial_ctrl_code NUMBER;
1884: l_lot_ctrl_code NUMBER ;
1885: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
1886: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
1887: l_txn_hdr_id NUMBER;
1888: /*6009436 End */
1889:

Line 1886: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;

1882: l_item_id NUMBER := NULL;
1883: l_serial_ctrl_code NUMBER;
1884: l_lot_ctrl_code NUMBER ;
1885: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
1886: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
1887: l_txn_hdr_id NUMBER;
1888: /*6009436 End */
1889:
1890: BEGIN

Line 2117: UPDATE MTL_SERIAL_NUMBERS msn

2113: FETCH c_fm_to_lot_serial_number
2114: INTO l_fm_serial_number,l_to_serial_number;
2115: EXIT WHEN c_fm_to_lot_serial_number%NOTFOUND;
2116:
2117: UPDATE MTL_SERIAL_NUMBERS msn
2118: SET GROUP_MARK_ID=l_txn_hdr_id
2119: WHERE msn.current_organization_id=p_organization_id
2120: AND msn.inventory_item_id= l_item_id
2121: AND msn.SERIAL_NUMBER BETWEEN l_fm_serial_number AND

Line 2126: UPDATE mtl_serial_numbers_temp

2122: l_to_serial_number;
2123: END LOOP;
2124: CLOSE c_fm_to_lot_serial_number;
2125:
2126: UPDATE mtl_serial_numbers_temp
2127: SET group_header_id= l_txn_hdr_id
2128: WHERE transaction_temp_id in ( SELECT serial_transaction_temp_id
2129: FROM mtl_transaction_lots_temp
2130: WHERE transaction_temp_id= p_transaction_temp_id );

Line 2139: UPDATE MTL_SERIAL_NUMBERS msn

2135: FETCH c_fm_to_serial_number
2136: INTO l_fm_serial_number,l_to_serial_number;
2137: EXIT WHEN c_fm_to_serial_number%NOTFOUND;
2138:
2139: UPDATE MTL_SERIAL_NUMBERS msn
2140: SET GROUP_MARK_ID=l_txn_hdr_id
2141: WHERE msn.current_organization_id=p_organization_id
2142: AND msn.inventory_item_id= l_item_id
2143: AND msn.SERIAL_NUMBER BETWEEN l_fm_serial_number AND

Line 2148: UPDATE mtl_serial_numbers_temp

2144: l_to_serial_number;
2145: END LOOP;
2146: CLOSE c_fm_to_serial_number;
2147:
2148: UPDATE mtl_serial_numbers_temp
2149: SET group_header_id= l_txn_hdr_id
2150: WHERE transaction_temp_id=p_transaction_temp_id ;
2151:
2152: END IF;

Line 3803: FROM mtl_serial_numbers_temp

3799: MAX(status_id)
3800: INTO x_resultant_task_details(l_index).from_serial_number ,
3801: x_resultant_task_details(l_index).to_serial_number ,
3802: x_resultant_task_details(l_index).serial_status_id
3803: FROM mtl_serial_numbers_temp
3804: WHERE transaction_temp_id = l_mtlt_row.serial_transaction_temp_id;
3805: END IF;
3806: END LOOP;
3807: CLOSE mtlt_changed;

Line 3822: FROM mtl_serial_numbers_temp

3818: INTO x_resultant_task_details(l_index).from_serial_number ,
3819: x_resultant_task_details(l_index).to_serial_number ,
3820: x_resultant_task_details(l_index).serial_status_id ,
3821: x_resultant_task_details(l_index).number_of_serials
3822: FROM mtl_serial_numbers_temp
3823: WHERE transaction_temp_id = new_task_table(i).transaction_temp_id;
3824: END LOOP;
3825: END IF;
3826: IF g_debug = 1 THEN

Line 4100: FROM mtl_serial_numbers_temp

4096: BEGIN
4097: --serial quantity
4098: SELECT sum(1)
4099: INTO l_msnt_transaction_qty
4100: FROM mtl_serial_numbers_temp
4101: WHERE transaction_temp_id IN
4102: (SELECT serial_transaction_temp_id
4103: FROM mtl_transaction_lots_temp
4104: WHERE transaction_temp_id = p_transaction_temp_id

Line 4151: FROM mtl_serial_numbers_temp

4147: END IF;
4148: --Serial quantity
4149: SELECT sum(1)
4150: INTO l_msnt_transaction_qty
4151: FROM mtl_serial_numbers_temp
4152: WHERE transaction_temp_id = p_transaction_temp_id;
4153: IF l_msnt_transaction_qty <> l_mmtt_transaction_quantity THEN
4154: x_return_status := 'E';
4155: IF g_debug = 1 THEN

Line 4947: FROM mtl_serial_numbers_temp msnt

4943: CURSOR C_MSNT
4944: IS
4945: SELECT rowid,
4946: msnt.*
4947: FROM mtl_serial_numbers_temp msnt
4948: WHERE transaction_temp_id = p_orig_transaction_temp_id
4949: ORDER BY fm_serial_number;
4950:
4951: l_transaction_remaining_qty NUMBER;

Line 4964: UPDATE mtl_serial_numbers_temp

4960: END IF;
4961: FOR msnt IN C_MSNT
4962: LOOP
4963: l_transaction_remaining_qty := l_transaction_remaining_qty - 1;
4964: UPDATE mtl_serial_numbers_temp
4965: SET transaction_temp_id = p_new_transaction_temp_id ,
4966: last_updated_by = FND_GLOBAL.USER_ID
4967: WHERE rowid = msnt.rowid;
4968: UPDATE mtl_serial_numbers msn

Line 4968: UPDATE mtl_serial_numbers msn

4964: UPDATE mtl_serial_numbers_temp
4965: SET transaction_temp_id = p_new_transaction_temp_id ,
4966: last_updated_by = FND_GLOBAL.USER_ID
4967: WHERE rowid = msnt.rowid;
4968: UPDATE mtl_serial_numbers msn
4969: SET msn.group_mark_id = p_new_transaction_temp_id ,
4970: last_updated_by = FND_GLOBAL.USER_ID
4971: WHERE msn.inventory_item_id = p_inventory_item_id
4972: AND serial_number = msnt.fm_serial_number