ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4729A51A9E05362FB09050512 SELECT BD.DEPARTMENT_CODE Department , BR.RESOURCE_CODE Resource_code , NVL(BR.UNIT_OF_MEASURE,' ') UOM , WE.WIP_ENTITY_NAME Job , WL.LINE_CODE Line , WOP.OPERATION_SEQ_NUM Op_Seq , WOR.RESOURCE_SEQ_NUM Res_Seq , WOP.FIRST_UNIT_START_DATE First_Unit , WOP.LAST_UNIT_COMPLETION_DATE Last_Unit , round(WOP.QUANTITY_COMPLETED,:P_qty_precision) Assy_Units , WOP.QUANTITY_COMPLETED Assy_Units1 , MSI.PRIMARY_UOM_CODE Assy , round(WOR.USAGE_RATE_OR_AMOUNT,:P_qty_precision) Usage_Rate , WOR.USAGE_RATE_OR_AMOUNT Usage_Rate1 , WOR.BASIS_TYPE Basis_Type , ML.MEANING Basis , round(WOR.APPLIED_RESOURCE_UNITS,:P_qty_precision) Applied, --WIP_WIPLBPER_XMLP_PKG.c_eff_total_mainformula(:C_Applied_Total, :C_Std_Total) C_Eff_Total_Main, --WIP_WIPLBPER_XMLP_PKG.c_eff_flagformula(:C_Eff_Total_Main) C_Eff_Flag, WIP_WIPLBPER_XMLP_PKG.c_std_unitsformula(WOR.BASIS_TYPE, WOR.USAGE_RATE_OR_AMOUNT, WOP.QUANTITY_COMPLETED, round ( WOR.USAGE_RATE_OR_AMOUNT , :P_qty_precision )) C_Std_Units, WIP_WIPLBPER_XMLP_PKG.c_efficiencyformula(round ( WOR.APPLIED_RESOURCE_UNITS , :P_qty_precision ), WIP_WIPLBPER_XMLP_PKG.c_std_unitsformula(WOR.BASIS_TYPE, WOR.USAGE_RATE_OR_AMOUNT, WOP.QUANTITY_COMPLETED, round ( WOR.USAGE_RATE_OR_AMOUNT , :P_qty_precision ))) C_Efficiency FROM MFG_LOOKUPS ML , WIP_LINES WL , MTL_SYSTEM_ITEMS MSI , WIP_REPETITIVE_SCHEDULES WRS , WIP_ENTITIES WE , WIP_OPERATION_RESOURCES WOR , WIP_OPERATIONS WOP , BOM_RESOURCES BR , BOM_DEPARTMENT_RESOURCES BDR , BOM_DEPARTMENTS BD WHERE BD.ORGANIZATION_ID = :P_Organization_Id &C_Limit_Dept AND BDR.DEPARTMENT_ID = BD.DEPARTMENT_ID AND BR.RESOURCE_ID = BDR.RESOURCE_ID &C_Limit_Resources AND BD.DEPARTMENT_ID = NVL( WOR.DEPARTMENT_ID, WOP.DEPARTMENT_ID) AND WOP.ORGANIZATION_ID = :P_Organization_Id AND WOR.WIP_ENTITY_ID = WOP.WIP_ENTITY_ID AND WOR.ORGANIZATION_ID = :P_Organization_Id AND WOR.OPERATION_SEQ_NUM = WOP.OPERATION_SEQ_NUM AND NVL(WOR.REPETITIVE_SCHEDULE_ID,-1) = NVL(WOP.REPETITIVE_SCHEDULE_ID,-1) AND WOR.RESOURCE_ID + 0 = BDR.RESOURCE_ID AND (((round(WOP.QUANTITY_COMPLETED,:P_qty_precision) <> 0) AND (round(WOR.USAGE_RATE_OR_AMOUNT,:P_qty_precision) <> 0)) OR (round(WOR.APPLIED_RESOURCE_UNITS,:P_qty_precision) <> 0)) AND WE.WIP_ENTITY_ID = WOP.WIP_ENTITY_ID &C_Limit_Dates AND MSI.ORGANIZATION_ID = :P_Organization_Id AND MSI.INVENTORY_ITEM_ID = WE.PRIMARY_ITEM_ID AND WRS.ORGANIZATION_ID(+) = :P_Organization_Id AND WRS.REPETITIVE_SCHEDULE_ID(+) = NVL(WOP.REPETITIVE_SCHEDULE_ID,-1) AND WL.LINE_ID(+) = WRS.LINE_ID AND WL.ORGANIZATION_ID(+) = :P_Organization_Id AND ML.LOOKUP_TYPE = 'CST_BASIS_SHORT' AND ML.LOOKUP_CODE = WOR.BASIS_TYPE UNION ALL SELECT BD.DEPARTMENT_CODE Department , BR.RESOURCE_CODE Resource_code , NVL(BR.UNIT_OF_MEASURE,' ') UOM , WF.SCHEDULE_NUMBER Job , WL.LINE_CODE Line , BOS.OPERATION_SEQ_NUM Op_Seq , BOR.RESOURCE_SEQ_NUM Res_Seq , WF.SCHEDULED_START_DATE First_Unit , WF.SCHEDULED_COMPLETION_DATE Last_Unit , round(WF.QUANTITY_COMPLETED,:P_Qty_Precision) Assy_Units , WF.QUANTITY_COMPLETED Assy_Units1 , MSI.PRIMARY_UOM_CODE Assy , round(BOR.USAGE_RATE_OR_AMOUNT,:P_Qty_Precision) Usage_Rate , BOR.USAGE_RATE_OR_AMOUNT Usage_Rate1 , BOR.BASIS_TYPE Basis_Type , ML.MEANING Basis , to_number(NULL) Applied, --WIP_WIPLBPER_XMLP_PKG.c_eff_total_mainformula(:C_Applied_Total, :C_Std_Total) C_Eff_Total_Main, --WIP_WIPLBPER_XMLP_PKG.c_eff_flagformula(:C_Eff_Total_Main) C_Eff_Flag, WIP_WIPLBPER_XMLP_PKG.c_std_unitsformula(BOR.BASIS_TYPE, BOR.USAGE_RATE_OR_AMOUNT, WF.QUANTITY_COMPLETED, round(WF.QUANTITY_COMPLETED,:P_Qty_Precision)) C_Std_Units, WIP_WIPLBPER_XMLP_PKG.c_efficiencyformula(round ( to_number(NULL), :P_qty_precision ),WIP_WIPLBPER_XMLP_PKG.c_std_unitsformula(BOR.BASIS_TYPE, BOR.USAGE_RATE_OR_AMOUNT, WF.QUANTITY_COMPLETED, round(WF.QUANTITY_COMPLETED,:P_Qty_Precision))) C_Efficiency FROM MFG_LOOKUPS ML , WIP_LINES WL , MTL_SYSTEM_ITEMS MSI , WIP_FLOW_SCHEDULES WF , BOM_OPERATIONAL_ROUTINGS BROUT , BOM_OPERATION_RESOURCES BOR , BOM_OPERATION_SEQUENCES BOS , BOM_RESOURCES BR , BOM_DEPARTMENT_RESOURCES BDR , BOM_DEPARTMENTS BD WHERE BROUT.ORGANIZATION_ID = :P_Organization_Id AND WF.ORGANIZATION_ID = BROUT.ORGANIZATION_ID AND WF.PRIMARY_ITEM_ID = BROUT.ASSEMBLY_ITEM_ID AND nvl(WF.ALTERNATE_ROUTING_DESIGNATOR, chr(12)) = nvl(BROUT.ALTERNATE_ROUTING_DESIGNATOR, chr(12)) AND BROUT.COMMON_ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID AND BOR.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID AND BOR.RESOURCE_ID = BDR.RESOURCE_ID AND BDR.DEPARTMENT_ID = BD.DEPARTMENT_ID AND BDR.RESOURCE_ID = BR.RESOURCE_ID AND (round(BOR.USAGE_RATE_OR_AMOUNT,:P_Qty_Precision) <> 0) AND MSI.ORGANIZATION_ID = :P_Organization_Id AND MSI.INVENTORY_ITEM_ID = WF.PRIMARY_ITEM_ID AND ML.LOOKUP_TYPE = 'CST_BASIS_SHORT' AND ML.LOOKUP_CODE = BOR.BASIS_TYPE AND WL.LINE_ID(+) = WF.LINE_ID AND WL.ORGANIZATION_ID(+) = :P_Organization_Id &C_Limit_Dept &C_Limit_Resources ORDER BY Department , Resource_Code , UOM , Job , Line , First_Unit , Last_Unit , Op_Seq , Res_Seq Y WIP WIPLBPER_XML AR WIP تقرير أداء المورد (بتنسيق XML) Imported from BI Publisher Description: تقرير أداء المورد Application: العمل في الإنجاز Source: تقرير أداء المورد (بتنسيق XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG D WIP Ressourceneffizienz Imported from BI Publisher Description: Ressourceneffizienz Application: Fertigung Source: Ressourceneffizienz (XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG E WIP Rendimiento de Recurso Imported from BI Publisher Description: Informe de rendimiento de recurso Application: Work in Process Source: Rendimiento de Recurso (XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG F WIP Etat Performances des ressources Imported from BI Publisher Description: Etat Performances des ressources Application: Work In Process Source: Etat Performances des ressources (XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG I WIP Rapporto Prestazioni risorse Imported from BI Publisher Description: Rapporto Prestazioni risorse Application: Work in Process Source: Rapporto Prestazioni risorse (XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG JA WIP 生産資源実績レポート Imported from BI Publisher Description: 生産資源実績レポート Application: Work in Process Source: 生産資源実績レポート(XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG KO WIP 자원 성과 보고서 Imported from BI Publisher Description: 자원 성과 보고서 Application: Work in Process Source: 자원 성과 보고서(XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG PTB WIP Relatório de Desempenho do Recurso Imported from BI Publisher Description: Relat. Desempenho Recurso Application: Work in Process Source: Relatório de Desempenho do Recurso (XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG RU WIP Отчет об эффективности использования ресурсов Imported from BI Publisher Description: Отчет об эффективности использования ресурсов Application: Незавершенное производство Source: Отчет об эффективности использования ресурсов (XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG S WIP Resursresultat - rapport Imported from BI Publisher Description: Resursresultat - rapport Application: Work in Process Source: Resursresultat - rapport (XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG TR WIP Kaynak Performans Raporu Imported from BI Publisher Description: Kaynak Performans Raporu Application: Üretim İzleme Source: Kaynak Performans Raporu (XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG US WIP Resource Performance Imported from BI Publisher Description: Resource Performance Report Application: Work in Process Source: Resource Performance Report (XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG ZHS WIP 资源效率报表 Imported from BI Publisher Description: 资源效率报表 Application: 在制品管理系统 Source: 资源效率报表 (XML) Short Name: WIPLBPER_XML DB package: WIP_WIPLBPER_XMLP_PKG BI Publisher &c_limit_dates &c_limit_dept &c_limit_resources :cp_currency_code :p_conc_request_id :p_debug :p_from_date :p_from_date1 :p_from_department :p_from_resource :p_maximum_efficiency :p_minimum_efficiency :p_organization_id :p_qty_precision :p_to_date :p_to_date1 :p_to_department :p_to_resource 1 -30 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR Org_id معرف التنظيم D Org_id Organisationskennung E Org_id Id Organización F Org_id ID organisation I Org_id Id dell'organizzazione JA Org_id 組織ID KO Org_id 조직 ID PTB Org_id ID da Organização RU Org_id Идент. организации S Org_id Organisations-id TR Org_id Organizasyon No US Org_id Organization ID ZHS Org_id 组织标识 2 -20 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية دقة ديناميكية لحقول الكميات D Nachkommastellen Anzahl Nachkommastellen für Mengenfelder E Precisión de Cantidad Precisión dinámica para campos de cantidad F Précision des quantités Option Précision dynamique pour champs de quantité I Precisione quantità Precisione dinamica per campi quantità JA 数量精度 数量フィールドの動的精度 KO 수량 소수점이하 자리수 수량 필드에 대한 동적 소수점자리 PTB Precisão da Quantidade Precisão dinâmica para campos de quantidade RU Точность количества Динамическая точность для полей количества S Kvantitetsprecision Dynamisk noggrannhet för kvantitetsfält TR Miktar Duyarlılığı Miktar alanları için dinamik duyarlılık US Quantity Precision Dynamic precsion for qty fields ZHS 数量精确度 数量字段动态精确度 3 10 :p_from_resource LOV Oracle WIP_SRS_RESOURCES_OPT Y select resource_code id, resource_code value, null description from bom_resources where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by resource_code AR الموارد من الموارد من D Von Ressource Von Ressource E De Recurso De Recurso F Ressources - De Ressources - De I Risorse - Da Risorse - Da JA 生産資源:自 生産資源:自 KO 자원: 부터 자원: 부터 PTB Recursos - De Recursos - De RU Ресурсы с Ресурсы с S Från resurser Från resurser TR Kaynaklar, İlk Kaynaklar, İlk US Resources From Resources From ZHS 资源自 资源自 4 20 :p_to_resource LOV Oracle WIP_SRS_RESOURCES_OPT Y select resource_code id, resource_code value, null description from bom_resources where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by resource_code AR إلى الموارد إلى D Bis Bis Ressource E A A Recurso F A Ressources - A I A Risorse - A JA 至 生産資源:至 KO 까지 자원: 까지 PTB Até Recursos - até RU По Ресурсы по S Till Resurser till TR Son Son Kaynaklar US To Resources To ZHS 至 资源至 5 30 :p_from_department 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 Sections - De I Reparti - Da Reparti - Da JA 部門:自 部門:自 KO 부서: 부터 부서: 부터 PTB Deptos. - De Deptos. - De RU Отделы с Отделы с S Från avdelning Från avdelning TR Departmanlar, İlk Departmanlar, İlk US Departments From Departments From ZHS 部门自 部门自 6 40 :p_to_department 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 إلى 2 الأقسام إلى D Bis 2 Bis Abteilung E A 2 A Departamento F A 2 Sections - A I A 2 Reparti - A JA 至 2 部門:至 KO 까지 2 부서: 까지 PTB Até 2 Departamentos - até RU По 2 Отделы по S Till 2 Avdelningar till TR Son 2 Departmanlar: Son US To 2 Departments To ZHS 至 2 部门至 7 50 :p_from_date Date AR تواريخ سريان أوامر الشغل/الجداول من تواريخ سريان أوامر الشغل/الجداول من D Aufträge gültig von Aufträge gültig von E De F. Actividad Orden de Fabricación/Programa De F. Actividad Orden de Fabricación/Programa F Dates validité OF/Programme - Du Dates validité OF/Programme - Du I Date validità OdL/programma - Da Date validità OdL/programma - Da JA 製造オーダー有効日:自 製造オーダー有効日:自 KO 단속 작업/반복 스케줄 활동 일자: 부터 단속 작업/반복 스케줄 활동 일자: 부터 PTB Datas Ativas OP/Progr. - De Datas Ativas OP/Progr. - De RU Срок действия заданий/графиков с Срок действия заданий/графиков с S TO/plan aktiveringsdatum från TO/plan aktiveringsdatum från TR İş Emri/Çizelge Etkin Tarihleri Başlangıcı İş Emri/Çizelge Etkin Tarihleri Başlangıcı US Job/Schedule Active Dates From Job/Schedule Active Dates From ZHS 任务/计划有效日期自 任务/计划有效日期自 8 60 :p_to_date Date AR إلى 3 تواريخ سارية أوامر شغل/جدول إلي D Bis 3 Aufträge gültig bis E A 3 A Fecha Actividad Orden de Fabricación/Programa F A 3 Dates validité OF/Programme - Au I A 3 Date validità OdL/Programma - A JA 至 3 製造オーダーの有効日:至 KO 까지 3 단속 작업/반복 스케줄 활동 일자: 까지 PTB Até 3 Datas Ativas da OP/Programação - até RU По 3 Срок действия заданий/графиков по S Till 3 TO/plan aktiveringsdatum till TR Son 3 İş Emri/Çizelge Etkin Tarihler: Son US To 3 Job/Schedule Active Dates To ZHS 至 3 任务/计划有效终止日期 9 70 :p_minimum_efficiency Number AR الحد الأدنى للكفاءة الحد الأدنى للكفاءة D Mindesteffizienz Mindesteffizienz E Eficiencia Mínima Eficiencia Mínima F Productivité minimale Productivité minimale I Produttività minima Produttività minima JA 最小効率 最小効率 KO 최소 효율 최소 효율 PTB Eficiência Mínima Eficiência Mínima RU Минимальная эффективность Минимальная эффективность S Minsta effektivitet Minsta effektivitet TR Minimum Verimlilik Minimum Verimlilik US Minimum Efficiency Minimum Efficiency ZHS 最小效率 最小效率 10 80 :p_maximum_efficiency Number AR الحد الأقصى للكفاءة الحد الأقصى للكفاءة D Maximale Effizienz Maximale Effizienz E Eficiencia Máxima Eficiencia Máxima F Productivité optimale Productivité optimale I Produttività massima Produttività massima JA 最大効率 最大効率 KO 최대 효율 최대 효율 PTB Eficiência Máxima Eficiência Máxima RU Максимальная эффективность Максимальная эффективность S Högsta effektivitet Högsta effektivitet TR Maksimum Verimlilik Maksimum Verimlilik US Maximum Efficiency Maximum Efficiency ZHS 最大效率 最大效率