[Home] [Help]
1105: ) return boolean is
1106: l_count number;
1107: begin
1108: select count(*) into l_count
1109: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp
1110: where cii.last_vld_organization_id=mp.organization_id
1111: and msi.organization_id = cii.last_vld_organization_id
1112: and mp.maint_organization_id = p_organization_id
1113: and cii.inventory_item_id=p_inventory_item_id
1358: from EAM UIs, I'm not specifically testing for the type of work order
1359: this row may represent */
1360:
1361: select count(*) into l_count
1362: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp
1363: where
1364: msi.organization_id=cii.last_vld_organization_id and
1365: msi.inventory_item_id=cii.inventory_item_id and
1366: cii.instance_id = p_maintenance_object_id and
1473:
1474: if (p_serial_number is not null) then
1475: select instance_id
1476: into x_maintenance_object_id
1477: from csi_item_instances
1478: where inventory_item_id=p_inventory_item_id
1479: and serial_number=p_serial_number;
1480:
1481: x_maintenance_object_type:=3;
1512:
1513: if (p_maintenance_object_type=3) then
1514: SELECT mp.maint_organization_id, cii.inventory_item_id, cii.serial_number
1515: INTO x_organization_id, x_inventory_item_id, x_serial_number
1516: FROM csi_item_instances cii, mtl_parameters mp
1517: WHERE cii.instance_id=p_maintenance_object_id
1518: AND cii.last_vld_organization_id = mp.organization_id;
1519: elsif (p_maintenance_object_type=2) then
1520: select inventory_item_id
2424:
2425: if P_INSTANCE_ID is null then
2426: l_organization_id := p_organization_id;
2427: select instance_id into l_instance_id
2428: from csi_item_instances
2429: where serial_number = p_serial_number
2430: and inventory_item_id = p_inventory_item_id
2431: ;
2432: select gen_object_id into l_gen_object_id
2919: begin
2920:
2921: select cii.instance_id
2922: into l_instance_id
2923: from csi_item_instances cii
2924: where inventory_item_id = nvl(l_eam_wo_rec.rebuild_item_id,
2925: l_eam_wo_rec.asset_group_id)
2926: and serial_number = nvl(l_eam_wo_rec.rebuild_serial_number,
2927: l_eam_wo_rec.asset_number);
3009: -- Bug 6799616
3010: -- Added exception handling block in case the item instance is not serial
3011: begin
3012: select gen_object_id into l_gen_object_id
3013: from mtl_serial_numbers msn, csi_item_instances cii
3014: where msn.inventory_item_id = cii.inventory_item_id
3015: and msn.serial_number = cii.serial_number
3016: and cii.instance_id = p_maintenance_object_id;
3017: if (l_gen_object_id is not null) then
3115: -- ROUTES CHECK: Route assets cannot be de-activated
3116:
3117: begin
3118: select network_asset_flag into l_network_asset_flag
3119: from csi_item_instances
3120: where instance_id = p_maintenance_object_id;
3121:
3122: exception
3123: when no_data_found then
3141:
3142: begin
3143: select cii.instance_number
3144: into l_parent_asset_number
3145: from csi_item_instances cii, wip_discrete_jobs wdj
3146: where wdj.wip_entity_id = p_parent_job_id
3147: and wdj.organization_id = p_organization_id
3148: and wdj.maintenance_object_type = 3
3149: and wdj.maintenance_object_id = cii.instance_id;
3637:
3638:
3639: select active_start_date,active_end_date
3640: into l_active_start_date,l_active_end_date
3641: from csi_item_instances
3642: where instance_id = p_instance_id;
3643:
3644: if (l_active_start_date > sysdate) then
3645: l_return_value := 'N';
3693:
3694: ELSIF l_maint_object_type = 3 THEN
3695:
3696: select count(1) into l_obj_exists
3697: from csi_item_instances cii,
3698: mtl_serial_numbers msn
3699: where cii.serial_number = msn.serial_number
3700: and cii.inventory_item_id = msn.inventory_item_id
3701: and cii.instance_id = l_maint_object_id