[Home] [Help]
1289: if(nvl(p_asset_number,l_asset_number_wl) is not null) then
1290: select nvl(cii.active_start_date, sysdate-1),
1291: nvl(cii.active_start_date, sysdate-1),msikfv.eam_item_type
1292: into l_start_date, l_end_date, l_eam_item_type
1293: from csi_item_instances cii, mtl_system_items_b_kfv msikfv, mtl_parameters mp
1294: where cii.inventory_item_id =msikfv.inventory_item_id
1295: and cii.last_vld_organization_id =msikfv.organization_id --Bug 2157979
1296: and cii.last_vld_organization_id = mp.organization_id
1297: and mp.maint_organization_id = p_organization_id
1325: if (nvl(p_asset_number,l_asset_number_wl) is not null) then
1326: select cii.inventory_item_id , eomd.ACCOUNTING_CLASS_CODE,
1327: cii.instance_id, msikfv.eam_item_type , eomd.area_id
1328: into l_asset_group_id, l_asset_class, l_maintenance_object_id, l_eam_item_type , l_eam_location_id
1329: from csi_item_instances cii, mtl_system_items_b_kfv msikfv,
1330: mtl_parameters mp, eam_org_maint_defaults eomd
1331: where cii.inventory_item_id =msikfv.inventory_item_id
1332: and cii.last_vld_organization_id =msikfv.organization_id --Bug 2157979
1333: and cii.last_vld_organization_id = mp.organization_id
1345: begin
1346: -- Changes by amondal for New Work Order API
1347: select msikfv.inventory_item_id, msikfv.eam_item_type, msikfv.serial_number_control_code
1348: into l_asset_group_id, l_eam_item_type, l_serial_number_control
1349: from mtl_system_items_b_kfv msikfv, mtl_parameters mp
1350: where msikfv.organization_id=mp.organization_id
1351: and mp.maint_organization_id = p_organization_id
1352: and msikfv.CONCATENATED_SEGMENTS = p_asset_group
1353: and rownum = 1;
1461: if p_asset_activity is not null then
1462: -- See whether it is a valid asset activity
1463:
1464: select inventory_item_id into l_asset_activity_id
1465: from mtl_system_items_b_kfv
1466: where concatenated_segments = p_asset_activity
1467: and eam_item_type = 2
1468: and organization_id = p_organization_id;
1469: end if;