ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472A251A9E05362FB09050512 SELECT WL.LINE_CODE Line ,WL.LINE_ID Line_Id ,LU1.MEANING Scheduling_Base ,WL.MINIMUM_RATE Minimum_Daily_Rate ,TO_CHAR(TO_DATE(WL.START_TIME, 'SSSSS'), 'HH24:MI') Start_Time ,WL.DISABLE_DATE Disable_Date ,WL.FIXED_THROUGHPUT Leadtime_Hours ,WL.MAXIMUM_RATE Maximum_Daily_Rate ,TO_CHAR(TO_DATE(WL.STOP_TIME, 'SSSSS'), 'HH24:MI') Stop_Time ,WL.DESCRIPTION Description ,DECODE(RS.STATUS_TYPE, 13,2,1) Status_Group ,WE.WIP_ENTITY_NAME C_ASSY ,WE.DESCRIPTION Description1 ,MSI.PRIMARY_UOM_CODE UOM ,LU2.MEANING Status ,RS.DAILY_PRODUCTION_RATE Rate ,RS.PROCESSING_WORK_DAYS Days ,(RS.DAILY_PRODUCTION_RATE * RS.PROCESSING_WORK_DAYS) Quantity ,TO_CHAR(RS.FIRST_UNIT_START_DATE,'DD-MON-YY') fus_date ,TO_CHAR(RS.FIRST_UNIT_START_DATE,'HH24:MI') fus_Time ,TO_CHAR(RS.LAST_UNIT_COMPLETION_DATE,'DD-MON-YY') luc_date ,TO_CHAR(RS.LAST_UNIT_COMPLETION_DATE,'HH24:MI') luc_Time ,RS.QUANTITY_COMPLETED Completed FROM MFG_LOOKUPS LU1 ,WIP_REPETITIVE_SCHEDULES RS ,WIP_REPETITIVE_ITEMS RI ,MFG_LOOKUPS LU2 ,MTL_SYSTEM_ITEMS MSI ,WIP_ENTITIES WE ,WIP_LINES WL WHERE WL.ORGANIZATION_ID = :P_ORGANIZATION_ID &C_Limit_Lines AND LU1.LOOKUP_TYPE = 'WIP_LINE_SCHED_TYPE' AND LU1.LOOKUP_CODE = WL.LINE_SCHEDULE_TYPE AND RS.ORGANIZATION_ID = :P_ORGANIZATION_ID AND RS.LINE_ID = WL.LINE_ID AND WE.ENTITY_TYPE = 2 AND RS.STATUS_TYPE IN (1,3,4,6,13) &C_Limit_Dates AND RI.ORGANIZATION_ID = :P_ORGANIZATION_ID AND RI.LINE_ID = WL.LINE_ID AND RI.WIP_ENTITY_ID = RS.WIP_ENTITY_ID AND MSI.ORGANIZATION_ID = RI.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = RI.PRIMARY_ITEM_ID AND WE.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WE.WIP_ENTITY_ID = RS.WIP_ENTITY_ID &C_Limit_Assemblies AND LU2.LOOKUP_TYPE = 'WIP_JOB_STATUS' AND LU2.LOOKUP_CODE = RS.STATUS_TYPE ORDER BY WL.LINE_CODE, DECODE(RS.STATUS_TYPE, 13,2,1), RS.FIRST_UNIT_START_DATE, RS.LAST_UNIT_COMPLETION_DATE, WE.WIP_ENTITY_NAME Y WIP WIPRELIN_XML AR WIP تقرير السطر التكراري (بتنسيق XML) Imported from BI Publisher Description: تقرير السطر التكراري Application: العمل في الإنجاز Source: تقرير السطر التكراري (بتنسيق XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG D WIP Linienaufträge nach Linie Imported from BI Publisher Description: Linienaufträge nach Linie Application: Fertigung Source: Linienaufträge nach Linie (XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG E WIP Líneas Repetitivas Imported from BI Publisher Description: Informe de líneas repetitivas Application: Work in Process Source: Líneas Repetitivas (XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG F WIP Etat Lignes répétitives Imported from BI Publisher Description: Etat Lignes répétitives Application: Work In Process Source: Etat Lignes répétitives (XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG I WIP Rapporto Linea di produzione ripetitiva Imported from BI Publisher Description: Rapporto Linea di produzione ripetitiva Application: Work in Process Source: Rapporto Linea di produzione ripetitiva (XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG JA WIP ライン型製造オーダー・ライン・レポート Imported from BI Publisher Description: ライン型製造オーダー・ライン・レポート Application: Work in Process Source: ライン型製造オーダー・ライン・レポート(XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG KO WIP 반복 라인 보고서 Imported from BI Publisher Description: 반복 라인 보고서 Application: Work in Process Source: 반복 라인 보고서(XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG PTB WIP Relatório de Linhas Repetitivas Imported from BI Publisher Description: Rel.Linhas Repetitivas Application: Work in Process Source: Relatório de Linhas Repetitivas (XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG RU WIP Отчет о линиях серийного производства Imported from BI Publisher Description: Отчет о линиях серийного производства Application: Незавершенное производство Source: Отчет о линиях серийного производства (XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG S WIP Repetitiv linje - rapport Imported from BI Publisher Description: Repetitiv linje - rapport Application: Work in Process Source: Repetitiv linje - rapport (XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG TR WIP Seri Üretim Hattı Raporu Imported from BI Publisher Description: Seri Üretim Hattı Raporu Application: Üretim İzleme Source: Seri Üretim Hattı Raporu (XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG US WIP Repetitive Line Imported from BI Publisher Description: Repetitive Line Report Application: Work in Process Source: Repetitive Line Report (XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG ZHS WIP 重复生产线报表 Imported from BI Publisher Description: 重复生产线报表 Application: 在制品管理系统 Source: 重复生产线报表 (XML) Short Name: WIPRELIN_XML DB package: WIP_WIPRELIN_XMLP_PKG BI Publisher &c_limit_assemblies &c_limit_dates &c_limit_lines :p_conc_request_id :p_debug :p_from_date :p_from_job :p_from_line :p_organization_id :p_qty_precision :p_to_date :p_to_job :p_to_line :qty_precision 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_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 Lignes - De I Linee - Da Linee - Da JA ライン:自 ライン:自 KO 라인: 부터 라인: 부터 PTB Linhas - De Linhas - De RU Линии с линии с S Från rader Rader från TR Hatlar, İlk Hat başlangıcı US Lines From lines from ZHS 生产线自 生产线自 4 20 :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 إلى سطور إلى D Bis Bis Linie E A a línea F A Lignes - A I A Linee - A JA 至 ライン:至 KO 까지 라인: 까지 PTB Até Linhas - até RU По линии по S Till rader till TR Son Hat bitişi US To lines to ZHS 至 生产线至 5 30 :p_from_job LOV Oracle WIP_SRS_REP_SCHEDULES_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') and entity_type=2 order by wip_entity_name AR المنتجات من المنتجات من D Von Baugruppe Von Baugruppe E De Conjunto de conjunto F Produits - De Produits - De I Assiemi - Da Assiemi - Da JA 組立:自 組立:自 KO 조립품: 부터 조립품: 부터 PTB Montagens - De Montagens - De RU Сборки с сборки с S Från produkter produkter från TR Ürünler: İlk ürünler: ilk US Assemblies From assemblies from ZHS 装配件自 装配件自 6 40 :p_to_job LOV Oracle WIP_SRS_REP_SCHEDULES_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') and entity_type=2 order by wip_entity_name AR إلى 2 المنتجات إلى D Bis 2 Bis Baugruppe E A 2 a conjunto F A 2 Produits - A I A 2 Assiemi - A JA 至 2 組立:至 KO 까지 2 조립품: 까지 PTB Até 2 Montagens - De RU По 2 сборки по S Till 2 produkter till TR Son 2 son ürünler US To 2 assemblies to ZHS 至 2 装配件至 7 50 :p_from_date Date AR التواريخ من التواريخ من D Datum von Datum von E De Fecha de fecha F Dates - Du Dates - Du I Date - Da Date - Da JA 日付:自 日付:自 KO 일자: 부터 일자: 부터 PTB Datas - De Datas - De RU Даты с даты с S Från datum Datum från TR Tarihler, İlk tarihler: ilk US Dates From dates from ZHS 日期自 起始日期 8 60 :p_to_date Date AR إلى 3 التواريخ إلى D Bis 3 Bis E A 3 a fecha F A 3 Dates - Au I A 3 Date - A JA 至 3 日付:至 KO 까지 3 일자: 까지 PTB Até 3 Datas - De RU По 3 даты по S Till 3 datum till TR Son 3 Başlangıç Tarihi US To 3 dates to ZHS 至 3 终止日期