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

Line 3390: FROM MTL_SERIAL_NUMBERS

3386: l_current_status,
3387: l_msn_subinv,
3388: l_msn_locator_id,
3389: l_msn_lpn_id
3390: FROM MTL_SERIAL_NUMBERS
3391: WHERE SERIAL_NUMBER = l_serial_number
3392: AND INVENTORY_ITEM_ID = g_cc_entry.inventory_item_id
3393: AND CURRENT_ORGANIZATION_ID = g_cc_entry.organization_id;
3394:

Line 4018: UPDATE mtl_serial_numbers

4014: -- If the entry is a multiple serial entry,
4015: -- unmark the serial explicitly here since it was marked
4016: -- through a different process compared to single serial
4017: IF (l_serial_count_option = 3) THEN
4018: UPDATE mtl_serial_numbers
4019: SET group_mark_id = NULL
4020: WHERE inventory_item_id = l_inventory_item_id
4021: AND current_organization_id = l_org_id
4022: AND serial_number IN

Line 4408: FROM mtl_serial_numbers msn

4404: -- Bug# 2386909
4405: -- Also make sure you query only serials which are loose
4406: SELECT NVL ( SUM ( DECODE ( msn.current_status, 3, 1, 0 ) ), 0 )
4407: INTO l_primary_sys_qty
4408: FROM mtl_serial_numbers msn
4409: WHERE msn.serial_number = NVL ( l_serial_number, serial_number )
4410: AND msn.inventory_item_id = l_item_id
4411: AND msn.current_organization_id = l_org_id
4412: AND msn.current_subinventory_code = l_sub

Line 4475: FROM mtl_serial_numbers msn

4471: l_last_updated_by,
4472: SYSDATE,
4473: l_last_updated_by,
4474: l_last_update_login
4475: FROM mtl_serial_numbers msn
4476: WHERE msn.inventory_item_id = l_item_id
4477: AND msn.current_organization_id = l_org_id
4478: AND msn.current_subinventory_code = l_sub
4479: AND NVL ( msn.lot_number, 'XX' ) = NVL ( l_lot, 'XX' )

Line 4744: FROM mtl_serial_numbers msn

4740: -- Bug# 2386909
4741: -- Also make sure you query only serials which are loose
4742: SELECT NVL ( SUM ( DECODE ( msn.current_status, 3, 1, 0 ) ), 0 )
4743: INTO l_primary_sys_qty
4744: FROM mtl_serial_numbers msn
4745: WHERE msn.serial_number = NVL ( l_serial_number, serial_number )
4746: AND msn.inventory_item_id = l_item_id
4747: AND msn.current_organization_id = l_org_id
4748: AND msn.current_subinventory_code = l_sub

Line 4811: FROM mtl_serial_numbers msn

4807: l_last_updated_by,
4808: SYSDATE,
4809: l_last_updated_by,
4810: l_last_update_login
4811: FROM mtl_serial_numbers msn
4812: WHERE msn.inventory_item_id = l_item_id
4813: AND msn.current_organization_id = l_org_id
4814: AND msn.current_subinventory_code = l_sub
4815: AND NVL ( msn.lot_number, 'XX' ) = NVL ( l_lot, 'XX' )

Line 5094: FROM mtl_serial_numbers_temp s,

5090: IF l_lot_control_code = 1 THEN -- no lot control code
5091: -- just check with msnt
5092: SELECT COUNT ( * )
5093: INTO l_serial_count
5094: FROM mtl_serial_numbers_temp s,
5095: wms_loaded_quantities_v wl
5096: WHERE s.transaction_temp_id = wl.transaction_temp_id
5097: AND p_serial_number BETWEEN s.fm_serial_number
5098: AND s.to_serial_number;

Line 5110: FROM mtl_serial_numbers_temp s,

5106: END IF;
5107: ELSE -- have to join mtlt also
5108: SELECT COUNT ( * )
5109: INTO l_serial_count
5110: FROM mtl_serial_numbers_temp s,
5111: wms_loaded_quantities_v wl,
5112: mtl_transaction_lots_temp l
5113: WHERE wl.transaction_temp_id = l.transaction_temp_id
5114: AND s.transaction_temp_id = l.serial_transaction_temp_id

Line 5129: FROM mtl_serial_numbers s,

5125: END IF; -- lot control code
5126: ELSE -- lpn is not null
5127: SELECT COUNT ( * )
5128: INTO l_serial_count
5129: FROM mtl_serial_numbers s,
5130: wms_loaded_quantities_v wl
5131: WHERE s.lpn_id = p_lpn_id
5132: AND NVL ( wl.content_lpn_id, NVL ( wl.lpn_id, -1 ) ) = s.lpn_id
5133: AND s.serial_number = p_serial_number

