ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4729451A9E05362FB09050512Y SELECT TO_CHAR(WO.FIRST_UNIT_START_DATE) Sched_Op_Start_Date, TO_CHAR(WO.FIRST_UNIT_START_DATE, 'HH24:MI') Sched_Op_Start_Time, TO_CHAR(WO.LAST_UNIT_COMPLETION_DATE) Sched_Op_Completion_Date, TO_CHAR(WO.LAST_UNIT_COMPLETION_DATE,'HH24:MI') Sched_Op_Completion_Time, BD.DEPARTMENT_CODE Dept_Name, BD.DESCRIPTION Dept_Description, DJ.SCHEDULED_COMPLETION_DATE Sched_Job_Complete_Date, WE.WIP_ENTITY_NAME Job_Name, DECODE(WE.PRIMARY_ITEM_ID,NULL,NULL,&P_ITEM_DATA) C_ITEM_DATA, WO.OPERATION_SEQ_NUM Op_Seq, WO.DESCRIPTION Op_Description, WO.SCHEDULED_QUANTITY Quantity_Scheduled, WO.QUANTITY_COMPLETED Quantity_Completed, WO.QUANTITY_IN_QUEUE Quantity_In_Queue, WO.QUANTITY_RUNNING Quantity_Running, WO.WIP_ENTITY_ID we_id, DJ.STATUS_TYPE Status_Type, DJ.BUILD_SEQUENCE Build_Sequence, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, SI.ORGANIZATION_ID, SI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_ITEM_VALUE, WIP_WIPDJDSP_XMLP_PKG.C_quantity_in_prevFormula(WO.WIP_ENTITY_ID,WO.OPERATION_SEQ_NUM) C_quantity_in_prev, --&quantity_rem_in_prev C_quantity_in_prev, --decode(DJ.STATUS_TYPE,1,WO.SCHEDULED_QUANTITY,(WO.QUANTITY_IN_QUEUE+WO.QUANTITY_RUNNING+WIP_WIPDJDSP_XMLP_PKG.C_quantity_in_prevFormula(WO.WIP_ENTITY_ID,WO.OPERATION_SEQ_NUM))) Quantity_remaining, decode(DJ.STATUS_TYPE,1,WO.SCHEDULED_QUANTITY,(nvl(WO.QUANTITY_IN_QUEUE,0)+nvl(WO.QUANTITY_RUNNING,0)+nvl(WIP_WIPDJDSP_XMLP_PKG.C_quantity_in_prevFormula(WO.WIP_ENTITY_ID,WO.OPERATION_SEQ_NUM),0))) Quantity_remaining, --WIP_WIPDJDSP_XMLP_PKG.quantity_remainingformula(DJ.STATUS_TYPE, WO.SCHEDULED_QUANTITY, WO.QUANTITY_IN_QUEUE, WO.QUANTITY_RUNNING, WIP_WIPDJDSP_XMLP_PKG.C_quantity_in_prevFormula(WO.WIP_ENTITY_ID,WO.OPERATION_SEQ_NUM)) Quantity_remaining, WIP_WIPDJDSP_XMLP_PKG.quantity_rem_in_prev_p quantity_rem_in_prev FROM MTL_SYSTEM_ITEMS SI, WIP_SCHEDULE_GROUPS SG, WIP_ENTITIES WE, WIP_DISCRETE_JOBS DJ, BOM_DEPARTMENTS BD, WIP_OPERATIONS WO WHERE WO.ORGANIZATION_ID = :ORG_ID AND BD.ORGANIZATION_ID = :ORG_ID AND WE.ORGANIZATION_ID = :ORG_ID AND SG.SCHEDULE_GROUP_ID &P_SG_OUTER = DJ.SCHEDULE_GROUP_ID AND SG.ORGANIZATION_ID &P_SG_OUTER = DJ.ORGANIZATION_ID AND DJ.ORGANIZATION_ID = :ORG_ID AND SI.ORGANIZATION_ID (+) = :ORG_ID &C_Date_Limiter &C_Depart_Limiter &C_Schedule_Group AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID AND WO.WIP_ENTITY_ID = DJ.WIP_ENTITY_ID AND WE.PRIMARY_ITEM_ID = SI.INVENTORY_ITEM_ID (+) AND WE.WIP_ENTITY_ID = DJ.WIP_ENTITY_ID AND WE.ENTITY_TYPE = 1 &C_Status_Limiter AND WO.SCHEDULED_QUANTITY > WO.QUANTITY_COMPLETED &Order_By WIP WIPDJDSP_XML AR WIP تقرير إرسال أوامر الشغل المنفصلة (بتنسيق XML) Imported from BI Publisher Description: تقرير إرسال أمر الشغل المنفصل Application: العمل في الإنجاز Source: تقرير إرسال أوامر الشغل المنفصلة (بتنسيق XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG D WIP Diskrete Aufträge - Termine Imported from BI Publisher Description: Diskrete Aufträge - Termine Application: Fertigung Source: Diskrete Aufträge - Termine (XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG E WIP Despacho de Órdenes de Fabricación Discretas Imported from BI Publisher Description: Informe de despacho de órdenes de fabricación discretas Application: Work in Process Source: Despacho de Órdenes de Fabricación Discretas (XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG F WIP Etat Répartition des OF par section Imported from BI Publisher Description: Etat Répartition des OF par section Application: Work In Process Source: Etat Répartition des OF par section (XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG I WIP Rapporto Invio OdL discreti Imported from BI Publisher Description: Rapporto Invio OdL discreti Application: Work in Process Source: Rapporto Invio OdL discreti (XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG JA WIP ショップ型製造オーダー作業手配レポート Imported from BI Publisher Description: ショップ型製造オーダー作業手配レポート Application: Work in Process Source: ショップ型製造オーダー作業手配レポート(XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG KO WIP 단속 작업 배치 보고서 Imported from BI Publisher Description: 단속 작업 배치 보고서 Application: Work in Process Source: 단속 작업 배치 보고서(XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG PTB WIP Relatório de Despacho da Ordem de Produção Discreta Imported from BI Publisher Description: Rel. Despacho Ord.Prod.Disc. Application: Work in Process Source: Relatório de Despacho da Ordem de Produção Discreta (XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG RU WIP Отчет об отправке отдельных заданий Imported from BI Publisher Description: Отчет об отправке отдельных заданий Application: Незавершенное производство Source: Отчет об отправке отдельных заданий (XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG S WIP TO-utleverans - rapport Imported from BI Publisher Description: TO-utleverans - rapport Application: Work in Process Source: TO-utleverans - rapport (XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG TR WIP Kesikli İş Emri Tamamlanacaklar Raporu Imported from BI Publisher Description: Kesikli İş Emri Tamamlanacaklar Raporu Application: Üretim İzleme Source: Kesikli İş Emri Tamamlanacaklar Raporu (XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG US WIP Discrete Job Dispatch Imported from BI Publisher Description: Discrete Job Dispatch Report Application: Work in Process Source: Discrete Job Dispatch Report (XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG ZHS WIP 离散任务调度报表 Imported from BI Publisher Description: 离散任务调度报表 Application: 在制品管理系统 Source: 离散任务调度报表 (XML) Short Name: WIPDJDSP_XML DB package: WIP_WIPDJDSP_XMLP_PKG BI Publisher &c_date_limiter &c_depart_limiter &c_schedule_group &c_status_limiter &order_by &p_item_data &p_sg_outer &quantity_rem_in_prev :from_date :item_id_flex_num :org_id :p_conc_request_id :p_debug :p_from_dept :p_include_unrelease :p_item_data :p_qty_precision :p_schedule_group :p_sg_outer :p_to_dept :qty_precision :quantity_rem_in_prev :sort_code :to_date 1 -30 :org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y US Org_Id Organization_Id 2 -20 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة حقل الكمية دقة حقل الكمية D Nachkommastellen Nachkommastellen E Precisión del Campo Cantidad Precisión del Campo Cantidad F Précision du champ quantité Précision du champ quantité I Precisione campo quantità Precisione campo quantità JA 数量フィールド精度 数量フィールド精度 KO 수량 필드 소수점자리 수량 필드 소수점자리 PTB Precisão do Campo Quantidade Precisão do Campo Quantidade RU Точность поля количества Точность поля количества S Kvantitetsfältsprecision Kvantitetsfältsprecision TR Miktar Alanı Duyarlılığı Miktar Alanı Duyarlılığı US Quantity Field Precision Quantity Field Precision ZHS 数量字段精确度 数量字段精确度 3 10 :sort_code LOV Oracle WIP_SRS_DISPATCH_SORT_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_REP_SRW_SORT' and lookup_code in (7,8) order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'WIP_REP_SRW_SORT' AND LOOKUP_CODE = 7 Y AR فرز بواسطة خيار الفرز D Sortieren nach Sortieroption E Ordenar por Opción de Ordenación F Tri par Option de tri I Ordina per Opzione di ordinamento JA ソート・キー ソート・オプション KO 정렬 기준 정렬 옵션 PTB Classificar por Opção de Classificação RU Сортировка Параметр сортировки S Sortera efter Sorteringsalternativ TR Sıralama Ölçütü Sıralama Seçeneği US Sort By Sort Option ZHS 排序依据 排序选项 4 20 :p_include_unrelease 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 nicht freigegebenen Aufträgen Mit nicht freigegebenen Aufträgen E Incluir Órdenes de Fabricación No Liberadas Incluir Órdenes de Fabricación No Liberadas F Inclure OF non lancés Inclure OF non lancés I Includi OdL non rilasciati Includi OdL non rilasciati JA 未発行製造オーダーを含む 未発行製造オーダーを含む KO 릴리즈 안된 작업 포함 릴리즈 안된 작업 포함 PTB Incluir Ordens de Produção Não Liberadas Incluir Ordens de Produção Não Liberadas RU Включение непереданных заданий Включение непереданных заданий S Inkludera ej frisläppta TO Inkludera ej frisläppta TO TR Yayınlanmamış İş Emirlerini Dahil Et Yayınlanmamış İş Emirlerini Dahil Et US Include Unreleased Jobs Include Unreleased Jobs ZHS 包括未发放任务 包括未发放任务 5 30 :p_from_dept 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 Rango de Departamentos F Sections - De Fourchette de sections - De I Reparti - Da Intervallo reparti - Da JA 部門:自 部門範囲:自 KO 부서: 부터 부서 범위: 부터 PTB Deptos. - De Faixa de Departamentos - De RU Отделы с Нижняя граница диапазона отделов S Från avdelning Avdelningsintervall från TR Departmanlar, İlk Departman Aralığı Başlangıcı US Departments From Departments Range From ZHS 部门自 部门范围自 6 40 :p_to_dept 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 Bis Bis Abteilung E A A Rango de Departamentos F A Fourchette de sections - A I A Intervallo reparti - A JA 至 部門範囲:至 KO 까지 부서 범위: 까지 PTB Até Faixa de Departamentos - até RU По Верхняя граница диапазона отделов S Till Avdelningsintervall till TR Son Departman Aralığı Başlangıcı US To Departments Range To ZHS 至 部门范围至 7 50 :from_date Date AR التواريخ من مدى التواريخ من D Datum von Datum von E De Fecha De Rango de Fechas F Dates - Du Fourchette de dates - Du I Date - Da Intervallo date - Da JA 日付:自 期間:自 KO 일자: 부터 일자 범위: 부터 PTB Datas - De Faixa de Ordens de Produção - De RU Даты с Нижняя граница диапазона дат S Från datum Datumintervall från TR Tarihler, İlk Tarih Aralığı Başlangıcı US Dates From Dates Range From ZHS 日期自 日期范围自 8 60 :to_date Date AR إلى 2 مدى التواريخ إلى D Bis 2 Datum bis E A 2 A Rango de Fechas F A 2 Fourchette de dates - Au I A 2 Intervallo date - A JA 至 2 期間:至 KO 까지 2 일자 범위: 까지 PTB Até 2 Faixa de Datas - até RU По 2 Верхняя граница диапазона дат S Till 2 Datumintervall till TR Son 2 Tarih Aralığı Bitişi US To 2 Dates Range To ZHS 至 2 日期范围至 9 70 :p_schedule_group LOV Oracle WIP_SRS_SCHEDULE_GROUPS Y select wsg.schedule_group_name id, wsg.schedule_group_name value, null description from wip_schedule_groups wsg where wsg.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by schedule_group_name AR مجموعة الجدول مجموعة الجدول D Planungsgruppe Planungsgruppe E Grupo de Programas Grupo de Programas F Groupe de planification Groupe de planification I Gruppo di programmi Gruppo di programmi JA 計画グループ 計画グループ KO 스케줄 그룹 스케줄 그룹 PTB Grupo de Programações Grupo de Programações RU Группа планирования Группа планирования S Schemagrupp Schemagrupp TR Çizelge Grubu Çizelge Grubu US Schedule Group Schedule Group ZHS 计划组 计划组