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 13386: FROM mtl_serial_numbers msn,

13382: SELECT msn.serial_number,
13383: msn.inventory_item_id,
13384: msn.current_organization_id,
13385: msi.lot_control_code
13386: FROM mtl_serial_numbers msn,
13387: mtl_system_items msi
13388: WHERE msn.current_status = 1 -- predefined state (for rma'ed serials)
13389: AND msi.inventory_item_id = msn.inventory_item_id
13390: AND msi.organization_id = msn.current_organization_id

Line 15286: mtl_serial_numbers d,

15282: a.instance_usage_code,
15283: a.location_type_code,
15284: a.active_end_date
15285: FROM csi_item_instances a,
15286: mtl_serial_numbers d,
15287: mtl_parameters e
15288: WHERE a.serial_number is not null
15289: AND d.serial_number = a.serial_number
15290: AND d.inventory_item_id <> a.inventory_item_id