[Home] [Help]
1106: ) return boolean is
1107: l_count number;
1108: begin
1109: select count(*) into l_count
1110: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp
1111: where cii.last_vld_organization_id=mp.organization_id
1112: and msi.organization_id = cii.last_vld_organization_id
1113: and mp.maint_organization_id = p_organization_id
1114: and cii.inventory_item_id=p_inventory_item_id
1359: from EAM UIs, I'm not specifically testing for the type of work order
1360: this row may represent */
1361:
1362: select count(*) into l_count
1363: from csi_item_instances cii, mtl_system_items msi, mtl_parameters mp
1364: where
1365: msi.organization_id=cii.last_vld_organization_id and
1366: msi.inventory_item_id=cii.inventory_item_id and
1367: cii.instance_id = p_maintenance_object_id and
1474:
1475: if (p_serial_number is not null) then
1476: select instance_id
1477: into x_maintenance_object_id
1478: from csi_item_instances
1479: where inventory_item_id=p_inventory_item_id
1480: and serial_number=p_serial_number;
1481:
1482: x_maintenance_object_type:=3;
1513:
1514: if (p_maintenance_object_type=3) then
1515: SELECT mp.maint_organization_id, cii.inventory_item_id, cii.serial_number
1516: INTO x_organization_id, x_inventory_item_id, x_serial_number
1517: FROM csi_item_instances cii, mtl_parameters mp
1518: WHERE cii.instance_id=p_maintenance_object_id
1519: AND cii.last_vld_organization_id = mp.organization_id;
1520: elsif (p_maintenance_object_type=2) then
1521: select inventory_item_id
2425:
2426: if P_INSTANCE_ID is null then
2427: l_organization_id := p_organization_id;
2428: select instance_id into l_instance_id
2429: from csi_item_instances
2430: where serial_number = p_serial_number
2431: and inventory_item_id = p_inventory_item_id
2432: ;
2433: select gen_object_id into l_gen_object_id
3038: begin
3039:
3040: select cii.instance_id
3041: into l_instance_id
3042: from csi_item_instances cii
3043: where inventory_item_id = nvl(l_eam_wo_rec.rebuild_item_id,
3044: l_eam_wo_rec.asset_group_id)
3045: and serial_number = nvl(l_eam_wo_rec.rebuild_serial_number,
3046: l_eam_wo_rec.asset_number);
3129: -- Bug 6799616
3130: -- Added exception handling block in case the item instance is not serial
3131: begin
3132: select gen_object_id into l_gen_object_id
3133: from mtl_serial_numbers msn, csi_item_instances cii
3134: where msn.inventory_item_id = cii.inventory_item_id
3135: and msn.serial_number = cii.serial_number
3136: and cii.instance_id = p_maintenance_object_id;
3137: if (l_gen_object_id is not null) then
3152: into
3153: l_serial_number_control_code
3154: FROM
3155: mtl_system_items_b msib,
3156: csi_item_instances cii
3157: WHERE
3158: cii.inventory_item_id=msib.inventory_item_id
3159: AND cii.last_vld_organization_id=msib.organization_id
3160: AND cii.instance_id=p_maintenance_object_id;
3259: -- ROUTES CHECK: Route assets cannot be de-activated
3260:
3261: begin
3262: select network_asset_flag into l_network_asset_flag
3263: from csi_item_instances
3264: where instance_id = p_maintenance_object_id;
3265:
3266: exception
3267: when no_data_found then
3285:
3286: begin
3287: select cii.instance_number
3288: into l_parent_asset_number
3289: from csi_item_instances cii, wip_discrete_jobs wdj
3290: where wdj.wip_entity_id = p_parent_job_id
3291: and wdj.organization_id = p_organization_id
3292: and wdj.maintenance_object_type = 3
3293: and wdj.maintenance_object_id = cii.instance_id;
3781:
3782:
3783: select active_start_date,active_end_date
3784: into l_active_start_date,l_active_end_date
3785: from csi_item_instances
3786: where instance_id = p_instance_id;
3787:
3788: if (l_active_start_date > sysdate) then
3789: l_return_value := 'N';
3837:
3838: ELSIF l_maint_object_type = 3 THEN
3839:
3840: select count(1) into l_obj_exists
3841: from csi_item_instances cii,
3842: mtl_serial_numbers msn
3843: where cii.serial_number = msn.serial_number
3844: and cii.inventory_item_id = msn.inventory_item_id
3845: and cii.instance_id = l_maint_object_id