APPS.CSI_DIAGNOSTICS_PKG dependencies on MTL_SERIAL_NUMBERS

Line 3702: FROM mtl_serial_numbers msn

3698: CURSOR all_srl_cur IS
3699: SELECT msn.serial_number serial_number,
3700: msn.inventory_item_id item_id,
3701: msn.current_organization_id organization_id
3702: FROM mtl_serial_numbers msn
3703: WHERE exists (
3704: SELECT '1'
3705: FROM mtl_system_items msi,
3706: mtl_parameters mp

Line 8851: mtl_serial_numbers msn

8847: msi.primary_uom_code uom_code,
8848: msi.serial_number_control_code serial_code,
8849: msi.lot_control_code lot_code
8850: FROM mtl_system_items msi,
8851: mtl_serial_numbers msn
8852: WHERE msi.inventory_item_id = msn.inventory_item_id
8853: AND msi.organization_id = msn.current_organization_id
8854: AND msi.serial_number_control_code in (2,5)
8855: AND msn.current_status = 3

Line 10055: from MTL_SERIAL_NUMBERS

10051: IF revision_mig(i) is null AND serial_number_mig(i) is not null THEN
10052: Begin
10053: select revision
10054: into revision_mig(i)
10055: from MTL_SERIAL_NUMBERS
10056: where inventory_item_id = item_id_mig(i)
10057: and serial_number = serial_number_mig(i);
10058: Exception
10059: when no_data_found then

Line 10096: and not exists (select 'X' from mtl_serial_numbers msn

10092: and cii.serial_number is not null
10093: and cii.lot_number is not null
10094: and cii.migrated_flag = 'Y'
10095: and cii.creation_date = cii.last_update_date
10096: and not exists (select 'X' from mtl_serial_numbers msn
10097: where msn.inventory_item_id = cii.inventory_item_id
10098: and msn.serial_number = cii.serial_number
10099: and msn.lot_number = cii.lot_number);
10100: --

Line 13391: FROM mtl_serial_numbers msn,

13387: SELECT msn.serial_number,
13388: msn.inventory_item_id,
13389: msn.current_organization_id,
13390: msi.lot_control_code
13391: FROM mtl_serial_numbers msn,
13392: mtl_system_items msi
13393: WHERE msn.current_status = 1 -- predefined state (for rma'ed serials)
13394: AND msi.inventory_item_id = msn.inventory_item_id
13395: AND msi.organization_id = msn.current_organization_id

Line 15297: mtl_serial_numbers d,

15293: a.instance_usage_code,
15294: a.location_type_code,
15295: a.active_end_date
15296: FROM csi_item_instances a,
15297: mtl_serial_numbers d,
15298: mtl_parameters e
15299: WHERE a.serial_number is not null
15300: AND d.serial_number = a.serial_number
15301: AND d.inventory_item_id <> a.inventory_item_id