ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4729D51A9E05362FB09050512Y select WE.wip_entity_name Job_Schedule, WL.line_code Line, DE.department_code Dept, WO.operation_seq_num Seq, SUM(round(WO.quantity_in_queue,:P_Qty_Precision)) Queue, SUM(round(WO.quantity_running,:P_Qty_Precision)) Run, SUM(round(WO.quantity_waiting_to_move,:P_Qty_Precision)) To_move, SUM(round(WO.quantity_rejected,:P_Qty_Precision)) Rejected, SUM(round(WO.quantity_scrapped,:P_Qty_Precision)) Scrapped, fnd_flex_xml_publisher_apis.process_kff_combination_1('assembly', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') Assembly from mtl_system_items MSI, wip_lines WL, wip_repetitive_schedules WR, wip_discrete_jobs DJ, wip_operations WO, bom_departments DE, wip_entities WE where &P_FLEXWHERE and WO.organization_id = :P_Organization_Id and WE.organization_id = :P_Organization_Id and DE.organization_id = :P_Organization_Id and MSI.organization_id = WE.Organization_Id and WO.wip_entity_id = WE.wip_entity_id and WR.line_id = WL.line_id (+) and WR.organization_id = WL.organization_id (+) and WO.repetitive_schedule_id = WR.repetitive_schedule_id (+) and WE.primary_item_id = MSI.inventory_item_id and WO.wip_entity_id = WR.wip_entity_id (+) and WO.organization_id = WR.organization_id (+) and WO.wip_entity_id = DJ.wip_entity_id (+) and WO.organization_id = DJ.organization_id (+) and WE.entity_type in (1, 2) and (DJ.status_type in (3,4,6) OR WR.status_type in (3,4,6)) and WO.department_id = DE.department_id and (WO.quantity_in_queue >0 OR WO.quantity_running >0 OR WO.quantity_waiting_to_move >0 OR WO.quantity_rejected >0 OR WO.quantity_scrapped >0) &Limit_Jobs &Limit_Lines &Limit_Assembly &Limit_Departments group by fnd_flex_xml_publisher_apis.process_kff_combination_1('assembly', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), WE.wip_entity_name, WL.line_code, DE.department_code, WO.operation_seq_num &C_Order1 &C_ASSY_ORDER &C_Order2 WIP WIPMTLCT_XML AR WIP تقرير موقع ما تحت التنفيذ (بتنسيق XML) Imported from BI Publisher Description: تقرير موقع ما تحت التنفيذ Application: العمل في الإنجاز Source: تقرير موقع ما تحت التنفيذ (بتنسيق XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG D WIP Fertigung - Arbeitsfortschritt Imported from BI Publisher Description: Fertigung - Arbeitsfortschritt Application: Fertigung Source: Fertigung - Arbeitsfortschritt (XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG E WIP Ubicaciones de Obra en Curso Imported from BI Publisher Description: Informe de ubicaciones de obra en curso Application: Work in Process Source: Ubicaciones de Obra en Curso (XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG F WIP Etat Emplacements des en-cours Imported from BI Publisher Description: Etat Emplacements des en-cours Application: Work In Process Source: Etat Emplacements des en-cours (XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG I WIP Rapporto Ubicazioni WIP Imported from BI Publisher Description: Rapporto Ubicazioni WIP Application: Work in Process Source: Rapporto Ubicazioni WIP (XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG JA WIP WIP場所レポート Imported from BI Publisher Description: WIP場所レポート Application: Work in Process Source: WIP場所レポート(XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG KO WIP 위치 보고서 Imported from BI Publisher Description: WIP 위치 보고서 Application: Work in Process Source: WIP 위치 보고서(XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG PTB WIP Relatório de Local do WIP Imported from BI Publisher Description: Relat. Local de WIP Application: Work in Process Source: Relatório de Local do WIP (XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG RU WIP Отчет о расположениях НзП Imported from BI Publisher Description: Отчет о расположениях НзП Application: Незавершенное производство Source: Отчет о расположениях НзП (XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG S WIP PIA-adress - rapport Imported from BI Publisher Description: PIA-adress - rapport Application: Work in Process Source: PIA-adress - rapport (XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG TR WIP Yerleşim Raporu Imported from BI Publisher Description: WIP Yerleşim Raporu Application: Üretim İzleme Source: WIP Yerleşim Raporu (XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG US WIP Location Imported from BI Publisher Description: WIP Location Report Application: Work in Process Source: WIP Location Report (XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG ZHS WIP 地点报表 Imported from BI Publisher Description: WIP 地点报表 Application: 在制品管理系统 Source: WIP 地点报表 (XML) Short Name: WIPMTLCT_XML DB package: WIP_WIPMTLCT_XMLP_PKG BI Publisher &c_assy_order &c_order1 &c_order2 &limit_assembly &limit_departments &limit_jobs &limit_lines &p_flexwhere :p_assy_flex :p_assy_order :p_conc_request_id :p_debug :p_flex_num :p_flexwhere :p_from_assembly_id :p_from_department_id :p_from_job_id :p_from_line :p_organization_id :p_qty_precision :p_sort :p_struct_num :p_to_assembly_id :p_to_department_id :p_to_job_id :p_to_line 1 -40 :p_struct_num Number select chart_of_accounts_id from org_organization_definitions where organization_id = fnd_profile.value('mfg_organization_id') Y AR رقم هيكل مرن رقم هيكل مرن D FlexFeld-Struktur-Nummer FlexFeld-Struktur-Nummer E Número de Tipo de Estructura Número de Tipo de Estructura F Numéro structure flexible Numéro structure flexible I Numero struttura flexfield Numero struttura flexfield JA フレックス体系番号 フレックス体系番号 KO 가변 구조 번호 가변 구조 번호 PTB Número da Estrutura do Flexfield Número da Estrutura de Flexfield RU Номер структуры ГП Номер структуры ГП S Flexstrukturnummer Flexstrukturnummer TR Esnekalan yapı numarası Esnek Yapı Numarası US Flex structure number Flex Structure Number ZHS 弹性结构编号 弹性结构编号 2 -30 :p_organization_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 组织标识 组织标识 3 -20 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Precisión de Cantidad Precisión de Cantidad F Précision des quantités Précision des quantités I Precisione quantità Precisione quantità JA 数量精度 数量精度 KO 수량 소수점이하 자리수 수량 소수점이하 자리수 PTB Precisão da Quantidade Precisão da Quantidade RU Точность количества Точность количества S Kvantitetsprecision Kvantitetsprecision TR Miktar Duyarlılığı Miktar Duyarlılığı US Quantity Precision Quantity Precision ZHS 数量精确度 数量精确度 4 10 :p_sort LOV Oracle WIP_SRS_LOCATION_SORT_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_LOCATION_SORT' and lookup_code in (1,2,3,4) order by meaning select meaning from mfg_lookups where lookup_code = 1 and lookup_type = 'WIP_LOCATION_SORT' Y AR فرز بواسطة اختيار الفرز D Sortieren nach Sortieroption E Ordenar por Selección de clasificación F Tri par Sélection tri I Ordina per Selezione ordinamento JA ソート・キー ソート選択 KO 정렬 기준 정렬 선택 PTB Classificar por Classificar Seleção RU Сортировка Выбор параметра сортировки S Sortera efter Sortera urval TR Sıralama Ölçütü Sıralama seçimi US Sort By Sort selection ZHS 排序依据 排序选择 5 20 :p_from_job_id LOV Oracle WIP_SRS_ALL_ENTITIES_OPT Y select wip_entity_name id, wip_entity_name value, null description from wip_entities where organization_id= fnd_profile.value('MFG_ORGANIZATION_ID') order by wip_entity_name AR أوامر الشغل/الجداول من أمر شغل/جدول من D Von Fertigungsauftrag Von Fertigungsauftrag E De Orden de Fabricación/Programa De orden de fabricación/programa F OF/Programmes - De OF/Programme - De I OdL/programmi - Da OdL/Programma - Da JA 製造オーダー:自 製造オーダー:自 KO 단속 작업/반복 스케줄: 부터 단속 작업/반복 스케줄: 부터 PTB Ordens de Produção/Programações De OP/Programação - De RU Задания/графики с Задания/графики с S Från TO/planer TO/plan från TR İş Emirleri/Çizelgeler, İlk İş emri/çizelge: ilk US Jobs/Schedules From Job/schedule from ZHS 任务/计划自 任务/计划自 6 30 :p_to_job_id LOV Oracle WIP_SRS_ALL_ENTITIES_OPT Y select wip_entity_name id, wip_entity_name value, null description from wip_entities where organization_id= fnd_profile.value('MFG_ORGANIZATION_ID') order by wip_entity_name AR إلى أوامر شغل/جدول إلى D Bis Bis Fertigungsauftrag E A A orden de fabricación/programa F A OF/Programme - A I A OdL/Programma - A JA 至 製造オーダー:至 KO 까지 단속 작업/반복 스케줄: 까지 PTB Até OP/Programação - até RU По Задания/графики по S Till TO/plan till TR Son İş emri/çizelge: son US To Job/schedule to ZHS 至 任务/计划至 7 40 :p_from_line LOV Oracle WIP_SRS_LINES_OPT Y select wl.line_code id, wl.line_code value, null description from wip_lines wl where wl.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by line_code AR السطور من سطر من D Von Linie Von Linie E De Línea De línea F Lignes - De Ligne - De I Linee - Da Linee - Da JA ライン:自 ライン:自 KO 라인: 부터 라인: 부터 PTB Linhas - De Linhas - De RU Линии с Линия с S Från rader Rad från TR Hatlar, İlk Hat: İlk US Lines From Line from ZHS 生产线自 生产线自 8 50 :p_to_line LOV Oracle WIP_SRS_LINES_OPT Y select wl.line_code id, wl.line_code value, null description from wip_lines wl where wl.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by line_code AR إلى 2 سطر إلي D Bis 2 Bis Linie E A 2 A Línea F A 2 Ligne - A I A 2 Linee - A JA 至 2 ライン:至 KO 까지 2 라인: 까지 PTB Até 2 Linhas - até RU По 2 Линии по S Till 2 Rad till TR Son 2 Hat: Son US To 2 Line to ZHS 至 2 生产线至 9 60 :p_from_assembly_id Char AR المنتجات من المنتج من D Von Baugruppe Von Baugruppe E De Conjunto De Conjunto F Produits - De Produit - De I Assiemi - Da Assiemi - Da JA 組立:自 組立:自 KO 조립품: 부터 조립품: 부터 PTB Montagens - De Montagem - De RU Сборки с Сборка с S Från produkter Produkt från TR Ürünler: İlk Ürün: İlk US Assemblies From Assembly from ZHS 装配件自 装配件自 10 70 :p_to_assembly_id Char AR إلى 3 المنتج إلى D Bis 3 Bis Baugruppe E A 3 A Conjunto F A 3 Produit - A I A 3 Assiemi - A JA 至 3 組立:至 KO 까지 3 조립품: 까지 PTB Até 3 Montagem - até RU По 3 Сборка по S Till 3 Produkt till TR Son 3 Son Ürün US To 3 Assembly to ZHS 至 3 装配件至 11 80 :p_from_department_id LOV Oracle WIP_SRS_DEPARTMENTS_OPT Y select department_code id, department_code value, null description from bom_departments where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by department_code AR الأقسام من القسم من D Von Abteilung Von Abteilung E De Departamento De Departamento F Sections - De Section - De I Reparti - Da Reparti - Da JA 部門:自 部門:自 KO 부서: 부터 부서: 부터 PTB Deptos. - De Departamento- De RU Отделы с Отделы с S Från avdelning Avdelning från TR Departmanlar, İlk Departman: İlk US Departments From Department from ZHS 部门自 部门自 12 90 :p_to_department_id LOV Oracle WIP_SRS_DEPARTMENTS_OPT Y select department_code id, department_code value, null description from bom_departments where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by department_code AR إلى 4 معرف القسم D Bis 4 Bis Abteilung E A 4 A Departamento F A 4 Section - A I A 4 Reparto - A JA 至 4 部門:至 KO 까지 4 부서: 까지 PTB Até 4 Departamento - Até RU По 4 Отделы по S Till 4 Avdelning till TR Son 4 Departman: Son US To 4 Department to ZHS 至 4 部门至