ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FA451A9E05362FB09050512Y (select wl.line_code, wfs.scheduled_completion_date completion_date, wfs.build_sequence build_seq, &P_ASSY_FLEX C_ASSY_FLEX, msi1.primary_uom_code assembly_uom, wfs.planned_quantity-wfs.quantity_completed assembly_qty, wsg.schedule_group_name sch_group, wfs.schedule_number sch_number, decode(NVL(wfs.demand_source_line,-1),-1,NULL,&P_SO_FLEX) C_SO_FLEX, so_lines.line_number so_line, so_lines.request_date so_date, wfs.bom_revision bom_rev, be.operation_seq_num operation_seq, be.component_item_id component_id, &P_COMP_FLEX C_COMP_FLEX, be.primary_uom_code component_uom, be.extended_quantity component_qty, substr(flm_schedule_report.get_revision(be.organization_id, be.component_item_id,be.effectivity_date),0,3) rev, bic.change_notice ECO, be.optional optional_id, ml.meaning optional, bic.supply_subinventory subinventory, decode(NVL(bic.supply_locator_id,-1),-1,NULL,&P_LOC_FLEX) C_LOC_FLEX, 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_name, fnd_flex_xml_publisher_apis.process_kff_combination_1('component_name', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') component_name, fnd_flex_xml_publisher_apis.process_kff_combination_1('so_name', 'INV', 'MKTS', 101, NULL, MSO.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE') so_name, fnd_flex_xml_publisher_apis.process_kff_combination_1('locator_name', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') locator_name from wip_flow_schedules wfs, wip_lines wl, wip_schedule_groups wsg, oe_order_lines_all so_lines, mtl_system_items msi1, bom_explosions be, mtl_sales_orders mso, mtl_system_items msi2, bom_inventory_components bic, mfg_lookups ml, mtl_item_locations mil where :P_DISPLAY_BOM = 1 and wfs.organization_id = :P_ORG_ID and trunc(wfs.scheduled_completion_date) between :CP_DATE_FROM and :CP_DATE_TO and (wfs.planned_quantity-wfs.quantity_completed > 0) and wfs.primary_item_id = msi1.inventory_item_id and wfs.organization_id = msi1.organization_id and wfs.demand_source_header_id = mso.sales_order_id (+) and wfs.demand_source_line = so_lines.line_id (+) and wfs.line_id = wl.line_id and wfs.organization_id = wl.organization_id and wfs.schedule_group_id = wsg.schedule_group_id (+) and wfs.organization_id = wsg.organization_id (+) and wfs.primary_item_id = be.top_item_id and wfs.organization_id = be.organization_id and be.component_item_id = msi2.inventory_item_id and be.organization_id = msi2.organization_id and be.component_sequence_id = bic.component_sequence_id and ((be.plan_level = 1 and msi2.item_type != 'PH') or (be.plan_level > 1 and (flm_schedule_report.display_item(1,be.sort_order,be.top_bill_sequence_id, be.organization_id))=1)) and ml.lookup_type = 'SYS_YES_NO' and ml.lookup_code = be.optional and mil.inventory_location_id (+) = bic.supply_locator_id and mil.organization_id (+) = :P_ORG_ID &P_LIMIT_LINE &P_LIMIT_SCH_GROUP) union (select wl.line_code, wfs.scheduled_completion_date completion_date, wfs.build_sequence build_seq, &P_ASSY_FLEX C_ASSY_FLEX, msi1.primary_uom_code assembly_uom, wfs.planned_quantity-wfs.quantity_completed assembly_qty, wsg.schedule_group_name sch_group, wfs.schedule_number sch_number, decode(NVL(wfs.demand_source_line,-1),-1,NULL,&P_SO_FLEX) C_SO_FLEX, so_lines.line_number so_line, so_lines.request_date so_date, wfs.bom_revision bom_rev, 0 operation_seq, 0 component_id, NULL C_COMP_FLEX, NULL component_uom, 0 component_qty, NULL rev, NULL ECO, 0 optional_id, NULL optional, NULL subinventory, NULL C_LOC_FLEX, null assembly_name, null component_name, null so_name, null locator_name from wip_flow_schedules wfs, wip_lines wl, wip_schedule_groups wsg, oe_order_lines_all so_lines, mtl_system_items msi1, mtl_sales_orders mso where (:P_DISPLAY_BOM = 2 OR not exists (select top_item_id from bom_explosions be where be.top_item_id = wfs.primary_item_id and be.organization_id = :P_ORG_ID)) and wfs.organization_id = :P_ORG_ID and trunc(wfs.scheduled_completion_date) between :CP_DATE_FROM and :CP_DATE_TO and (wfs.planned_quantity-wfs.quantity_completed > 0) and wfs.primary_item_id = msi1.inventory_item_id and wfs.organization_id = msi1.organization_id and wfs.demand_source_header_id = mso.sales_order_id (+) and wfs.demand_source_line = so_lines.line_id (+) and wfs.line_id = wl.line_id and wfs.organization_id = wl.organization_id and wfs.schedule_group_id = wsg.schedule_group_id (+) and wfs.organization_id = wsg.organization_id (+) &P_LIMIT_LINE &P_LIMIT_SCH_GROUP) ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC,6 ASC,7 ASC,8 ASC,9 ASC,10 ASC,11 ASC,12 ASC , line_code , completion_date , build_seq , operation_seq FLM FLMRFSCH_XML AR FLM تقرير جدول التدفق (تنسيق XML) Imported from BI Publisher Description: تقرير جدول التدفق Application: تدفق التصنيع Source: تقرير جدول التدفق (تنسيق XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG D FLM Flow-Plan Imported from BI Publisher Description: Auswertung "Flow-Plan" Application: Flow Manufacturing Source: Flow-Plan (XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG E FLM Programa de Flujo Imported from BI Publisher Description: Informe de programa de flujo Application: Flow Manufacturing Source: Programa de Flujo (XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG F FLM Etat des programmes de flux Imported from BI Publisher Description: Etat des programmes de flux Application: Flow Manufacturing Source: Etat des programmes de flux (XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG I FLM Rapporto Programma flusso Imported from BI Publisher Description: Rapporto Programma flusso Application: Flow Manufacturing Source: Rapporto Programma flusso (XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG JA FLM フロー・スケジュール・レポート Imported from BI Publisher Description: フロー・スケジュール・レポート Application: Flow Manufacturing Source: フロー・スケジュール・レポート(XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG KO FLM 플로우 스케줄 보고서 Imported from BI Publisher Description: 플로우 스케줄 보고서 Application: Flow Manufacturing Source: 플로우 스케줄 보고서(XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG PTB FLM Relatório de Programação do Fluxo Imported from BI Publisher Description: Relatório da Programação do Fluxo Application: Flow Manufacturing Source: Relatório de Programação do Fluxo (XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG RU FLM Отчет по графику технологического процесса Imported from BI Publisher Description: Отчет по графику технологического процесса Application: Непрерывное производство Source: Отчет по графику технологического процесса (XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG S FLM Flödesschema - rapport Imported from BI Publisher Description: Flödesschema - rapport Application: Flow Manufacturing Source: Flödesschema - rapport (XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG TR FLM Akış Çizelgesi Raporu Imported from BI Publisher Description: Akış Çizelgesi Raporu Application: Akış Üretimi Source: Akış Çizelgesi Raporu (XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG US FLM Flow Schedule Imported from BI Publisher Description: Flow Schedule Report Application: Flow Manufacturing Source: Flow Schedule Report (XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG ZHS FLM 流式作业计划报表 Imported from BI Publisher Description: 流式作业计划报表 Application: 流式制造管理系统 Source: 流式作业计划报表 (XML) Short Name: FLMRFSCH_XML DB package: FLM_FLMRFSCH_XMLP_PKG BI Publisher &p_assy_flex &p_comp_flex &p_limit_line &p_limit_sch_group &p_loc_flex &p_so_flex :cp_date_from :cp_date_to :cp_line_from :cp_line_to :p_assy_flex :p_comp_flex :p_conc_request_id :p_date_from :p_date_to :p_debug :p_display_bom :p_item_flex_num :p_limit_line :p_limit_optional_item_only :p_limit_sch_group :p_line_from :p_line_to :p_loc_flex :p_optional_item_only :p_org_id :p_organization :p_sch_group :p_so_flex 1 -30 :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 -20 :p_dummy Number select 1 from dual where :$flex$.display_bom = 1 AR FLM_SRS_YES_NO_DUMMY افتراضي E FLM_SRS_YES_NO_DUMMY Ficticia F FLM_SRS_YES_NO_DUMMY Fictif I FLM_SRS_YES_NO_DUMMY Fittizio JA FLM_SRS_YES_NO_DUMMY ダミー PTB FLM_SRS_YES_NO_DUMMY Fictício RU FLM_SRS_YES_NO_DUMMY Фиктивный TR FLM_SRS_YES_NO_DUMMY Sözde US FLM_SRS_YES_NO_DUMMY Dummy ZHS FLM_SRS_YES_NO_DUMMY 虚拟 3 10 :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 自生产线 自生产线 4 20 :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 至生产线 至生产线 5 30 :p_date_from LOV Oracle FLM_SRS_START_DATE_STANDARD 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>=trunc(sysdate) 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 起始日期 起始日期 6 40 :p_date_to LOV Oracle FLM_SRS_END_DATE_STANDARD 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_standard) 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 终止日期 终止日期 7 50 :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 计划组 计划组 8 60 :p_display_bom LOV Oracle FLM_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning select meaning from mfg_lookups where lookup_type='SYS_YES_NO' and lookup_code = 2 Y AR عرض شجرة المنتجات عرض شجرة المنتجات D Stückliste anzeigen Stückliste anzeigen E Mostrar Lista Mostrar Lista F Afficher la nomenclature Afficher la nomenclature I Visualizza distinta base Visualizza distinta base JA BOMの表示 BOMの表示 KO BOM 표시 BOM 표시 PTB Exibir BOM Exibir BOM RU Вывод спецификации Вывод спецификации S Visa prod.struktur Visa prod.struktur TR Ürün Ağacı Görüntüle Ürün Ağacı Görüntüle US Display BOM Display BOM ZHS 显示 BOM 显示 BOM 9 70 :p_optional_item_only LOV Oracle FLM_SRS_YES_NO_DEP Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' and :$flex$.flm_srs_yes_no_dummy=1 order by meaning select meaning from mfg_lookups where lookup_type='SYS_YES_NO' and lookup_code = 2 and :$FLEX$.FLM_SRS_YES_NO_DUMMY = 1 Y AR عرض الأصناف الاختيارية فقط عرض الأصناف الاختيارية فقط D Nur optionale Artikel anzeigen Nur optionale Artikel anzeigen E Mostrar Sólo Artículos Opcionales Mostrar Sólo Artículos Opcionales F Afficher uniquement les articles facultatifs Afficher uniquement les articles facultatifs I Visualizza solo articoli facoltativi Visualizza solo articoli facoltativi JA オプション品目のみ表示 オプション品目のみ表示 KO 선택적 품목만 표시 선택적 품목만 표시 PTB Exibir Itens Opcionais Apenas Exibir Itens Opcionais Apenas RU Вывод только необязательных позиций Вывод только необязательных позиций S Visa endast valfria artiklar Visa endast valfria artiklar TR Sadece İsteğe Bağlı Kalemleri Görüntüle Sadece İsteğe Bağlı Kalemleri Görüntüle US Display Optional Items Only Display Optional Items Only ZHS 仅显示可选物料 仅显示可选物料 :$FLEX$.FLM_SRS_YES_NO_DUMMY FLM_SRS_YES_NO_DUMMY Display Optional Items Only :$flex$.display_bom Display BOM FLM_SRS_YES_NO_DUMMY :$flex$.flm_srs_start_date_standard From Date To Date :$flex$.flm_srs_yes_no_dummy FLM_SRS_YES_NO_DUMMY Display Optional Items Only :$flex$.from_date From Date To Date :$flex$.from_line From Line To Line