Line 5428: -- inserted into MTL_SERIAL_NUMBERS table (If needed).

5424: END IF;
5425:
5426: IF ( l_success = FALSE ) THEN
5427: -- mtl_serial_check.inv_qtybetwn approved our Serial_Number and
5428: -- inserted into MTL_SERIAL_NUMBERS table (If needed).
5429: -- Now we need to perform necessary adjustment transactions.
5430:
5431: IF ( l_debug = 1 ) THEN
5432: print_debug ( 'Serial count option: ' || l_serial_count_option );

Line 5629: FROM mtl_serial_numbers msn

5625: -- it will pick it up and issue out and receive the serial into
5626: -- the sub/loc where it was found during the counting
5627: SELECT NVL ( SUM ( DECODE ( msn.current_status, 3, 1, 0 ) ), 0 )
5628: INTO l_multiple_count
5629: FROM mtl_serial_numbers msn
5630: WHERE msn.serial_number = g_cc_serial_entry.serial_number
5631: AND msn.inventory_item_id = g_cc_entry.inventory_item_id
5632: AND msn.current_organization_id = g_cc_entry.organization_id
5633: AND msn.current_subinventory_code = g_cc_entry.subinventory

Line 5654: FROM mtl_serial_numbers msn

5650: -- we will do a sub transfer for the discrepant LPN which will
5651: -- also move the serial packed within it
5652: SELECT NVL ( SUM ( DECODE ( msn.current_status, 3, 1, 0 ) ), 0 )
5653: INTO l_multiple_count
5654: FROM mtl_serial_numbers msn
5655: WHERE msn.serial_number = g_cc_serial_entry.serial_number
5656: AND msn.inventory_item_id = g_cc_entry.inventory_item_id
5657: AND msn.current_organization_id = g_cc_entry.organization_id
5658: AND NVL ( msn.lot_number, 'XX' ) =

Line 6166: FROM MTL_SERIAL_NUMBERS

6162: SELECT CURRENT_SUBINVENTORY_CODE,
6163: NVL ( CURRENT_LOCATOR_ID, 0 )
6164: INTO l_msn_subinv,
6165: l_msn_locator_id
6166: FROM MTL_SERIAL_NUMBERS
6167: WHERE SERIAL_NUMBER = u1
6168: AND INVENTORY_ITEM_ID = g_cc_entry.inventory_item_id
6169: AND CURRENT_ORGANIZATION_ID = g_cc_entry.organization_id;
6170:

Line 6234: FROM MTL_SERIAL_NUMBERS

6230: SELECT 1,
6231: current_status
6232: INTO serial_count,
6233: l_current_status
6234: FROM MTL_SERIAL_NUMBERS
6235: WHERE SERIAL_NUMBER = l_serial_number
6236: AND INVENTORY_ITEM_ID = l_item_id
6237: AND CURRENT_ORGANIZATION_ID = l_org_id
6238: AND CURRENT_STATUS IN ( 1, 3 );

Line 6652: FROM MTL_SERIAL_NUMBERS

6648: l_current_status,
6649: l_msn_subinv,
6650: l_msn_locator_id,
6651: l_msn_lpn_id
6652: FROM MTL_SERIAL_NUMBERS
6653: WHERE SERIAL_NUMBER = l_serial_number
6654: AND INVENTORY_ITEM_ID = g_cc_entry.inventory_item_id
6655: AND CURRENT_ORGANIZATION_ID = g_cc_entry.organization_id;
6656:

Line 7112: -- instead since these are the primary keys for MTL_SERIAL_NUMBERS

7108: --g6 := NULL;
7109:
7110: -- New call to serial_check.inv_unmark_serial
7111: -- For performance reasons, pass the serial number and item id
7112: -- instead since these are the primary keys for MTL_SERIAL_NUMBERS
7113: IF ( l_serial_number_ctrl_code IN ( 2, 5 ) ) THEN
7114: IF ( l_serial_count_option = 2 ) THEN
7115: g1 := l_current_serial;
7116: g2 := l_current_serial;

Line 7266: FROM MTL_SERIAL_NUMBERS

7262:
7263: CURSOR lpn_serial_contents_cursor
7264: IS
7265: SELECT *
7266: FROM MTL_SERIAL_NUMBERS
7267: WHERE lpn_id = l_current_lpn;
7268:
7269: CURSOR lpn_multiple_serial_cursor
7270: IS

Line 7750: FROM mtl_serial_numbers

