ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F7851A9E05362FB09050512Y select bd.department_code Dept, fnd_flex_xml_publisher_apis.process_kff_combination_1('p_maint_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') Maintained_Item, 'Asset' Item_Type, nvl(ml1.meaning, 'Not Defined') Act_Type, nvl(ml2.meaning, 'Not Defined') Act_Cause, cii.instance_number Asset_number, we.wip_entity_name Work_Order, we.description Description, round(sum(nvl(wepb.actual_mat_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT)) * (:P_ROUND_UNIT) Material, round(sum(nvl(wepb.actual_lab_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT)) * (:P_ROUND_UNIT) Labor, round(sum(nvl(wepb.actual_eqp_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT)) * (:P_ROUND_UNIT) Equip, round(sum(nvl(wepb.actual_mat_cost,0) + nvl(wepb.actual_lab_cost,0) + nvl(wepb.actual_eqp_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT)) * (:P_ROUND_UNIT) Actual_Total, cii.serial_number Asset_Serial_number from mfg_lookups ml1, mfg_lookups ml2, mtl_system_items msi, wip_eam_period_balances wepb, bom_departments bd, wip_discrete_jobs wdj, wip_entities we, mtl_parameters mp, csi_item_instances cii where &P_MAINT_ITEM_WHERE and mp.maint_organization_id = :P_ORG_ID and wdj.organization_id = mp.organization_id and wdj.maintenance_object_id = cii.instance_id and wdj.maintenance_object_type = 3 and msi.inventory_item_id = cii.inventory_item_id and msi.organization_id = mp.organization_id and msi.eam_item_type = 1 and ml1.lookup_type(+) = 'MTL_EAM_ACTIVITY_TYPE' and ml1.lookup_code(+) = wdj.activity_type and ml2.lookup_type(+) = 'MTL_EAM_ACTIVITY_CAUSE' and ml2.lookup_code(+) = wdj.activity_cause and wdj.rebuild_item_id is null &P_MAINT_UNIT_AI_WHERE and wdj.wip_entity_id = we.wip_entity_id and we.entity_type in (6,7) and wdj.status_type in (3,4,5,12) and bd.department_id = wdj.owning_department &P_DEPT_WHERE and wdj.wip_entity_id = wepb.wip_entity_id and wdj.organization_id = wepb.organization_id and :P_ITEM_TYPE in (1,3) &P_PERIOD_WHERE group by bd.department_code, fnd_flex_xml_publisher_apis.process_kff_combination_1('p_maint_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), ml1.meaning, ml2.meaning, cii.instance_number, cii.serial_number, we.description, we.wip_entity_name union select bd.department_code Dept, fnd_flex_xml_publisher_apis.process_kff_combination_1('p_maint_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') Maintained_Item, 'Rebuild Item' Item_Type, nvl(ml1.meaning, 'Not Defined') Act_Type, nvl(ml2.meaning, 'Not Defined') Act_Cause, nvl(cii.instance_number, 'Not Applicable') Asset_Number, we.wip_entity_name Work_Order, we.description Description, round(sum(nvl(wepb.actual_mat_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT)) * (:P_ROUND_UNIT) Material, round(sum(nvl(wepb.actual_lab_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT)) * (:P_ROUND_UNIT) Labor, round(sum(nvl(wepb.actual_eqp_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT)) * (:P_ROUND_UNIT) Equip, round(sum(nvl(wepb.actual_mat_cost,0) + nvl(wepb.actual_lab_cost,0) + nvl(wepb.actual_eqp_cost,0)) * (:P_EXCHANGE_RATE) / (:P_ROUND_UNIT)) * (:P_ROUND_UNIT) Actual_Total, nvl(cii.serial_number, 'Not Applicable') Asset_Serial_Number from mfg_lookups ml1, mfg_lookups ml2, mtl_system_items msi, wip_eam_period_balances wepb, bom_departments bd, wip_discrete_jobs wdj, wip_entities we, mtl_parameters mp, csi_item_instances cii where &P_MAINT_ITEM_WHERE and mp.maint_organization_id = :P_ORG_ID and wdj.organization_id = mp.organization_id and wdj.rebuild_item_id = cii.inventory_item_id (+) and nvl(wdj.rebuild_serial_number,-1) = cii.serial_number (+) and msi.organization_id = mp.organization_id and wdj.rebuild_item_id = msi.inventory_item_id and msi.eam_item_type = 3 and ml1.lookup_type(+) = 'MTL_EAM_ACTIVITY_TYPE' and ml1.lookup_code(+) = wdj.activity_type and ml2.lookup_type(+) = 'MTL_EAM_ACTIVITY_CAUSE' and ml2.lookup_code(+) = wdj.activity_cause &P_MAINT_UNIT_RI_WHERE and wdj.wip_entity_id = we.wip_entity_id and we.entity_type in (6,7) and wdj.status_type in (3,4,5,12) and bd.department_id = wdj.owning_department &P_DEPT_WHERE and wdj.wip_entity_id = wepb.wip_entity_id and wdj.organization_id = wepb.organization_id and :P_ITEM_TYPE in (2,3) &P_PERIOD_WHERE group by bd.department_code, fnd_flex_xml_publisher_apis.process_kff_combination_1('p_maint_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), ml1.meaning, ml2.meaning, cii.serial_number, cii.instance_number, we.description, we.wip_entity_name order by Dept, Maintained_Item, Act_Type, Asset_Number, Work_Order BOM CSTRACTC_XML AR CST تقرير سبب النشاط (تنسيق XML) Imported from BI Publisher Description: تقرير سبب النشاط في EAM Application: شجرة المنتجات Source: تقرير سبب النشاط (تنسيق XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG D CST Aktivitätsursachen Imported from BI Publisher Description: EAM Auswertung "Aktivitätsursachen" Application: Produktionsdaten Source: Aktivitätsursachen (XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG E CST Causa de Actividad Imported from BI Publisher Description: Informe causa de actividad de EAM Application: Bills of Material Source: Causa de Actividad (XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG F CST Etat des motifs d'activité Imported from BI Publisher Description: EAM - Etat des motifs d'activité Application: Bills of Material Source: Etat des motifs d'activité (XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG I CST Rapporto Causa attività Imported from BI Publisher Description: Rapporto Causa attività EAM Application: Bills of Material Source: Rapporto Causa attività (XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG JA CST 活動事由レポート Imported from BI Publisher Description: EAM活動事由レポート Application: Bills of Material Source: 活動事由レポート(XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG KO CST 활동 원인 보고서 Imported from BI Publisher Description: EAM 활동 원인 보고서 Application: Bills of Material Source: 활동 원인 보고서(XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG PTB CST Relatório de Causa da Atividade Imported from BI Publisher Description: EAM - Relatório de Causa da Atividade Application: Bills of Material Source: Relatório de Causa da Atividade (XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG RU CST Отчет об основаниях операций Imported from BI Publisher Description: Отчет об основаниях операций УАП Application: Спецификации Source: Отчет об основаниях операций (XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG S CST Rapport om aktivitetsorsak Imported from BI Publisher Description: EAM: Rapport om aktivitetsorsak Application: Bills of Material Source: Rapport om aktivitetsorsak (XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG TR CST Aktivite Neden Raporu Imported from BI Publisher Description: EAM Aktivite Neden Raporu Application: Ürün Ağacı Source: Aktivite Neden Raporu (XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG US CST Activity Cause Imported from BI Publisher Description: EAM Activity Cause Report Application: Bills of Material Source: Activity Cause Report (XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG ZHS CST 活动原因报表 Imported from BI Publisher Description: EAM 活动原因报表 Application: 物料清单管理系统 Source: 活动原因报表 (XML) Short Name: CSTRACTC_XML DB package: BOM_CSTRACTC_XMLP_PKG BI Publisher &p_dept_where &p_maint_item_where &p_maint_unit_ai_where &p_maint_unit_ri_where &p_period_where :p_conc_request_id :p_currency_code :p_currency_dsp :p_dept_from :p_dept_to :p_dept_where :p_exchange_rate :p_exchange_rate_char :p_item_type :p_maint_item :p_maint_item_from :p_maint_item_to :p_maint_item_where :p_maint_unit_ai_where :p_maint_unit_from :p_maint_unit_ri_where :p_maint_unit_to :p_org_id :p_org_name :p_period_date_from :p_period_date_to :p_period_id_from :p_period_id_to :p_period_where :p_round_unit :p_rpt_type 1 -50 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف التنظيم معرف التنظيم D Organisationskennung Organisationskennung E Id Organización Id Organización F ID organisation ID organisation I Id organizzazione Id dell'organizzazione JA 組織ID 組織ID KO 조직 ID 조직 ID PTB ID da Organização ID da Organização RU Идентификатор организации Идентификатор организации S Organisations-id Organisations-id TR Organizasyon No Organizasyon No US Organization ID Organization ID ZHS 组织标识 组织标识 2 -40 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') Y AR CST_SRS_INVERSE_RATE عرض السعر العكسي D CST_SRS_INVERSE_RATE Gegenkurs anzeigen E CST_SRS_INVERSE_RATE Visualizar Tipo de Cambio Inverso F CST_SRS_INVERSE_RATE Afficher taux inverse I CST_SRS_INVERSE_RATE Visualizza tasso inverso JA CST_SRS_INVERSE_RATE 逆数レートの表示 KO CST_SRS_INVERSE_RATE 역산율 표시 PTB CST_SRS_INVERSE_RATE Exibir Taxa de Inversão RU CST_SRS_INVERSE_RATE Вывод обратного курса S CST_SRS_INVERSE_RATE Visa inverterad kurs TR CST_SRS_INVERSE_RATE Ters Kuru Görüntüle US CST_SRS_INVERSE_RATE Display Inverse Rate ZHS CST_SRS_INVERSE_RATE 显示逆汇率 3 -30 :p_rate_type Number 2 Y AR CST_SRS_RATE_TYPE نوع سعر الصرف D CST_SRS_RATE_TYPE Wechselkursart E CST_SRS_RATE_TYPE Clase de Tipo de Cambio F CST_SRS_RATE_TYPE Type de taux de change I CST_SRS_RATE_TYPE Tipo di tasso di cambio JA CST_SRS_RATE_TYPE 換算レート・タイプ KO CST_SRS_RATE_TYPE 환율 유형 PTB CST_SRS_RATE_TYPE Tipo de Taxa de Câmbio RU CST_SRS_RATE_TYPE Тип обменного курса S CST_SRS_RATE_TYPE Växelkurstyp TR CST_SRS_RATE_TYPE Döviz Kuru Tipi US CST_SRS_RATE_TYPE Exchange Rate Type ZHS CST_SRS_RATE_TYPE 汇率类型 4 -20 :p_dept_dummy Number select 1 from dual where :$flex$.report_type = 1 AR CST_SRS_DEPT_DUMMY القسم الافتراضي D CST_SRS_DEPT_DUMMY Abteilungs-Dummy E CST_SRS_DEPT_DUMMY Departamento Ficticio F CST_SRS_DEPT_DUMMY Section fictive I CST_SRS_DEPT_DUMMY Reparto fittizio JA CST_SRS_DEPT_DUMMY 部門ダミー KO CST_SRS_DEPT_DUMMY 부서 Dummy PTB CST_SRS_DEPT_DUMMY Dept. Fictício RU CST_SRS_DEPT_DUMMY Фиктивный отдел S CST_SRS_DEPT_DUMMY Exempel på avdelning TR CST_SRS_DEPT_DUMMY Sözde Departman US CST_SRS_DEPT_DUMMY Dept Dummy ZHS CST_SRS_DEPT_DUMMY 虚拟部门 5 10 :p_rpt_type LOV Oracle CST_EAM_SRS_ACTC_REP_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_EAM_ACTC_REP_TYPE' order by lookup_code select meaning from mfg_lookups where lookup_type = 'CST_EAM_ACTC_REP_TYPE' and lookup_code = 1 Y AR نوع التقرير نوع التقرير D Auswertungsart Art der Auswertung E Tipo de Informe Tipo de Informe F Type d'état Type d'état I Tipo di rapporto Tipo di rapporto JA レポート・タイプ レポートのタイプ KO 보고서 유형 보고서 유형 PTB Tipo de Relatório Tipo de Relatório RU Тип отчета Тип отчета S Rapporttyp Rapporttyp TR Rapor Tipi Rapor Tipi US Report Type Type of Report ZHS 报表类型 报表的类型 6 20 :p_period_id_from LOV Oracle CST_SRS_PERIOD_FROM Y select acct_period_id id, period_name value, null description from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by period_start_date Y AR الفترة من من الفترة D Von Periode Von Periode E De Período De Período F Période - De Période - De I Periodo - Da Periodo - Da JA 期間:自 期間:自 KO 기간: 부터 기간: 부터 PTB Período - De Período - De RU Период с Период с S Från period Från period TR Dönem Başlangıcı İlk Dönem US Period From From Period ZHS 起始期间 自期间 7 30 :p_period_id_to LOV Oracle CST_SRS_PERIOD_TO Y select acct_period_id id, period_name value, null description from org_acct_periods where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and acct_period_id>=:$flex$.cst_srs_period_from order by period_start_date Y AR الفترة إلى إلى الفترة D Bis Periode Bis Periode E A Período A Período F Période - A Période - A I Periodo - A Periodo - A JA 期間:至 期間:至 KO 기간: 까지 기간: 까지 PTB Período - Até Período - Até RU Период по Период по S Till period Till period TR Son Dönem Son Dönem US Period To To Period ZHS 终止期间 至期间 8 40 :p_currency_code LOV Oracle CST_SRS_CURRENCY_CODE Y select currency_code id, currency_code value, description description from fnd_currencies_vl where trunc(nvl(start_date_active,sysdate-1))<sysdate and trunc(nvl(end_date_active,sysdate+1))>sysdate order by value,description select currency_code from gl_sets_of_books sob, org_organization_definitions ood where ood.organization_id = fnd_profile.value('mfg_organization_id') and sob.set_of_books_id = ood.set_of_books_id Y AR العملة رمز العملة D Währung Währungsschlüssel E Divisa Código de divisa F Devise Code devise I Divisa Codice divisa JA 通貨 通貨コード KO 통화 통화 코드 PTB Moeda Código da moeda RU Валюта Код валюты S Valuta Valutakod TR Para Birimi Para Birimi kodu US Currency Currency code ZHS 币种 币种代码 9 50 :p_exchange_rate_char LOV Oracle CST_SRS_EXCHANGE_RATE_C Y select actual_rate id, display_rate value, period description from cst_gl_translation_view where org_id=fnd_profile.value('MFG_ORGANIZATION_ID') and code=:$flex$.cst_srs_currency_code and inverse=:$flex$.cst_srs_inverse_rate and rate_type=:$flex$.cst_srs_rate_type order by period_year desc,period_num desc Y AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs E Tipo de Cambio Tipo de Cambio F Taux de change Taux de change I Tasso di cambio Tasso di cambio JA 換算レート 換算レート KO 환율 환율 PTB Taxa de Câmbio Taxa de Câmbio RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz Kuru US Exchange Rate Exchange Rate ZHS 汇率 汇率 10 60 :p_dept_from LOV Oracle CST_SRS_ACTC_DEPT Y select department_code id, department_code value, null description from bom_departments bd where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and :$flex$.cst_srs_dept_dummy=1 order by department_code AR القسم من من القسم D Von Abteilung Von Abteilung E De Departamento De Departamento F Section d'origine Section d'origine I Reparto - Da Reparto - Da JA 部門:自 部門:自 KO 부서 From 부서 From PTB Departamento - De Departamento - De RU Отдел с Отдел-отправитель S Från avdelning Från avdelning TR İlk Departman İlk Departman US Department From From Department ZHS 部门自 自部门 11 70 :p_dept_to LOV Oracle CST_SRS_ACTC_DEPT Y select department_code id, department_code value, null description from bom_departments bd where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and :$flex$.cst_srs_dept_dummy=1 order by department_code AR القسم إلى إلى القسم D Bis Abteilung Bis Abteilung E A Departamento A Departamento F Section de destination Section de destination I Reparto - A Reparto - A JA 部門:至 部門:至 KO 부서 To 부서 To PTB Departamento - Até Departamento - Até RU Отдел по Отдел-получатель S Till avdelning Till avdelning TR Son Departman Son Departman US Department To To Department ZHS 部门至 至部门 12 80 :p_item_type LOV Oracle CST_EAM_SRS_ACTC_ITEM_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_EAM_ACTC_ITEM_TYPE' order by lookup_code select meaning from mfg_lookups where lookup_type = 'CST_EAM_ACTC_ITEM_TYPE' and lookup_code = 3 Y AR نوع الصنف نوع الصنف D Artikelart Artikelart E Tipo de Artículo Tipo de Artículo F Type d'article Type d'article I Tipo di articolo Tipo di articolo JA 品目タイプ 品目タイプ KO 품목 유형 품목 유형 PTB Tipo de Item Tipo de Item RU Тип позиции Тип позиции S Artikeltyp Artikeltyp TR Kalem Tipi Kalem Tipi US Item Type Item Type ZHS 物料类型 物料类型 13 90 :p_maint_item_from Char AR مجموعة الأصول من من مجموعة الأصول D Von Anlagengruppe Von Anlagengruppe E De Grupo de Activos De grupo de activos F Groupe d'équipements - De Groupe d'équipements - De I Gruppo attività - Da Gruppo di attività - Da JA 資産グループ:自 資産グループ:自 KO 시작 자산 그룹 시작 자산 그룹 PTB Grupo de Ativos - De Grupo de Ativos - De RU Начальная группа активов Начальная группа активов S Från anläggningsgrupp Från anläggningsgrupp TR Varlık Grubu, İlk İlk Varlık Grubu US Asset Group From From Asset Group ZHS 资产组自 起始资产组 14 100 :p_maint_item_to Char AR مجموعة الأصول إلى إلى مجموعة الأصول D Bis Anlagengruppe Bis Anlagengruppe E A Grupo de Activos A grupo de activos F Groupe d'équipements - A Groupe d'équipements - A I Gruppo attività - A Gruppo di attività - A JA 資産グループ:至 資産グループ:至 KO 종료 자산 그룹 종료 자산 그룹 PTB Grupo de Ativos - Até Grupo de Ativos - Até RU Конечная группа активов Конечная группа активов S Till anläggningsgrupp Till anläggningsgrupp TR Varlık Grubu, Son Son Varlık Grubu US Asset Group To To Asset Group ZHS 资产组至 终止资产组 15 110 :p_maint_unit_from LOV Oracle CST_SRS_ASSET_NUMBER Y select cii.serial_number id, cii.instance_number value, null description from csi_item_instances cii,mtl_parameters mp where cii.last_vld_organization_id=mp.organization_id and mp.maint_organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and cii.maintainable_flag='Y' and nvl(cii.active_start_date,sysdate-1)<=sysdate and nvl(cii.active_end_date,sysdate+1)>=sysdate and cii.inventory_item_id in ( select inventory_item_id from mtl_system_items msi where msi.organization_id=mp.organization_id and msi.eam_item_type in (1,3) ) order by value,description AR رقم الأصل من من رقم الأصل D Von Anlagennummer Von Anlagennummer E De Número de Activo De número de activo F Numéro d'équipement - De Numéro d'équipement - De I Numero attività - Da Numero di attività - Da JA 資産番号:自 資産番号:自 KO 시작 자산 번호 시작 자산 번호 PTB Número de Ativo - De Número do Ativo - De RU Номер актива с Номер актива с S Från anläggningsnummer Från anläggningsnr TR Varlık Numarası, İlk İlk Varlık Numarası US Asset Number From From Asset Number ZHS 资产编号自 起始资产编号 16 120 :p_maint_unit_to LOV Oracle CST_SRS_ASSET_NUMBER Y select cii.serial_number id, cii.instance_number value, null description from csi_item_instances cii,mtl_parameters mp where cii.last_vld_organization_id=mp.organization_id and mp.maint_organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and cii.maintainable_flag='Y' and nvl(cii.active_start_date,sysdate-1)<=sysdate and nvl(cii.active_end_date,sysdate+1)>=sysdate and cii.inventory_item_id in ( select inventory_item_id from mtl_system_items msi where msi.organization_id=mp.organization_id and msi.eam_item_type in (1,3) ) order by value,description AR رقم الأصل إلى إلى رقم الأصل D Bis Anlagennummer Bis Anlagennummer E A Número de Activo A Número de Activo F Numéro d'équipement - A Numéro d'équipement - A I Numero attività - A Numero di attività - A JA 資産番号:至 資産番号:至 KO 종료 자산 번호 종료 자산 번호 PTB Número de Ativo - Até Número do Ativo - Até RU Номер актива по Номер актива по S Till anläggningsnummer Till anläggningsnummer TR Varlık Numarası, Son Son Varlık Numarası US Asset Number To To Asset Number ZHS 资产编号至 终止资产编号