ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4729B51A9E05362FB09050512Y select wjsi.source_code , nvl(ood.organization_code, wjsi.organization_code) organization_code , nvl(we.wip_entity_name,wjsi.job_name) job_name , nvl(&P_FLEXDATA,' ') description , msi.inventory_item_id ,nvl(wjsi.status_type,wdj.status_type) status_type , nvl(wjsi.start_quantity,wdj.start_quantity) start_quantity , to_char(nvl(wjsi.first_unit_start_date,wdj.scheduled_start_date)) ||' '|| to_char(nvl(wjsi.first_unit_start_date,wdj.scheduled_start_date), 'HH24:MI') start_date , to_char(nvl(wjsi.last_unit_completion_date, wdj.scheduled_completion_date))||' '|| to_char(nvl(wjsi.last_unit_completion_date, wdj.scheduled_completion_date),'HH24:MI') completion_date ,wjsi.process_phase pphase , ml1.meaning process_phase , ml2.meaning process_status , wjsi.interface_id interface_id2, WIP_WIPMLINT_XMLP_PKG.c_status_typeformula(nvl ( wjsi.status_type , wdj.status_type )) C_STATUS_TYPE, WIP_WIPMLINT_XMLP_PKG.c_flexfield2formula() C_FLEXFIELD2, WIP_WIPMLINT_XMLP_PKG.c_fail_resformula() C_Fail_Res, WIP_WIPMLINT_XMLP_PKG.c_success_rescheduleformula(wjsi.process_phase) C_SUCCESS_RESCHEDULE from mtl_system_items msi , org_organization_definitions ood , mfg_lookups ml1 , mfg_lookups ml2 , wip_entities we , wip_job_schedule_interface wjsi , wip_discrete_jobs wdj where wjsi.load_type = 3 and msi.inventory_item_id(+)=we.primary_item_id and msi.organization_id(+)=we.organization_id and ood.organization_id(+)=wjsi.organization_id and ml1.lookup_code(+) = wjsi.process_phase and ml1.lookup_type(+) = 'WIP_ML_PROCESS_PHASE' and ml2.lookup_code(+) = wjsi.process_status and ml2.lookup_type(+) = 'WIP_PROCESS_STATUS' and wdj.wip_entity_id(+) = wjsi.wip_entity_id and wdj.organization_id(+) = wjsi.organization_id and we.wip_entity_id(+) = wjsi.wip_entity_id &C_GROUP_ID WIP WIPMLINT_XML AR WIP تقرير واجهة الجداول وأوامر الشغل (بتنسيق XML) Imported from BI Publisher Description: تقرير واجهة الجداول وأوامر الشغل Application: العمل في الإنجاز Source: تقرير واجهة الجداول وأوامر الشغل (بتنسيق XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG D WIP Fertigungsaufträge - Schnittstelle Imported from BI Publisher Description: Fertigungsaufträge - Schnittstelle Application: Fertigung Source: Fertigungsaufträge - Schnittstelle (XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG E WIP Interfaz de Órdenes de Fabricación y Programas Imported from BI Publisher Description: Informe de interfaz de órdenes de fabricación y programas Application: Work in Process Source: Interfaz de Órdenes de Fabricación y Programas (XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG F WIP Etat Interface OF et programmes répétitifs Imported from BI Publisher Description: Etat Interface OF et programmes répétitifs Application: Work In Process Source: Etat Interface OF et programmes répétitifs (XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG I WIP Rapporto Interfaccia OdL e programmi Imported from BI Publisher Description: Rapporto Interfaccia OdL e programmi Application: Work in Process Source: Rapporto Interfaccia OdL e programmi (XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG JA WIP 製造オーダー・インタフェース・レポート Imported from BI Publisher Description: 製造オーダー・インタフェース・レポート Application: Work in Process Source: 製造オーダー・インタフェース・レポート(XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG KO WIP 작업과 스케줄 인터페이스 보고서 Imported from BI Publisher Description: 작업과 스케줄 인터페이스 보고서 Application: Work in Process Source: 작업과 스케줄 인터페이스 보고서(XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG PTB WIP Relatório de Interface da Ordem de Produção e Programação Imported from BI Publisher Description: Relat. Interf. de Ordem de Produção e Programação Application: Work in Process Source: Relatório de Interface da Ordem de Produção e Programação (XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG RU WIP Отчет об интерфейсе заданий и графиков Imported from BI Publisher Description: Отчет об интерфейсе заданий и графиков Application: Незавершенное производство Source: Отчет об интерфейсе заданий и графиков (XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG S WIP Gränssnitt för TO och planer - rapport Imported from BI Publisher Description: Gränssnitt för TO och planer - rapport Application: Work in Process Source: Gränssnitt för TO och planer - rapport (XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG TR WIP İş Emri ve Çizelge Arayüz Raporu Imported from BI Publisher Description: İş Emri ve Çizelge Arayüz Raporu Application: Üretim İzleme Source: İş Emri ve Çizelge Arayüz Raporu (XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG US WIP Job and Schedule Interface Imported from BI Publisher Description: Job and Schedule Interface Report Application: Work in Process Source: Job and Schedule Interface Report (XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG ZHS WIP 任务和计划接口报表 Imported from BI Publisher Description: 任务和计划接口报表 Application: 在制品管理系统 Source: 任务和计划接口报表 (XML) Short Name: WIPMLINT_XML DB package: WIP_WIPMLINT_XMLP_PKG BI Publisher &c_group_id &p_flexdata :p_conc_request_id :p_debug :p_flexdata :p_group_id :p_include_warnings :p_qty_precision :qty_precision 1 -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 数量精确度 数量精确度 2 10 :p_group_id Number AR معرف المجموعة معرف المجموعة D Gruppenkennung Gruppenkennung E Id Grupo Id Grupo F ID groupe ID groupe I ID gruppo ID di gruppo JA グループID グループID KO 그룹 ID 그룹 ID PTB ID do Grupo ID do Grupo RU Идент. группы Идент. группы S Grupp-id Grupp-id TR Grup No Grup No US Group ID Group ID ZHS 组标识 组标识 3 20 :p_include_warnings LOV Oracle WIP_SRS_YES_NO_MAND 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 Mit Hinweisen Mit Hinweisen E Incluir Avisos Incluir Avisos F Inclure avertissements Inclure avertissements I Includi avvertenze Includi avvertenze JA 警告を含む 警告を含む KO 경고 포함 경고 포함 PTB Incluir Advertências Incluir Advertências RU Включение предупреждений Включение предупреждений S Inkludera varningar Inkludera varningar TR Uyarıları Dahil Et Uyarıları Dahil Et US Include Warnings Include Warnings ZHS 包括警告 包括警告