ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472AA51A9E05362FB09050512 SELECT WL.LINE_CODE Line, WL.Line_Id Line_Id, WL.DESCRIPTION Line_Descr, WL.DISABLE_DATE Line_Disable_Date, WL.MINIMUM_RATE Min_Rate, WL.MAXIMUM_RATE Max_Rate, WL.FIXED_THROUGHPUT Throughput, ML1.MEANING Sched_Base, WE.WIP_ENTITY_NAME Assembly, SI.DESCRIPTION Item_Descr, WRI.ALTERNATE_BOM_DESIGNATOR Alt_BOM, WRI.ALTERNATE_ROUTING_DESIGNATOR Alt_Routing, WRI.CLASS_CODE Rep_Class_Code, WRI.PRODUCTION_LINE_RATE Line_Speed, WRI.LOAD_DISTRIBUTION_PRIORITY Priority, ML2.MEANING Primary_Line, ML3.MEANING Supply_Type, WRI.COMPLETION_SUBINVENTORY Completion_Sub, DECODE(WRI.COMPLETION_LOCATOR_ID,NULL,NULL,&P_LOCATOR_DATA) C_LOCATOR_DATA, DECODE(WRI.COMPLETION_LOCATOR_ID,NULL,NULL,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_value', 'INV', 'MTLL', 101, IL.ORGANIZATION_ID, IL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE')) C_LOCATOR_VALUE FROM MFG_LOOKUPS ML3, MFG_LOOKUPS ML2, MFG_LOOKUPS ML1, MTL_SYSTEM_ITEMS SI, MTL_ITEM_LOCATIONS IL, WIP_REPETITIVE_ITEMS WRI, WIP_ENTITIES WE, WIP_LINES WL WHERE WL.ORGANIZATION_ID = :ORG_ID AND WRI.ORGANIZATION_ID (+) = :ORG_ID AND WE.ORGANIZATION_ID (+) = :ORG_ID AND WE.ENTITY_TYPE(+) = 2 AND WL.LINE_ID = WRI.LINE_ID (+) &C_Line_Limiter AND SI.ORGANIZATION_ID(+) = WRI.ORGANIZATION_ID AND WRI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID (+) AND WRI.PRIMARY_ITEM_ID = SI.INVENTORY_ITEM_ID (+) AND IL.ORGANIZATION_ID (+) = DECODE(WRI.ORGANIZATION_ID,WRI.ORGANIZATION_ID,:ORG_ID) AND WRI.COMPLETION_LOCATOR_ID = IL.INVENTORY_LOCATION_ID (+) AND ML1.LOOKUP_TYPE = 'WIP_LINE_SCHED_TYPE' AND ML1.LOOKUP_CODE = WL.LINE_SCHEDULE_TYPE AND ML2.LOOKUP_TYPE (+) = 'SYS_YES_NO' AND ML2.LOOKUP_CODE (+)= WRI.PRIMARY_LINE_FLAG AND ML3.LOOKUP_TYPE (+) = 'WIP_SUPPLY_SHORT' AND ML3.LOOKUP_CODE (+) = WRI.WIP_SUPPLY_TYPE ORDER BY 1 ASC,3 ASC,4 ASC,5 ASC,6 ASC,7 ASC,8 ASC,2 ASC , WE.WIP_ENTITY_NAME Y WIP WIPSULIN_XML AR WIP تقرير خط الإنتاج (بتنسيق XML) Imported from BI Publisher Description: تقرير خط الإنتاج Application: العمل في الإنجاز Source: تقرير خط الإنتاج (بتنسيق XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG D WIP Produktionslinien Imported from BI Publisher Description: Produktionslinien Application: Fertigung Source: Produktionslinien (XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG E WIP Líneas de Producción Imported from BI Publisher Description: Informe de líneas de producción Application: Work in Process Source: Líneas de Producción (XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG F WIP Etat Lignes de production Imported from BI Publisher Description: Etat Lignes de production Application: Work In Process Source: Etat Lignes de production (XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG I WIP Rapporto Linea di produzione Imported from BI Publisher Description: Rapporto Linea di produzione Application: Work in Process Source: Rapporto Linea di produzione (XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG JA WIP 生産ライン・レポート Imported from BI Publisher Description: 生産ライン・レポート Application: Work in Process Source: 生産ライン・レポート(XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG KO WIP 생산 라인 보고서 Imported from BI Publisher Description: 생산라인 보고서 Application: Work in Process Source: 생산 라인 보고서(XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG PTB WIP Relatório de Linha de Produção Imported from BI Publisher Description: Relatório Linha de Produção Application: Work in Process Source: Relatório de Linha de Produção (XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG RU WIP Отчет о производственных линиях Imported from BI Publisher Description: Отчет о производственных линиях Application: Незавершенное производство Source: Отчет о производственных линиях (XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG S WIP Produktionslinje - rapport Imported from BI Publisher Description: Produktionslinje - rapport Application: Work in Process Source: Produktionslinje - rapport (XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG TR WIP Üretim Hattı Raporu Imported from BI Publisher Description: Üretim Hattı Raporu Application: Üretim İzleme Source: Üretim Hattı Raporu (XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG US WIP Production Line Imported from BI Publisher Description: Production Line Report Application: Work in Process Source: Production Line Report (XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG ZHS WIP 生产线报表 Imported from BI Publisher Description: 生产线报表 Application: 在制品管理系统 Source: 生产线报表 (XML) Short Name: WIPSULIN_XML DB package: WIP_WIPSULIN_XMLP_PKG BI Publisher &c_line_limiter &p_locator_data :org_id :p_conc_request_id :p_debug :p_from_line :p_locator_data :p_to_line 1 -30 :org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف التنظيم معرف التنظيم D Organisation Organisationskennung E Id Org. Id Organización F ID org ID organisation I ID org. Id dell'organizzazione JA 組織ID 組織ID KO 조직 ID 조직 ID PTB Id da Org. ID da Organização RU Идент. орг. Идент. организации S Org.-id Organisations-id TR Org No Organizasyon No US Org Id Organization ID ZHS 组织标识 组织标识 2 -20 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR Quantity_precision دقة حقل الكمية D Quantity_precision Nachkommastellen E Quantity_precision precisión del campo Cantidad F Quantity_precision Précision du champ quantité I Quantity_precision Precisione campo quantità JA Quantity_precision 数量フィールド精度 KO Quantity_precision 수량 필드 소수점자리 PTB Quantity_precision Precisão do campo quantidade RU Quantity_precision Точность поля количества S Quantity_precision Kvantitetsfältsnoggrannhet TR Quantity_precision Miktar Alanı Duyarlılığı US Quantity_precision Quantity field precision ZHS Quantity_precision 数量字段精确度 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 Produktionslinie E De Línea De línea de producción F Lignes - De Ligne de production - De I Linee - Da Linea di produzione - Da JA ライン:自 生産ライン:自 KO 라인: 부터 생산 라인: 부터 PTB Linhas - De Linhas de Produção - De RU Линии с Производственные линии с S Från rader Från produktionsrad TR Hatlar, İlk İlk üretim hattı US Lines From From production line 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 Produktionslinie E A A línea de producción F A Ligne de production - A I A Linea di produzione - A JA 至 生産ライン:至 KO 까지 생산 라인: 까지 PTB Até Linhas de Produção - até RU По Производственные линии по S Till Till produktionsrad TR Son Son üretim hattı US To To production line ZHS 至 终止生产线