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

Line 5133: UPDATE mtl_serial_numbers

5129: END IF;
5130:
5131: -- Update the location information for serialized packed items
5132: FORALL bulk_i IN l_tmp_bulk_lpns.lpn_id.first .. l_tmp_bulk_lpns.lpn_id.last
5133: UPDATE mtl_serial_numbers
5134: SET current_organization_id = l_lpn.organization_id
5135: , current_subinventory_code = l_lpn.subinventory_code
5136: , current_locator_id = l_lpn.locator_id
5137: , last_update_date = SYSDATE

Line 5189: UPDATE mtl_serial_numbers

5185:
5186: -- Serialized item packed LPN information are stored in the serial numbers table
5187: -- Also update the cost group field since it is not guaranteed that the serial number will
5188: -- have that value stamped
5189: UPDATE mtl_serial_numbers
5190: SET lpn_id = p_lpn_id
5191: , cost_group_id = p_cost_group_id
5192: , last_update_date = SYSDATE
5193: , last_updated_by = fnd_global.user_id

Line 5491: UPDATE mtl_serial_numbers

5487: AND parent_lpn_id = l_child_lpn.lpn_id;
5488: END IF;
5489:
5490: -- Update the location information for serialized packed items
5491: UPDATE mtl_serial_numbers
5492: SET current_organization_id = p_organization_id
5493: , current_subinventory_code = l_subinventory
5494: , current_locator_id = l_locator_id
5495: , last_update_date = SYSDATE

Line 5562: UPDATE mtl_serial_numbers

5558: l_progress := 'Unacking serialized items sn '||p_from_serial_number||'-'||p_to_serial_number;
5559:
5560: -- Serialized item packed LPN information are stored
5561: -- in the serial numbers table
5562: UPDATE mtl_serial_numbers
5563: SET lpn_id = NULL
5564: , last_update_date = SYSDATE
5565: , last_updated_by = fnd_global.user_id
5566: WHERE inventory_item_id = p_content_item_id

Line 5868: UPDATE mtl_serial_numbers

5864: END IF;
5865:
5866: -- Update the information for serialized packed items
5867: FORALL bulk_i IN l_tmp_bulk_lpns.lpn_id.first .. l_tmp_bulk_lpns.lpn_id.last
5868: UPDATE mtl_serial_numbers
5869: SET last_update_date = SYSDATE
5870: , last_updated_by = fnd_global.user_id
5871: , lpn_id = NULL
5872: WHERE lpn_id = l_tmp_bulk_lpns.lpn_id(bulk_i);

Line 7229: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt1, mtl_serial_numbers_temp msnt2

7225: NVL(msnt1.fm_serial_number, msnt2.fm_serial_number),
7226: NVL(msnt1.to_serial_number, msnt2.to_serial_number)
7227: , mmtt.secondary_transaction_quantity --INVCONV kkillams
7228: , mmtt.secondary_uom_code --INVCONV kkillams
7229: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt1, mtl_serial_numbers_temp msnt2
7230: WHERE mmtt.organization_id = p_organization_id
7231: AND mmtt.transaction_header_id = l_trx_header_id
7232: AND mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
7233: AND msnt1.transaction_temp_id(+) = mtlt.serial_transaction_temp_id

Line 7492: --Insert serials into MTL_SERIAL_NUMBERS_TEMP

7488: IF (l_debug = 1) THEN
7489: mdebug('inserting serials '|| l_serial_number_from || '-' || l_serial_number_to || ' into mmtt', G_INFO);
7490: mdebug('with l_trx_tmp_id='|| l_trx_tmp_id, G_INFO);
7491: END IF;
7492: --Insert serials into MTL_SERIAL_NUMBERS_TEMP
7493: x_error_code := inv_trx_util_pub.insert_ser_trx(
7494: p_trx_tmp_id=> l_trx_tmp_id,
7495: p_user_id=> fnd_global.user_id,
7496: p_fm_ser_num=> l_serial_number_from,

Line 8076: UPDATE mtl_serial_numbers

8072: -- in the serial numbers table
8073: -- Also update the cost group field since it is not
8074: -- guaranteed that the serial number will have that value stamped
8075: -- if serial status is not resides in store (3), update lot and rev
8076: UPDATE mtl_serial_numbers
8077: SET lpn_id = p_lpn_id,
8078: last_update_date = SYSDATE,
8079: last_updated_by = fnd_global.user_id,
8080: last_txn_source_type_id = p_source_type_id,

Line 8204: FROM MTL_SERIAL_NUMBERS

8200:
8201: CURSOR lpn_serial_contents_cursor IS
8202: SELECT inventory_item_id, current_organization_id, lpn_id,
8203: revision, lot_number, serial_number, cost_group_id
8204: FROM MTL_SERIAL_NUMBERS
8205: WHERE lpn_id = l_current_lpn
8206: -- bug 5103594, added the Order By clause
8207: ORDER BY inventory_item_id, revision, lot_number, serial_number;
8208:

Line 8663: FROM mtl_serial_numbers

8659: --check to see if there are any serial numbers associated with lpn
8660: BEGIN
8661: SELECT WMS_CONTAINER_PVT.F
8662: INTO l_lpn_is_valid
8663: FROM mtl_serial_numbers
8664: WHERE current_organization_id = p_organization_id
8665: AND lpn_id = lpn_rec.lpn_id
8666: AND rownum < 2;
8667: IF ( l_debug = 1 ) THEN

Line 8761: FROM mtl_serial_numbers

8757: l_next_item_rec LPN_item_cur%ROWTYPE;
8758:
8759: CURSOR LPN_serial_cur (p_lpn_id NUMBER, p_item_id NUMBER, p_revision VARCHAR2, p_lot_number VARCHAR2) IS
8760: SELECT serial_number
8761: FROM mtl_serial_numbers
8762: WHERE current_organization_id = p_organization_id
8763: AND inventory_item_id = p_item_id
8764: AND lpn_id = p_lpn_id
8765: AND NVL(revision, '@') = NVL(p_revision, '@')

Line 8921: -- Insert record into MTL_SERIAL_NUMBERS_TEMP

8917: END IF;
8918: l_insert_lot_rec := FALSE;
8919: END IF;
8920:
8921: -- Insert record into MTL_SERIAL_NUMBERS_TEMP
8922: IF ( l_insert_ser_rec ) THEN
8923: OPEN LPN_serial_cur(Nested_LPN_rec.lpn_id, l_crnt_item_rec.inventory_item_id,
8924: l_crnt_item_rec.revision, l_crnt_item_rec.lot_number);
8925: FETCH LPN_serial_cur INTO l_crnt_ser_rec;