ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 E01A2B3C4D5E6F708192A3B4C5D6E701 with q_base as ( select eps.pm_schedule_id, mp.organization_code, mp.organization_id, eps.name schedule_name, xxen_util.meaning(to_char(nvl(msibk_asset.eam_item_type,msibk_group.eam_item_type)),'MTL_EAM_ASSET_TYPE',700) asset_type, case when eps.maintenance_object_type=3 then cii.instance_number end asset_number, nvl(msibk_asset.concatenated_segments,msibk_group.concatenated_segments) asset_group, nvl(msibk_asset.inventory_item_id,msibk_group.inventory_item_id) asset_group_id, msibk_act.concatenated_segments activity, eps.activity_association_id activity_id, epsn.set_name, to_char(null) set_name_description, to_date(null) set_name_end_date, to_char(null) set_name_local_flag, decode(eps.type_code,10,'Rule Based',17,'Day Interval',20,'List Dates',xxen_util.meaning(to_char(eps.type_code),'EAM_PM_TYPE',700)) schedule_type, eps.type_code schedule_type_code, eps.from_effective_date effective_from, eps.to_effective_date effective_to, eps.lead_time lead_time_in_days, ewsv.work_order_status, ewsv.status_id work_order_status_id, xxen_util.meaning(eps.generate_next_work_order,'YES_NO',0) next_wo_only, eps.generate_next_work_order generate_next_wo, eps.day_tolerance, decode(eps.rescheduling_point,1,'Actual Start Date',2,'Actual End Date',3,'Scheduled Start Date',4,'Scheduled End Date',5,'Base Date',6,'Base Meter Reading') use, eps.rescheduling_point, eps.base_date, eps.base_reading, decode(eps.scheduling_method_code,10,'Start Date',20,'End Date',xxen_util.meaning(to_char(eps.scheduling_method_code),'EAM_PM_SCHEDULING_METHOD',700)) suggest_next_service, eps.scheduling_method_code scheduling_method, decode(eps.whichever_first,'Y','First','N','Last') use_date_that_comes, eps.whichever_first, eps.interval_per_cycle intervals_per_cycle, xxen_util.meaning(eps.include_manual,'YES_NO',0) reschedule_manual_work_orders, eps.include_manual, xxen_util.meaning(eps.non_scheduled_flag,'YES_NO',0) run_to_failure, eps.non_scheduled_flag, xxen_util.meaning(eps.default_implement,'YES_NO',0) default_schedule, eps.default_implement, xxen_util.meaning(eps.auto_instantiation_flag,'YES_NO',0) automatic_instantiation, eps.auto_instantiation_flag auto_instantiation from eam_pm_schedulings eps left join csi_item_instances cii on eps.maintenance_object_type=3 and eps.maintenance_object_id=cii.instance_id and sysdate between nvl(cii.active_start_date,sysdate) and nvl(cii.active_end_date,sysdate) left join mtl_eam_asset_activities mea on eps.activity_association_id=mea.activity_association_id left join mtl_system_items_b_kfv msibk_act on mea.asset_activity_id=msibk_act.inventory_item_id and mea.organization_id=msibk_act.organization_id left join mtl_system_items_b_kfv msibk_asset on cii.inventory_item_id=msibk_asset.inventory_item_id and cii.last_vld_organization_id=msibk_asset.organization_id left join mtl_system_items_b_kfv msibk_group on eps.maintenance_object_type=2 and eps.maintenance_object_id=msibk_group.inventory_item_id and mea.organization_id=msibk_group.organization_id join mtl_parameters mp on mp.organization_id=nvl(cii.last_vld_organization_id,mea.organization_id) left join eam_pm_set_names epsn on eps.set_name_id=epsn.set_name_id left join eam_wo_statuses_v ewsv on ewsv.status_id=eps.generate_wo_status where nvl(eps.tmpl_flag,'N')='N' and mp.eam_enabled_flag='Y' and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) select null action_, null status_, null message_, null modified_columns_, row_number() over (order by x.organization_code,x.schedule_name,x.pm_schedule_id,x.row_sort,x.child_sort) upload_row, x.organization_code, x.organization_id, x.schedule_name, x.asset_type, x.asset_number, x.asset_group, x.asset_group_id, x.activity, x.activity_id, x.set_name, x.set_name_description, x.set_name_end_date, x.set_name_local_flag, x.schedule_type, x.schedule_type_code, x.effective_from, x.effective_to, x.lead_time_in_days, x.work_order_status, x.work_order_status_id, x.next_wo_only, x.generate_next_wo, x.day_tolerance, x.use, x.rescheduling_point, x.base_date, x.base_reading, x.suggest_next_service, x.scheduling_method, x.use_date_that_comes, x.whichever_first, x.intervals_per_cycle, x.reschedule_manual_work_orders, x.include_manual, x.run_to_failure, x.non_scheduled_flag, x.default_schedule, x.default_implement, x.automatic_instantiation, x.auto_instantiation, x.act_activity, x.act_activity_id, x.act_interval_multiple, x.act_allow_repeat, x.act_day_tolerance, x.act_next_svc_start, x.act_next_svc_end, x.rule_type_dsp, x.rule_type, x.rule_day_interval, x.rule_meter, x.rule_meter_id, x.rule_runtime_interval, x.rule_last_service_reading, x.rule_effective_reading_from, x.rule_effective_reading_to, x.rule_effective_date_from, x.rule_effective_date_to, x.rule_list_date, x.rule_list_date_desc, x.rule_base_date, x.lsi_meter, x.lsi_meter_id, x.lsi_last_service_reading, x.lsi_prev_service_reading, x.lsi_wip_job, x.lsi_wip_entity_id from ( select qb.*, to_char(null) act_activity, to_number(null) act_activity_id, to_number(null) act_interval_multiple, to_char(null) act_allow_repeat, to_number(null) act_day_tolerance, to_date(null) act_next_svc_start, to_date(null) act_next_svc_end, to_char(null) rule_type_dsp, to_number(null) rule_type, to_number(null) rule_day_interval, to_char(null) rule_meter, to_number(null) rule_meter_id, to_number(null) rule_runtime_interval, to_number(null) rule_last_service_reading, to_number(null) rule_effective_reading_from, to_number(null) rule_effective_reading_to, to_date(null) rule_effective_date_from, to_date(null) rule_effective_date_to, to_date(null) rule_list_date, to_char(null) rule_list_date_desc, to_date(null) rule_base_date, to_char(null) lsi_meter, to_number(null) lsi_meter_id, to_number(null) lsi_last_service_reading, to_number(null) lsi_prev_service_reading, to_char(null) lsi_wip_job, to_number(null) lsi_wip_entity_id, 0 row_sort, 0 child_sort from q_base qb union all select qb.*, msibk_act.concatenated_segments act_activity, epa.activity_association_id act_activity_id, epa.interval_multiple act_interval_multiple, xxen_util.meaning(epa.allow_repeat_in_cycle,'YES_NO',0) act_allow_repeat, epa.day_tolerance act_day_tolerance, epa.next_service_start_date act_next_svc_start, epa.next_service_end_date act_next_svc_end, to_char(null) rule_type_dsp, to_number(null) rule_type, to_number(null) rule_day_interval, to_char(null) rule_meter, to_number(null) rule_meter_id, to_number(null) rule_runtime_interval, to_number(null) rule_last_service_reading, to_number(null) rule_effective_reading_from, to_number(null) rule_effective_reading_to, to_date(null) rule_effective_date_from, to_date(null) rule_effective_date_to, to_date(null) rule_list_date, to_char(null) rule_list_date_desc, to_date(null) rule_base_date, to_char(null) lsi_meter, to_number(null) lsi_meter_id, to_number(null) lsi_last_service_reading, to_number(null) lsi_prev_service_reading, to_char(null) lsi_wip_job, to_number(null) lsi_wip_entity_id, 1 row_sort, epa.activity_association_id child_sort from q_base qb, eam_pm_activities epa, mtl_eam_asset_activities mea, mtl_system_items_b_kfv msibk_act where qb.pm_schedule_id=epa.pm_schedule_id and epa.activity_association_id=mea.activity_association_id and mea.asset_activity_id=msibk_act.inventory_item_id and mea.organization_id=msibk_act.organization_id and :p_update_activities='Y' union all select qb.*, to_char(null) act_activity, to_number(null) act_activity_id, to_number(null) act_interval_multiple, to_char(null) act_allow_repeat, to_number(null) act_day_tolerance, to_date(null) act_next_svc_start, to_date(null) act_next_svc_end, decode(epsr.rule_type,1,'Day Interval',2,'Runtime Meter',3,'List Date') rule_type_dsp, epsr.rule_type, epsr.day_interval rule_day_interval, ccv.name rule_meter, epsr.meter_id rule_meter_id, epsr.runtime_interval rule_runtime_interval, epsr.last_service_reading rule_last_service_reading, epsr.effective_reading_from rule_effective_reading_from, epsr.effective_reading_to rule_effective_reading_to, epsr.effective_date_from rule_effective_date_from, epsr.effective_date_to rule_effective_date_to, epsr.list_date rule_list_date, epsr.list_date_desc rule_list_date_desc, epsr.base_date rule_base_date, to_char(null) lsi_meter, to_number(null) lsi_meter_id, to_number(null) lsi_last_service_reading, to_number(null) lsi_prev_service_reading, to_char(null) lsi_wip_job, to_number(null) lsi_wip_entity_id, 2 row_sort, epsr.rule_id child_sort from q_base qb, eam_pm_scheduling_rules epsr, csi_counters_vl ccv where qb.pm_schedule_id=epsr.pm_schedule_id and epsr.meter_id=ccv.counter_id(+) and :p_update_rules='Y' union all select qb.*, to_char(null) act_activity, to_number(null) act_activity_id, to_number(null) act_interval_multiple, to_char(null) act_allow_repeat, to_number(null) act_day_tolerance, to_date(null) act_next_svc_start, to_date(null) act_next_svc_end, to_char(null) rule_type_dsp, to_number(null) rule_type, to_number(null) rule_day_interval, to_char(null) rule_meter, to_number(null) rule_meter_id, to_number(null) rule_runtime_interval, to_number(null) rule_last_service_reading, to_number(null) rule_effective_reading_from, to_number(null) rule_effective_reading_to, to_date(null) rule_effective_date_from, to_date(null) rule_effective_date_to, to_date(null) rule_list_date, to_char(null) rule_list_date_desc, to_date(null) rule_base_date, ccv.name lsi_meter, epls.meter_id lsi_meter_id, epls.last_service_reading lsi_last_service_reading, epls.prev_service_reading lsi_prev_service_reading, we.wip_entity_name lsi_wip_job, epls.wip_entity_id lsi_wip_entity_id, 3 row_sort, epls.meter_id child_sort from q_base qb, eam_pm_last_service epls, csi_counters_vl ccv, wip_entities we where qb.activity_id=epls.activity_association_id and epls.meter_id=ccv.counter_id(+) and epls.wip_entity_id=we.wip_entity_id(+) and :p_update_last_service='Y' ) x where 1=1 Initial version: EAM Preventive Maintenance Schedule Upload covering header, activity group, scheduling rules (day/runtime/list), and last service readings via EAM_PMDef_Pub and related public APIs. Y U A xxen_eam_upload.upload_pm_schedule xxen_eam_upload.validate_pm_schedule_row( :$column$.organization_code, :$column$.schedule_name, :$column$.set_name, :$column$.asset_type, :$column$.asset_number, :$column$.asset_group, :$column$.activity, :$column$.schedule_type, :$column$.effective_from, :$column$.work_order_status, :$column$.next_wo_only, :$column$.use, :$column$.base_date, :$column$.base_reading, :$column$.suggest_next_service, :$column$.use_date_that_comes, :$column$.intervals_per_cycle, :$column$.act_activity, :$column$.rule_type_dsp, :$column$.rule_day_interval, :$column$.rule_meter, :$column$.rule_runtime_interval, :$column$.rule_list_date, :$column$.lsi_meter ) US EAM PM Schedule Upload EAM Preventive Maintenance Schedule Upload ========================================= Create or update Oracle EAM Preventive Maintenance schedule definitions, including: - PM Schedule header (asset or asset group, activity, schedule name, set name, type, rescheduling point, etc.) - Activity group (for Rule Based schedules: list of activities with interval multiples) - Scheduling rules: Day Interval, Runtime / Meter, and List Date rules - Optional Last Service info (per meter) Row Model ========= Each spreadsheet row can contain PM header values plus any populated child-object columns. The upload infers the object levels from populated column groups: - Header columns identify and define the PM schedule. - Act Activity columns add PM activity-group entries. If no Act Activity is entered for a new Rule Based schedule, the header Activity is used as the first activity entry. - Rule columns add Day Interval, Runtime Meter, or List Date scheduling rules. - LSI columns add optional last-service readings. Rows belonging to the same PM must repeat the same Organization Code + Schedule Name + Asset + Activity and remain contiguous. The header is processed once per PM; repeated rows are used for additional activities, rules, and last-service readings. Upload Modes ============ Create - empty spreadsheet for new PM schedules. Create, Update - downloads existing PM schedules for review/edit and allows adding new ones. IMPORTANT on Update ------------------- In Create, Update mode, use Update Activities / Update Rules / Update Last Service to include those child details in the downloaded template. Update Activities defaults to Yes; the other child sections are optional. PM Set Name =========== - Reference an existing Set Name, or - Enter a new Set Name together with Set Name Description / End Date / Local Flag; the upload will auto-create it via EAM_SetName_PUB. After Upload ============ Schedule and run the "XMLSG - Create Preventive Maintenance Work Order" concurrent program - uploading a PM schedule alone does not generate work orders. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 1=1 x.organization_code=:p_organization LOV custom Y select mp.organization_code value, ood.organization_name description from mtl_parameters mp, org_organization_definitions ood where mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=ood.organization_id and nvl(ood.disable_date,sysdate)>=sysdate and mp.eam_enabled_flag='Y' order by mp.organization_code US Organization 3 30 :p_update_activities LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.Upload_Mode like '%'||xxen_upload.action_update select 'Y' from dual where :$flex$.Upload_Mode like '%'||xxen_upload.action_update US Update Activities 4 40 :p_update_rules LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.Upload_Mode like '%'||xxen_upload.action_update US Update Rules 5 50 :p_update_last_service LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.Upload_Mode like '%'||xxen_upload.action_update US Update Last Service :$flex$.Upload_Mode Upload Mode Update Activities :$flex$.Upload_Mode Upload Mode Update Last Service :$flex$.Upload_Mode Upload Mode Update Rules 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 UPLOAD_ROW Number number Y 6 ORGANIZATION_CODE LOV varchar2 INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code :$flex$.Organization Y 7 ORGANIZATION_ID Number number select mp.organization_id from mtl_parameters mp where mp.eam_enabled_flag='Y' and mp.organization_code=:$column$.organization_code and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) Y Y 8 SCHEDULE_NAME Char varchar2 Y 9 ASSET_TYPE LOV custom varchar2 Y select ml.lookup_code id, ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='MTL_EAM_ASSET_TYPE' and ml.lookup_code in (1,3) and sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and nvl(ml.enabled_flag,'N')='Y' order by ml.lookup_code select ml.meaning from mfg_lookups ml where ml.lookup_type='MTL_EAM_ASSET_TYPE' and ml.lookup_code=1 Y 10 ASSET_NUMBER LOV custom varchar2 Y select cii.instance_number value, cii.instance_description description from csi_item_instances cii, mtl_system_items_vl msi, mtl_parameters mp, mtl_parameters mp_sel where mp_sel.organization_code=:$column$.organization_code and mp_sel.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and msi.inventory_item_id=cii.inventory_item_id and msi.organization_id=cii.last_vld_organization_id and msi.organization_id=mp.organization_id and mp.maint_organization_id=mp_sel.organization_id and nvl(cii.maintainable_flag,'Y')='Y' and nvl(cii.active_start_date,sysdate-1)<=sysdate and nvl(cii.active_end_date,sysdate+1)>=sysdate and ( (:$column$.asset_type='Capital' and msi.eam_item_type=1 and msi.serial_number_control_code<>1) or (:$column$.asset_type='Rebuildable Inventory' and msi.eam_item_type=3 and nvl(cii.network_asset_flag,'N')='N') ) and exists ( select 1 from mtl_eam_asset_activities eaa where eaa.maintenance_object_id=cii.instance_id and eaa.maintenance_object_type=3 and nvl(eaa.start_date_active,sysdate-1)<sysdate and nvl(eaa.end_date_active,sysdate+1)>sysdate ) order by cii.instance_number Y 11 ASSET_GROUP Char varchar2 select msik.concatenated_segments from mtl_parameters mp, csi_item_instances cii, mtl_system_items_kfv msik where mp.organization_code=:$column$.organization_code and mp.organization_id=cii.last_vld_organization_id and cii.instance_number=:$column$.asset_number and cii.last_vld_organization_id=msik.organization_id and cii.inventory_item_id=msik.inventory_item_id and msik.eam_item_type in (1,3) Y 12 ASSET_GROUP_ID Number number select msik.inventory_item_id from mtl_parameters mp, csi_item_instances cii, mtl_system_items_kfv msik where mp.organization_code=:$column$.organization_code and mp.organization_id=cii.last_vld_organization_id and cii.instance_number=:$column$.asset_number and cii.last_vld_organization_id=msik.organization_id and cii.inventory_item_id=msik.inventory_item_id and msik.eam_item_type in (1,3) Y Y 13 ACTIVITY LOV custom varchar2 Y select distinct msibk.concatenated_segments value, msibk.description from mtl_eam_asset_activities mea, mtl_system_items_b_kfv msibk, mtl_parameters mp, csi_item_instances cii where mp.organization_code=:$column$.organization_code and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and cii.instance_number=:$column$.asset_number and cii.last_vld_organization_id=mp.organization_id and mea.maintenance_object_id=cii.instance_id and mea.maintenance_object_type=3 and mea.organization_id=mp.organization_id and mea.asset_activity_id=msibk.inventory_item_id and mea.organization_id=msibk.organization_id and msibk.eam_item_type=2 and nvl(mea.tmpl_flag,'N')='N' and nvl(mea.start_date_active,sysdate-1)<sysdate and nvl(mea.end_date_active,sysdate+1)>sysdate order by msibk.concatenated_segments Y 14 ACTIVITY_ID Number number select mea.activity_association_id from mtl_eam_asset_activities mea, mtl_system_items_b_kfv msibk, mtl_parameters mp, csi_item_instances cii where mp.organization_code=:$column$.organization_code and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and cii.instance_number=:$column$.asset_number and cii.last_vld_organization_id=mp.organization_id and mea.maintenance_object_id=cii.instance_id and mea.maintenance_object_type=3 and mea.organization_id=mp.organization_id and mea.asset_activity_id=msibk.inventory_item_id and mea.organization_id=msibk.organization_id and msibk.concatenated_segments=:$column$.activity and msibk.eam_item_type=2 and nvl(mea.tmpl_flag,'N')='N' and nvl(mea.start_date_active,sysdate-1)<sysdate and nvl(mea.end_date_active,sysdate+1)>sysdate and rownum=1 Y Y 15 SET_NAME LOV custom varchar2 select epsn.set_name value, epsn.description from eam_pm_set_names epsn, mtl_parameters mp where mp.organization_code=:$column$.organization_code and (nvl(epsn.local_flag,'N')='N' or epsn.owning_organization_id=mp.organization_id) and (epsn.end_date is null or epsn.end_date>sysdate) order by epsn.set_name Y 16 SET_NAME_DESCRIPTION Char varchar2 Used only when creating a new PM Set Name. Ignored for existing set names. 17 SET_NAME_END_DATE Date date Used only when creating a new PM Set Name. 18 SET_NAME_LOCAL_FLAG LOV custom varchar2 Y select flv.lookup_code id, flv.meaning value, flv.description from fnd_lookup_values_vl flv where flv.lookup_type='YES_NO' and flv.view_application_id=0 and flv.security_group_id=fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id) and flv.lookup_code in ('Y','N') and flv.enabled_flag='Y' order by flv.meaning Used only when creating a new PM Set Name. Y = set name is specific to the organization; N = global across orgs. 19 SCHEDULE_TYPE LOV custom varchar2 Y select 10 id, 'Rule Based' value, 'Day and meter rules' description from dual union all select 17 id, 'Day Interval' value, 'Day rules only' description from dual union all select 20 id, 'List Dates' value, 'Explicit list dates' description from dual Rule Based Y 20 SCHEDULE_TYPE_CODE Number number select decode(:$column$.schedule_type,'Rule Based',10,'Day Interval',17,'List Dates',20) from dual Y Y 21 EFFECTIVE_FROM Date date 22 EFFECTIVE_TO Date date 23 LEAD_TIME_IN_DAYS Number number 24 WORK_ORDER_STATUS LOV custom varchar2 Y select ewsv.work_order_status value, null description from eam_wo_statuses_v ewsv where ewsv.system_status in (1,3,6,17) order by ewsv.work_order_status select ewsv.work_order_status from eam_wo_statuses_v ewsv where ewsv.system_status=1 and rownum=1 Y 25 WORK_ORDER_STATUS_ID Number number select ewsv.status_id from eam_wo_statuses_v ewsv where ewsv.work_order_status=:$column$.work_order_status Y Y 26 NEXT_WO_ONLY LOV custom varchar2 Y select flv.lookup_code id, flv.meaning value, flv.description from fnd_lookup_values_vl flv where flv.lookup_type='YES_NO' and flv.view_application_id=0 and flv.security_group_id=fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id) and flv.lookup_code in ('Y','N') and flv.enabled_flag='Y' order by flv.meaning select xxen_util.meaning('N','YES_NO',0) from dual Y 27 GENERATE_NEXT_WO Char varchar2 select xxen_util.lookup_code(:$column$.next_wo_only,'YES_NO',0) from dual Y Y 28 DAY_TOLERANCE Number number 29 USE LOV custom varchar2 Y select 1 id, 'Actual Start Date' value, null description from dual union all select 2 id, 'Actual End Date' value, null description from dual union all select 3 id, 'Scheduled Start Date' value, null description from dual union all select 4 id, 'Scheduled End Date' value, null description from dual union all select 5 id, 'Base Date' value, null description from dual union all select 6 id, 'Base Meter Reading' value, null description from dual Actual Start Date Y 30 RESCHEDULING_POINT Number number select decode(:$column$.use,'Actual Start Date',1,'Actual End Date',2,'Scheduled Start Date',3,'Scheduled End Date',4,'Base Date',5,'Base Meter Reading',6) from dual Y Y 31 BASE_DATE Date date Required when Use is "Base Date". 32 BASE_READING Number number Required when Use is "Base Meter Reading". 33 SUGGEST_NEXT_SERVICE LOV custom varchar2 Y select 10 id, 'Start Date' value, null description from dual union all select 20 id, 'End Date' value, null description from dual Start Date Y 34 SCHEDULING_METHOD Number number select decode(:$column$.suggest_next_service,'Start Date',10,'End Date',20) from dual Y Y 35 USE_DATE_THAT_COMES LOV custom varchar2 Y select 'Y' id, 'First' value, null description from dual union all select 'N' id, 'Last' value, null description from dual First Y 36 WHICHEVER_FIRST Char varchar2 select decode(:$column$.use_date_that_comes,'First','Y','Last','N') from dual Y Y 37 INTERVALS_PER_CYCLE Number number Y 38 RESCHEDULE_MANUAL_WORK_ORDERS LOV custom varchar2 Y select flv.lookup_code id, flv.meaning value, flv.description from fnd_lookup_values_vl flv where flv.lookup_type='YES_NO' and flv.view_application_id=0 and flv.security_group_id=fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id) and flv.lookup_code in ('Y','N') and flv.enabled_flag='Y' order by flv.meaning select xxen_util.meaning('N','YES_NO',0) from dual 39 INCLUDE_MANUAL Char varchar2 select xxen_util.lookup_code(:$column$.reschedule_manual_work_orders,'YES_NO',0) from dual Y Y 40 RUN_TO_FAILURE LOV custom varchar2 Y select flv.lookup_code id, flv.meaning value, flv.description from fnd_lookup_values_vl flv where flv.lookup_type='YES_NO' and flv.view_application_id=0 and flv.security_group_id=fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id) and flv.lookup_code in ('Y','N') and flv.enabled_flag='Y' order by flv.meaning select xxen_util.meaning('N','YES_NO',0) from dual 41 NON_SCHEDULED_FLAG Char varchar2 select xxen_util.lookup_code(:$column$.run_to_failure,'YES_NO',0) from dual Y Y 42 DEFAULT_SCHEDULE LOV custom varchar2 Y select flv.lookup_code id, flv.meaning value, flv.description from fnd_lookup_values_vl flv where flv.lookup_type='YES_NO' and flv.view_application_id=0 and flv.security_group_id=fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id) and flv.lookup_code in ('Y','N') and flv.enabled_flag='Y' order by flv.meaning select xxen_util.meaning('Y','YES_NO',0) from dual 43 DEFAULT_IMPLEMENT Char varchar2 select xxen_util.lookup_code(:$column$.default_schedule,'YES_NO',0) from dual Y Y 44 AUTOMATIC_INSTANTIATION LOV custom varchar2 Y select flv.lookup_code id, flv.meaning value, flv.description from fnd_lookup_values_vl flv where flv.lookup_type='YES_NO' and flv.view_application_id=0 and flv.security_group_id=fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id) and flv.lookup_code in ('Y','N') and flv.enabled_flag='Y' order by flv.meaning select xxen_util.meaning('N','YES_NO',0) from dual 45 AUTO_INSTANTIATION Char varchar2 select xxen_util.lookup_code(:$column$.automatic_instantiation,'YES_NO',0) from dual Y Y 46 ACT_ACTIVITY LOV custom varchar2 Y select distinct msibk.concatenated_segments value, msibk.description from mtl_eam_asset_activities mea, mtl_system_items_b_kfv msibk, mtl_parameters mp, csi_item_instances cii where mp.organization_code=:$column$.organization_code and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and cii.instance_number=:$column$.asset_number and cii.last_vld_organization_id=mp.organization_id and mea.maintenance_object_id=cii.instance_id and mea.maintenance_object_type=3 and mea.organization_id=mp.organization_id and mea.asset_activity_id=msibk.inventory_item_id and mea.organization_id=msibk.organization_id and msibk.eam_item_type=2 and nvl(mea.tmpl_flag,'N')='N' and nvl(mea.start_date_active,sysdate-1)<sysdate and nvl(mea.end_date_active,sysdate+1)>sysdate order by msibk.concatenated_segments Activity for Activity row. Must be associated with the same asset/asset group as the header. 47 ACT_ACTIVITY_ID Number number select mea.activity_association_id from mtl_eam_asset_activities mea, mtl_system_items_b_kfv msibk, mtl_parameters mp, csi_item_instances cii where mp.organization_code=:$column$.organization_code and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and cii.instance_number=:$column$.asset_number and cii.last_vld_organization_id=mp.organization_id and mea.maintenance_object_id=cii.instance_id and mea.maintenance_object_type=3 and mea.organization_id=mp.organization_id and mea.asset_activity_id=msibk.inventory_item_id and mea.organization_id=msibk.organization_id and msibk.concatenated_segments=:$column$.act_activity and msibk.eam_item_type=2 and nvl(mea.tmpl_flag,'N')='N' and nvl(mea.start_date_active,sysdate-1)<sysdate and nvl(mea.end_date_active,sysdate+1)>sysdate and rownum=1 Y Y 48 ACT_INTERVAL_MULTIPLE Number number 1 49 ACT_ALLOW_REPEAT LOV custom varchar2 Y select flv.lookup_code id, flv.meaning value, flv.description from fnd_lookup_values_vl flv where flv.lookup_type='YES_NO' and flv.view_application_id=0 and flv.security_group_id=fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id) and flv.lookup_code in ('Y','N') and flv.enabled_flag='Y' order by flv.meaning 50 ACT_DAY_TOLERANCE Number number 51 ACT_NEXT_SVC_START Date date 52 ACT_NEXT_SVC_END Date date 53 RULE_TYPE_DSP LOV custom varchar2 Y select 1 id, 'Day Interval' value, null description from dual union all select 2 id, 'Runtime Meter' value, null description from dual union all select 3 id, 'List Date' value, null description from dual Internal value derived from the populated Date Rules, Meter Rules, or List Dates columns. Leave blank. Y Y 54 RULE_TYPE Number number select case when :$column$.rule_day_interval is not null or :$column$.rule_effective_date_from is not null or :$column$.rule_effective_date_to is not null or :$column$.rule_base_date is not null then 1 when :$column$.rule_meter is not null or :$column$.rule_runtime_interval is not null or :$column$.rule_last_service_reading is not null or :$column$.rule_effective_reading_from is not null or :$column$.rule_effective_reading_to is not null then 2 when :$column$.rule_list_date is not null or :$column$.rule_list_date_desc is not null then 3 end from dual Y Y 55 RULE_DAY_INTERVAL Number number Date Rule: number of days between services. Required for Day Interval schedules and for Rule Based schedules that use date rules. 56 RULE_METER LOV custom varchar2 Y select distinct ccv.name value, ccv.description from csi_counters_vl ccv, csi_counter_associations cca, csi_item_instances cii, mtl_system_items_b_kfv msibk, mtl_parameters mp where ccv.counter_id=cca.counter_id and cca.source_object_code in ('CP','REGULAR') and ccv.used_in_scheduling='Y' and mp.organization_code=:$column$.organization_code and ( (cca.source_object_id=cii.instance_id and cii.instance_number=:$column$.asset_number and cii.last_vld_organization_id=mp.organization_id) or (cca.source_object_id=msibk.inventory_item_id and msibk.concatenated_segments=:$column$.asset_group and msibk.organization_id=mp.organization_id) ) order by ccv.name Meter Rule: meter/counter used for runtime scheduling. Required when using meter rules. 57 RULE_METER_ID Number number select ccv.counter_id from csi_counters_vl ccv where ccv.name=:$column$.rule_meter and rownum=1 Y Y 58 RULE_RUNTIME_INTERVAL Number number Meter Rule: runtime interval between services. Required when using meter rules. 59 RULE_LAST_SERVICE_READING Number number 60 RULE_EFFECTIVE_READING_FROM Number number 61 RULE_EFFECTIVE_READING_TO Number number 62 RULE_EFFECTIVE_DATE_FROM Date date 63 RULE_EFFECTIVE_DATE_TO Date date 64 RULE_LIST_DATE Date date List Dates: service date. Required when Schedule Type is List Dates. 65 RULE_LIST_DATE_DESC Char varchar2 66 RULE_BASE_DATE Date date 67 LSI_METER LOV custom varchar2 Y select distinct ccv.name value, ccv.description from csi_counters_vl ccv, csi_counter_associations cca, csi_item_instances cii, mtl_system_items_b_kfv msibk, mtl_parameters mp where ccv.counter_id=cca.counter_id and cca.source_object_code in ('CP','REGULAR') and ccv.used_in_scheduling='Y' and mp.organization_code=:$column$.organization_code and ( (cca.source_object_id=cii.instance_id and cii.instance_number=:$column$.asset_number and cii.last_vld_organization_id=mp.organization_id) or (cca.source_object_id=msibk.inventory_item_id and msibk.concatenated_segments=:$column$.asset_group and msibk.organization_id=mp.organization_id) ) order by ccv.name 68 LSI_METER_ID Number number select ccv.counter_id from csi_counters_vl ccv where ccv.name=:$column$.lsi_meter and rownum=1 Y Y 69 LSI_LAST_SERVICE_READING Number number 70 LSI_PREV_SERVICE_READING Number number 71 LSI_WIP_JOB Char varchar2 Optional WIP work order number associated with the last service reading. 72 LSI_WIP_ENTITY_ID Number number select we.wip_entity_id from wip_entities we, mtl_parameters mp where we.wip_entity_name=:$column$.lsi_wip_job and we.organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and rownum=1 Y Y Error SQL Order By upload_row Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_row, xu.organization_code, xu.organization_id, xu.schedule_name, xu.asset_type, xu.asset_number, xu.asset_group, xu.asset_group_id, xu.activity, xu.activity_id, xu.set_name, xu.set_name_description, xu.set_name_end_date, xu.set_name_local_flag, xu.schedule_type, xu.schedule_type_code, xu.effective_from, xu.effective_to, xu.lead_time_in_days, xu.work_order_status, xu.work_order_status_id, xu.next_wo_only, xu.generate_next_wo, xu.day_tolerance, xu.use, xu.rescheduling_point, xu.base_date, xu.base_reading, xu.suggest_next_service, xu.scheduling_method, xu.use_date_that_comes, xu.whichever_first, xu.intervals_per_cycle, xu.reschedule_manual_work_orders, xu.include_manual, xu.run_to_failure, xu.non_scheduled_flag, xu.default_schedule, xu.default_implement, xu.automatic_instantiation, xu.auto_instantiation, xu.act_activity, xu.act_activity_id, xu.act_interval_multiple, xu.act_allow_repeat, xu.act_day_tolerance, xu.act_next_svc_start, xu.act_next_svc_end, xu.rule_type_dsp, xu.rule_type, xu.rule_day_interval, xu.rule_meter, xu.rule_meter_id, xu.rule_runtime_interval, xu.rule_last_service_reading, xu.rule_effective_reading_from, xu.rule_effective_reading_to, xu.rule_effective_date_from, xu.rule_effective_date_to, xu.rule_list_date, xu.rule_list_date_desc, xu.rule_base_date, xu.lsi_meter, xu.lsi_meter_id, xu.lsi_last_service_reading, xu.lsi_prev_service_reading, xu.lsi_wip_job, xu.lsi_wip_entity_id from xxen_eam_pm_schedule_up_2458_u xu where xu.status_code_=xxen_upload.status_success LOV query :$column$.asset_number ASSET_NUMBER ACTIVITY LOV query :$column$.organization_code ORGANIZATION_CODE ACTIVITY Default value :$column$.activity ACTIVITY ACTIVITY_ID Default value :$column$.asset_number ASSET_NUMBER ACTIVITY_ID Default value :$column$.organization_code ORGANIZATION_CODE ACTIVITY_ID LOV query :$column$.asset_number ASSET_NUMBER ACT_ACTIVITY LOV query :$column$.organization_code ORGANIZATION_CODE ACT_ACTIVITY Default value :$column$.act_activity ACT_ACTIVITY ACT_ACTIVITY_ID Default value :$column$.asset_number ASSET_NUMBER ACT_ACTIVITY_ID Default value :$column$.organization_code ORGANIZATION_CODE ACT_ACTIVITY_ID Default value :$column$.asset_number ASSET_NUMBER ASSET_GROUP Default value :$column$.organization_code ORGANIZATION_CODE ASSET_GROUP Default value :$column$.asset_number ASSET_NUMBER ASSET_GROUP_ID Default value :$column$.organization_code ORGANIZATION_CODE ASSET_GROUP_ID LOV query :$column$.asset_type ASSET_TYPE ASSET_NUMBER LOV query :$column$.organization_code ORGANIZATION_CODE ASSET_NUMBER Default value :$column$.automatic_instantiation AUTOMATIC_INSTANTIATION AUTO_INSTANTIATION Default value :$column$.default_schedule DEFAULT_SCHEDULE DEFAULT_IMPLEMENT Default value :$column$.next_wo_only NEXT_WO_ONLY GENERATE_NEXT_WO Default value :$column$.reschedule_manual_work_orders RESCHEDULE_MANUAL_WORK_ORDERS INCLUDE_MANUAL LOV query :$column$.asset_group ASSET_GROUP LSI_METER LOV query :$column$.asset_number ASSET_NUMBER LSI_METER LOV query :$column$.organization_code ORGANIZATION_CODE LSI_METER Default value :$column$.lsi_meter LSI_METER LSI_METER_ID Default value :$column$.lsi_wip_job LSI_WIP_JOB LSI_WIP_ENTITY_ID Default value :$column$.organization_code ORGANIZATION_CODE LSI_WIP_ENTITY_ID Default value :$column$.run_to_failure RUN_TO_FAILURE NON_SCHEDULED_FLAG Default value :$flex$.Organization Organization|1=1| ORGANIZATION_CODE Default value :$column$.organization_code ORGANIZATION_CODE ORGANIZATION_ID Default value :$column$.use USE RESCHEDULING_POINT LOV query :$column$.asset_group ASSET_GROUP RULE_METER LOV query :$column$.asset_number ASSET_NUMBER RULE_METER LOV query :$column$.organization_code ORGANIZATION_CODE RULE_METER Default value :$column$.rule_meter RULE_METER RULE_METER_ID Default value :$column$.rule_base_date RULE_BASE_DATE RULE_TYPE Default value :$column$.rule_day_interval RULE_DAY_INTERVAL RULE_TYPE Default value :$column$.rule_effective_date_from RULE_EFFECTIVE_DATE_FROM RULE_TYPE Default value :$column$.rule_effective_date_to RULE_EFFECTIVE_DATE_TO RULE_TYPE Default value :$column$.rule_effective_reading_from RULE_EFFECTIVE_READING_FROM RULE_TYPE Default value :$column$.rule_effective_reading_to RULE_EFFECTIVE_READING_TO RULE_TYPE Default value :$column$.rule_last_service_reading RULE_LAST_SERVICE_READING RULE_TYPE Default value :$column$.rule_list_date RULE_LIST_DATE RULE_TYPE Default value :$column$.rule_list_date_desc RULE_LIST_DATE_DESC RULE_TYPE Default value :$column$.rule_meter RULE_METER RULE_TYPE Default value :$column$.rule_runtime_interval RULE_RUNTIME_INTERVAL RULE_TYPE Default value :$column$.schedule_type SCHEDULE_TYPE SCHEDULE_TYPE_CODE Default value :$column$.suggest_next_service SUGGEST_NEXT_SERVICE SCHEDULING_METHOD LOV query :$column$.organization_code ORGANIZATION_CODE SET_NAME Default value :$column$.use_date_that_comes USE_DATE_THAT_COMES WHICHEVER_FIRST Default value :$column$.work_order_status WORK_ORDER_STATUS WORK_ORDER_STATUS_ID Excel validation :$column$.activity ACTIVITY Excel validation :$column$.act_activity ACT_ACTIVITY Excel validation :$column$.asset_group ASSET_GROUP Excel validation :$column$.asset_number ASSET_NUMBER Excel validation :$column$.asset_type ASSET_TYPE Excel validation :$column$.base_date BASE_DATE Excel validation :$column$.base_reading BASE_READING Excel validation :$column$.effective_from EFFECTIVE_FROM Excel validation :$column$.intervals_per_cycle INTERVALS_PER_CYCLE Excel validation :$column$.lsi_meter LSI_METER Excel validation :$column$.next_wo_only NEXT_WO_ONLY Excel validation :$column$.organization_code ORGANIZATION_CODE Excel validation :$column$.rule_day_interval RULE_DAY_INTERVAL Excel validation :$column$.rule_list_date RULE_LIST_DATE Excel validation :$column$.rule_meter RULE_METER Excel validation :$column$.rule_runtime_interval RULE_RUNTIME_INTERVAL Excel validation :$column$.rule_type_dsp RULE_TYPE_DSP Excel validation :$column$.schedule_name SCHEDULE_NAME Excel validation :$column$.schedule_type SCHEDULE_TYPE Excel validation :$column$.set_name SET_NAME Excel validation :$column$.suggest_next_service SUGGEST_NEXT_SERVICE Excel validation :$column$.use USE Excel validation :$column$.use_date_that_comes USE_DATE_THAT_COMES Excel validation :$column$.work_order_status WORK_ORDER_STATUS