ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FA351A9E05362FB09050512Y select msi1.inventory_item_id assembly_id2, &P_ASSY_FLEX C_ASSY_FLEX2, date1 week_start_date2, char1 line_code2, char2 schedule_group2, number1 day1_plan2, number2 day2_plan2, number3 day3_plan2, number4 day4_plan2, number5 day5_plan2, number6 day6_plan2, number7 day7_plan2, number8 day1_actual2, number9 day2_actual2, number10 day3_actual2, number11 day4_actual2, number12 day5_actual2, number13 day6_actual2, number14 day7_actual2, number1-number8 day1_var2, number2-number9 day2_var2, number3-number10 day3_var2, number4-number11 day4_var2, number5-number12 day5_var2, number6-number13 day6_var2, number7-number14 day7_var2, /*FLM_FLMRFLIN_XMLP_PKG.day1_var_line2formula(:day1_plan_line2, :day1_actual_line2) day1_var_line2, FLM_FLMRFLIN_XMLP_PKG.day1_lin_line2formula(:day1_plan_line2, :day1_actual_line2) day1_lin_line2, FLM_FLMRFLIN_XMLP_PKG.day2_var_line2formula(:day2_plan_line2, :day2_actual_line2) day2_var_line2, FLM_FLMRFLIN_XMLP_PKG.day2_lin_line2formula(:day2_plan_line2, :day2_actual_line2) day2_lin_line2, FLM_FLMRFLIN_XMLP_PKG.day3_var_line2formula(:day3_plan_line2, :day3_actual_line2) day3_var_line2, FLM_FLMRFLIN_XMLP_PKG.day3_lin_line2formula(:day3_plan_line2, :day3_actual_line2) day3_lin_line2, FLM_FLMRFLIN_XMLP_PKG.day4_var_line2formula(:day4_plan_line2, :day4_actual_line2) day4_var_line2, FLM_FLMRFLIN_XMLP_PKG.day4_lin_line2formula(:day4_plan_line2, :day4_actual_line2) day4_lin_line2, FLM_FLMRFLIN_XMLP_PKG.day5_var_line2formula(:day5_plan_line2, :day5_actual_line2) day5_var_line2, FLM_FLMRFLIN_XMLP_PKG.day5_lin_line2formula(:day5_plan_line2, :day5_actual_line2) day5_lin_line2, FLM_FLMRFLIN_XMLP_PKG.day6_var_line2formula(:day6_plan_line2, :day6_actual_line2) day6_var_line2, FLM_FLMRFLIN_XMLP_PKG.day6_lin_line2formula(:day6_plan_line2, :day6_actual_line2) day6_lin_line2, FLM_FLMRFLIN_XMLP_PKG.day7_var_line2formula(:day7_plan_line2, :day7_actual_line2) day7_var_line2, FLM_FLMRFLIN_XMLP_PKG.day7_lin_line2formula(:day7_plan_line2, :day7_actual_line2) day7_lin_line2, FLM_FLMRFLIN_XMLP_PKG.weekly_plan_line2formula(:day1_plan_line2, :day2_plan_line2, :day3_plan_line2, :day4_plan_line2, :day5_plan_line2, :day6_plan_line2, :day7_plan_line2) weekly_plan_line2, FLM_FLMRFLIN_XMLP_PKG.weekly_actual_line2formula(:day1_actual_line2, :day2_actual_line2, :day3_actual_line2, :day4_actual_line2, :day5_actual_line2, :day6_actual_line2, :day7_actual_line2) weekly_actual_line2, FLM_FLMRFLIN_XMLP_PKG.weekly_var_line2formula(:weekly_plan_line2, :weekly_actual_line2) weekly_var_line2, FLM_FLMRFLIN_XMLP_PKG.weekly_lin_line2formula(:weekly_plan_line2, :weekly_actual_line2) weekly_lin_line2, FLM_FLMRFLIN_XMLP_PKG.day1_var_group2formula(:day1_plan_group2, :day1_actual_group2) day1_var_group2, FLM_FLMRFLIN_XMLP_PKG.day1_lin_group2formula(:day1_plan_group2, :day1_actual_group2) day1_lin_group2, FLM_FLMRFLIN_XMLP_PKG.day2_var_group2formula(:day2_plan_group2, :day2_actual_group2) day2_var_group2, FLM_FLMRFLIN_XMLP_PKG.day2_lin_group2formula(:day2_plan_group2, :day2_actual_group2) day2_lin_group2, FLM_FLMRFLIN_XMLP_PKG.day3_var_group2formula(:day3_plan_group2, :day3_actual_group2) day3_var_group2, FLM_FLMRFLIN_XMLP_PKG.day3_lin_group2formula(:day3_plan_group2, :day3_actual_group2) day3_lin_group2, FLM_FLMRFLIN_XMLP_PKG.day4_var_group2formula(:day4_plan_group2, :day4_actual_group2) day4_var_group2, FLM_FLMRFLIN_XMLP_PKG.day4_lin_group2formula(:day4_plan_group2, :day4_actual_group2) day4_lin_group2, FLM_FLMRFLIN_XMLP_PKG.day5_var_group2formula(:day5_plan_group2, :day5_actual_group2) day5_var_group2, FLM_FLMRFLIN_XMLP_PKG.day5_lin_group2formula(:day5_plan_group2, :day5_actual_group2) day5_lin_group2, FLM_FLMRFLIN_XMLP_PKG.day6_var_group2formula(:day6_plan_group2, :day6_actual_group2) day6_var_group2, FLM_FLMRFLIN_XMLP_PKG.day6_lin_group2formula(:day6_plan_group2, :day6_actual_group2) day6_lin_group2, FLM_FLMRFLIN_XMLP_PKG.day7_var_group2formula(:day7_plan_group2, :day7_actual_group2) day7_var_group2, FLM_FLMRFLIN_XMLP_PKG.day7_lin_group2formula(:day7_plan_group2, :day7_actual_group2) day7_lin_group2, FLM_FLMRFLIN_XMLP_PKG.weekly_plan_group2formula(:day1_plan_group2, :day2_plan_group2, :day3_plan_group2, :day4_plan_group2, :day5_plan_group2, :day6_plan_group2, :day7_plan_group2) weekly_plan_group2, FLM_FLMRFLIN_XMLP_PKG.weekly_actual_group2formula(:day1_actual_group2, :day2_actual_group2, :day3_actual_group2, :day4_actual_group2, :day5_actual_group2, :day6_actual_group2, :day7_actual_group2) weekly_actual_group2, FLM_FLMRFLIN_XMLP_PKG.weekly_var_group2formula(:weekly_plan_group2, :weekly_actual_group2) weekly_var_group2, FLM_FLMRFLIN_XMLP_PKG.weekly_lin_group2formula(:weekly_plan_group2, :weekly_actual_group2) weekly_lin_group2, FLM_FLMRFLIN_XMLP_PKG.day1_var_week2formula(:day1_plan_week2, :day1_actual_week2) day1_var_week2, FLM_FLMRFLIN_XMLP_PKG.day1_lin_week2formula(:day1_plan_week2, :day1_actual_week2) day1_lin_week2, FLM_FLMRFLIN_XMLP_PKG.day2_var_week2formula(:day2_plan_week2, :day2_actual_week2) day2_var_week2, FLM_FLMRFLIN_XMLP_PKG.day2_lin_week2formula(:day2_plan_week2, :day2_actual_week2) day2_lin_week2, FLM_FLMRFLIN_XMLP_PKG.day3_var_week2formula(:day3_plan_week2, :day3_actual_week2) day3_var_week2, FLM_FLMRFLIN_XMLP_PKG.day3_lin_week2formula(:day3_plan_week2, :day3_actual_week2) day3_lin_week2, FLM_FLMRFLIN_XMLP_PKG.day4_var_week2formula(:day4_plan_week2, :day4_actual_week2) day4_var_week2, FLM_FLMRFLIN_XMLP_PKG.day4_lin_week2formula(:day4_plan_week2, :day4_actual_week2) day4_lin_week2, FLM_FLMRFLIN_XMLP_PKG.day5_var_week2formula(:day5_plan_week2, :day5_actual_week2) day5_var_week2, FLM_FLMRFLIN_XMLP_PKG.day5_lin_week2formula(:day5_plan_week2, :day5_actual_week2) day5_lin_week2, FLM_FLMRFLIN_XMLP_PKG.day6_var_week2formula(:day6_plan_week2, :day6_actual_week2) day6_var_week2, FLM_FLMRFLIN_XMLP_PKG.day6_lin_week2formula(:day6_plan_week2, :day6_actual_week2) day6_lin_week2, FLM_FLMRFLIN_XMLP_PKG.day7_var_week2formula(:day7_plan_week2, :day7_actual_week2) day7_var_week2, FLM_FLMRFLIN_XMLP_PKG.day7_lin_week2formula(:day7_plan_week2, :day7_actual_week2) day7_lin_week2, FLM_FLMRFLIN_XMLP_PKG.weekly_plan_week2formula(:day1_plan_week2, :day2_plan_week2, :day3_plan_week2, :day4_plan_week2, :day5_plan_week2, :day6_plan_week2, :day7_plan_week2) weekly_plan_week2, FLM_FLMRFLIN_XMLP_PKG.weekly_actual_week2formula(:day1_actual_week2, :day2_actual_week2, :day3_actual_week2, :day4_actual_week2, :day5_actual_week2, :day6_actual_week2, :day7_actual_week2) weekly_actual_week2, FLM_FLMRFLIN_XMLP_PKG.weekly_var_week2formula(:weekly_plan_week2, :weekly_actual_week2) weekly_var_week2, FLM_FLMRFLIN_XMLP_PKG.weekly_lin_week2formula(:weekly_plan_week2, :weekly_actual_week2) weekly_lin_week2,*/ fnd_flex_xml_publisher_apis.process_kff_combination_1('assembly_name', 'INV', 'MSTK', 101, MSI1.ORGANIZATION_ID, MSI1.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') assembly_name2, FLM_FLMRFLIN_XMLP_PKG.cf_1formula(number1, number2, number3, number4, number5, number6, number7) weekly_plan2, FLM_FLMRFLIN_XMLP_PKG.weekly_actual2formula(number8, number9, number10, number11, number12, number13, number14) weekly_actual2, --FLM_FLMRFLIN_XMLP_PKG.weekly_var2formula(:weekly_plan2, :weekly_actual2) weekly_var2, --FLM_FLMRFLIN_XMLP_PKG.weekly_lin2formula(:weekly_plan2, :weekly_actual2) weekly_lin2, FLM_FLMRFLIN_XMLP_PKG.day1_lin2formula(number1, number8) day1_lin2, FLM_FLMRFLIN_XMLP_PKG.day2_lin2formula(number2, number9) day2_lin2, FLM_FLMRFLIN_XMLP_PKG.day3_lin2formula(number3, number10) day3_lin2, FLM_FLMRFLIN_XMLP_PKG.day4_lin2formula(number4, number11) day4_lin2, FLM_FLMRFLIN_XMLP_PKG.day5_lin2formula(number5, number12) day5_lin2, FLM_FLMRFLIN_XMLP_PKG.day6_lin2formula(number6, number13) day6_lin2, FLM_FLMRFLIN_XMLP_PKG.day7_lin2formula(number7, number14) day7_lin2 from mrp_form_query mfq, mtl_system_items msi1 where :P_SORT_OPTION = 2 and query_id = :P_QUERY_ID and msi1.inventory_item_id = mfq.number15 and msi1.organization_id = :P_ORG_ID FLM FLMRFLIN_XML AR FLM تقرير خطية التدفق (تنسيق XML) Imported from BI Publisher Description: تقرير خطية التدفق Application: تدفق التصنيع Source: تقرير خطية التدفق (تنسيق XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG D FLM Flow-Linearität Imported from BI Publisher Description: Auswertung "Flow-Linearität" Application: Flow Manufacturing Source: Flow-Linearität (XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG E FLM Linealidad de Flujo Imported from BI Publisher Description: Informe de linealidad de flujo Application: Flow Manufacturing Source: Linealidad de Flujo (XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG F FLM Linéarité de flux Imported from BI Publisher Description: Etat de linéarité de flux Application: Flow Manufacturing Source: Linéarité de flux (XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG I FLM Rapporto Linearità flusso Imported from BI Publisher Description: Rapporto Linearità flusso Application: Flow Manufacturing Source: Rapporto Linearità flusso (XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG JA FLM フロー線形レポート Imported from BI Publisher Description: フロー線形レポート Application: Flow Manufacturing Source: フロー線形レポート(XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG KO FLM 플로우 선형 보고서 Imported from BI Publisher Description: 플로우 선형 보고서 Application: Flow Manufacturing Source: 플로우 선형 보고서(XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG PTB FLM Relatório de Linearidade do Fluxo Imported from BI Publisher Description: Relatório de Linearidade do Fluxo Application: Flow Manufacturing Source: Relatório de Linearidade do Fluxo (XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG RU FLM Отчет о линейности технологического процесса Imported from BI Publisher Description: Отчет о линейности технологического процесса Application: Непрерывное производство Source: Отчет о линейности технологического процесса (XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG S FLM Flödeslinjäritet - rapport Imported from BI Publisher Description: Flödeslinjäritet - rapport Application: Flow Manufacturing Source: Flödeslinjäritet - rapport (XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG TR FLM Akış Doğrusu Raporu Imported from BI Publisher Description: Akış Doğrusu Raporu Application: Akış Üretimi Source: Akış Doğrusu Raporu (XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG US FLM Flow Linearity Imported from BI Publisher Description: Flow Linearity Report Application: Flow Manufacturing Source: Flow Linearity Report (XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG ZHS FLM 流式线性报表 Imported from BI Publisher Description: 流式线性报表 Application: 流式制造管理系统 Source: 流式线性报表 (XML) Short Name: FLMRFLIN_XML DB package: FLM_FLMRFLIN_XMLP_PKG BI Publisher &p_assy_flex :p_assy_flex :p_assy_flex2 :p_conc_request_id :p_date_from :p_date_from_1 :p_date_to :p_date_to_1 :p_debug :p_line_from :p_line_to :p_org_id :p_organization :p_precision :p_query_id :p_report_option :p_report_option_name :p_sch_group :p_sort_option :p_sort_option_name 1 -20 :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 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 10 :p_report_option LOV Oracle FLM_SRS_RPT_LIN_REPORT_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='FLM_RPT_LIN_REPORT_OPT' order by meaning select meaning from mfg_lookups where lookup_type='FLM_RPT_LIN_REPORT_OPT' and lookup_code = 1 Y AR خيار التقرير خيار التقرير D Auswertungsoption Auswertungsoption E Opción de Informe Opción de Informe F Option d'état Option d'état I Opzione rapporto Opzione rapporto JA レポート・オプション レポート・オプション KO 보고서 옵션 보고서 옵션 PTB Opção do Relatório Opção do Relatório RU Параметр отчета Параметр отчета S Rapportalternativ Rapportalternativ TR Rapor Seçeneği Rapor Seçeneği US Report Option Report Option ZHS 报表选项 报表选项 3 20 :p_sort_option LOV Oracle FLM_SRS_RPT_LIN_SORT_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='FLM_RPT_LIN_SORT_OPT' order by meaning select meaning from mfg_lookups where lookup_type='FLM_RPT_LIN_SORT_OPT' and lookup_code = 1 Y AR خيار الفرز خيار الفرز D Sortieroption Sortieroption E Opción de Ordenación Opción de Ordenación F Option de tri Option de tri I Opzione di ordinamento Opzione di ordinamento JA ソート・オプション ソート・オプション KO 정렬 옵션 정렬 옵션 PTB Opção de Classificação Opção de Classificação RU Параметр сортировки Параметр сортировки S Sorteringsalternativ Sorteringsalternativ TR Sıralama Seçeneği Sıralama Seçeneği US Sort Option Sort Option ZHS 排序选项 排序选项 4 30 :p_line_from LOV Oracle CRP_SRS_LINE Y select line_code id, line_code value, description description from wip_lines where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by value,description AR من السطر من السطر D Von Linie Von Linie E De Línea De Línea F Ligne - De Ligne - De I Linea - Da Linea - Da JA ライン:自 ライン:自 KO From 라인 From 라인 PTB Linha - De Linha - De RU Линия с Линия с S Från rad Från rad TR İlk Satır İlk Satır US From Line From Line ZHS 自生产线 自生产线 5 40 :p_line_to LOV Oracle CRP_SRS_LINE Y select line_code id, line_code value, description description from wip_lines where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by value,description select :$flex$.from_line from dual AR إلى السطر إلى السطر D Bis Linie Bis Linie E A Línea A Línea F Ligne - A Ligne - A I Linea - A Linea - A JA ライン:至 ライン:至 KO To 라인 To 라인 PTB Linha - Até Linha - Até RU Линия по Линия по S Till rad Till rad TR Son Satır Son Satır US To Line To Line ZHS 至生产线 至生产线 6 50 :p_date_from LOV Oracle FLM_SRS_START_DATE_ALL Y select calendar_date id, calendar_date value, null description from bom_calendar_dates where (calendar_code,exception_set_id) in (select calendar_code,calendar_exception_set_id from mtl_parameters where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) order by calendar_date sysdate Y AR من تاريخ من تاريخ D Von Datum Von Datum E De Fecha De Fecha F Date de début Date de début I Data - Da Data - Da JA 日付:自 日付:自 KO 일자: 부터 일자: 부터 PTB Data - De Data - De RU Дата с Дата с S Från datum Från datum TR Başlangıç Tarihi Başlangıç Tarihi US From Date From Date ZHS 起始日期 起始日期 7 60 :p_date_to LOV Oracle FLM_SRS_END_DATE_ALL Y select calendar_date id, calendar_date value, null description from bom_calendar_dates where (calendar_code,exception_set_id) in (select calendar_code,calendar_exception_set_id from mtl_parameters where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) and calendar_date>=fnd_date.canonical_to_date(:$flex$.flm_srs_start_date_all) order by calendar_date select fnd_date.date_to_displaydate(fnd_date.canonical_to_date(:$flex$.from_date)) from dual Y AR إلى تاريخ إلى تاريخ D Bis Datum Bis Datum E A Fecha A Fecha F Date de fin Date de fin I Data - A Data - A JA 日付:至 日付:至 KO 일자: 까지 일자: 까지 PTB Data - Até Data - Até RU Дата по Дата по S Till datum Till datum TR Bitiş Tarihi Bitiş Tarihi US To Date To Date ZHS 终止日期 终止日期 8 70 :p_sch_group LOV Oracle WIP_SRS_SCHEDULE_GROUPS Y select wsg.schedule_group_name id, wsg.schedule_group_name value, null description from wip_schedule_groups wsg where wsg.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by schedule_group_name AR زمرة الجدول زمرة الجدول D Planungsgruppe Planungsgruppe E Grupo de Programas Grupo de Programas F Groupe de planification Groupe de planification I Gruppo programmi Gruppo programmi JA 計画グループ 計画グループ KO 스케줄 그룹 스케줄 그룹 PTB Grupo de Programações Grupo de Programações RU Группа планирования Группа планирования S Schemagrupp Schemagrupp TR Çizelge Grubu Çizelge Grubu US Schedule Group Schedule Group ZHS 计划组 计划组