7746:
7747: IF ( p_serial_number IS NOT NULL ) THEN
7748: SELECT NVL ( cost_group_id, -999 )
7749: INTO l_cost_group_id
7750: FROM mtl_serial_numbers
7751: WHERE serial_number = p_serial_number
7752: AND inventory_item_id = p_inventory_item_id
7753: AND NVL ( revision, '@@@@@' ) = NVL ( p_revision, '@@@@@' )
7754: AND NVL ( lot_number, '@@@@@' ) = NVL ( p_lot_number, '@@@@@' )

Line 7872: FROM mtl_serial_numbers

7868: -- serial number's group mark ID to determine if it was
7869: -- counted as present or not
7870: SELECT group_mark_id
7871: INTO l_group_mark_id
7872: FROM mtl_serial_numbers
7873: WHERE serial_number = g_cc_serial_entry.serial_number
7874: AND current_organization_id = g_cc_entry.organization_id
7875: AND inventory_item_id = g_cc_entry.inventory_item_id;
7876:

Line 8023: FROM mtl_serial_numbers

8019: -- the updating in the same cursor used previously does not save
8020: -- and we do not want to necessarily do a commit yet.
8021: SELECT group_mark_id
8022: INTO l_group_mark_id
8023: FROM mtl_serial_numbers
8024: WHERE serial_number = g_cc_serial_entry.serial_number
8025: AND current_organization_id = g_cc_entry.organization_id
8026: AND inventory_item_id = g_cc_entry.inventory_item_id;
8027:

Line 8118: UPDATE mtl_serial_numbers

8114: || g_cc_serial_entry.serial_number
8115: );
8116: END IF;
8117:
8118: UPDATE mtl_serial_numbers
8119: SET group_mark_id = NULL
8120: WHERE serial_number = g_cc_serial_entry.serial_number
8121: AND current_organization_id = g_cc_entry.organization_id
8122: AND inventory_item_id = g_cc_entry.inventory_item_id;

Line 8458: -- total number of serials inserted into mtl_serial_numbers

8454: l_temp_prefix,
8455: l_from_ser_number
8456: );
8457: l_progress := '40';
8458: -- total number of serials inserted into mtl_serial_numbers
8459: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
8460: l_serial_num_length := LENGTH ( p_from_serial_number );
8461: l_prefix_length := LENGTH ( l_temp_prefix );
8462:

Line 8475: UPDATE mtl_serial_numbers

8471: '0'
8472: );
8473: l_progress := '50';
8474:
8475: UPDATE mtl_serial_numbers
8476: SET previous_status = current_status,
8477: current_status = p_current_status,
8478: lot_number = p_lot_number,
8479: current_organization_id = p_organization_id

Line 8957: FROM mtl_serial_numbers

8953: END IF;
8954:
8955: SELECT NVL ( SUM ( DECODE ( current_status, 3, 1, 0 ) ), 0 )
8956: INTO x_system_quantity
8957: FROM mtl_serial_numbers
8958: WHERE lpn_id IS NULL
8959: AND inventory_item_id = p_inventory_item_id
8960: AND current_organization_id = p_organization_id
8961: AND current_subinventory_code = p_subinventory

Line 8971: from mtl_serial_numbers_temp msnt, wms_loaded_quantities_v wl

8967: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
8968:
8969: select count(*)
8970: into l_loaded_sys_qty
8971: from mtl_serial_numbers_temp msnt, wms_loaded_quantities_v wl
8972: where ((msnt.transaction_temp_id = wl.transaction_temp_id
8973: and wl.lot_number is null) or
8974: (msnt.transaction_temp_id = wl.serial_transaction_temp_id
8975: and wl.lot_number is not null)

Line 8995: FROM mtl_serial_numbers

8991: END IF;
8992:
8993: SELECT COUNT ( * )
8994: INTO x_system_quantity
8995: FROM mtl_serial_numbers
8996: WHERE lpn_id = p_parent_lpn_id
8997: AND inventory_item_id = p_inventory_item_id
8998: AND current_organization_id = p_organization_id
8999: AND ( NVL ( lot_number, 'XX' ) = NVL ( p_lot_number, 'XX' )

Line 9007: from mtl_serial_numbers msn, wms_loaded_quantities_v wl

9003: AND NVL ( revision, 'XXX' ) = NVL ( p_revision, 'XXX' );
9004:
9005: select distinct wl.quantity
9006: into l_loaded_sys_qty
9007: from mtl_serial_numbers msn, wms_loaded_quantities_v wl
9008: where msn.lpn_id = nvl(wl.content_lpn_id,nvl(wl.lpn_id,-1))
9009: and wl.containerized_flag = 1
9010: and msn.inventory_item_id = wl.inventory_item_id
9011: and msn.current_organization_id = wl.ORGANIZATION_ID