ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472AD51A9E05362FB09050512Y SELECT &P_FLEXDATA C_FLEXDATA , DECODE(:P_SORT,1,&P_FLEXDATA,'X') C_FLEXDATA_MASTER , WT.TRANSACTION_DATE , DECODE(:P_SORT,2,WT.TRANSACTION_DATE,SYSDATE) DATE_MASTER , BR.RESOURCE_CODE , WE.WIP_ENTITY_NAME , WL.LINE_CODE , WT.OPERATION_SEQ_NUM , WT.RESOURCE_SEQ_NUM , BD.DEPARTMENT_CODE , WT.TRANSACTION_QUANTITY , WT.TRANSACTION_UOM , WT.PRIMARY_QUANTITY , WT.PRIMARY_UOM , CA.ACTIVITY , NVL(HRE.FULL_NAME,' ') , DECODE(:P_SORT,3,NVL(HRE.FULL_NAME,' '),'X') EMP_MASTER , NVL(WE.PRIMARY_ITEM_ID,-1) ITEM_ID , DECODE(:P_SORT,1,NVL(WE.PRIMARY_ITEM_ID,-1),1) ITEM_ID_MASTER , MTR.REASON_NAME , WT.REFERENCE , MSI.DESCRIPTION , DECODE(:P_SORT,1,MSI.DESCRIPTION,'X') DESC_MASTER, NVL2(MSI.inventory_item_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_master_sort', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE'),NULL) C_FLEX_MASTER_SORT, NVL2(MSI.inventory_item_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_assembly_master', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'),NULL) C_ASSEMBLY_MASTER, NVL2(MSI.inventory_item_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_assembly2', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'),NULL) C_ASSEMBLY2 FROM MTL_SYSTEM_ITEMS_VL MSI , BOM_RESOURCES BR , BOM_DEPARTMENTS BD , WIP_ENTITIES WE , WIP_LINES WL , CST_ACTIVITIES CA , PER_PEOPLE_F HRE , MTL_TRANSACTION_REASONS MTR , WIP_TRANSACTIONS WT WHERE WT.ORGANIZATION_ID = :P_ORGANIZATION_ID &C_Limit_Dates AND BR.RESOURCE_ID = WT.RESOURCE_ID &C_Limit_Resource AND BD.DEPARTMENT_ID = WT.DEPARTMENT_ID AND WE.WIP_ENTITY_ID = WT.WIP_ENTITY_ID AND WE.ORGANIZATION_ID = :P_ORGANIZATION_ID &C_Limit_Jobs AND WL.LINE_ID(+) = WT.LINE_ID AND WL.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID &C_Limit_Lines AND CA.ACTIVITY_ID(+) = WT.ACTIVITY_ID &C_Limit_Activities AND HRE.PERSON_ID(+) = WT.EMPLOYEE_ID &C_Limit_Emp AND MTR.REASON_ID(+) = WT.REASON_ID &C_Limit_Reasons AND MSI.INVENTORY_ITEM_ID(+) = WE.PRIMARY_ITEM_ID AND MSI.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE(+) AND HRE.EFFECTIVE_END_DATE(+) --&C_Limit_Assemblies and &P_FLEXWHERE ORDER BY C_FLEX_MASTER_SORT,17 ASC,5 ASC , /*to_date ( to_char ( WT.TRANSACTION_DATE ) , 'DD-MON-RR HH24:MI' ) , */ to_char ( WT.TRANSACTION_DATE ,'DD-MON-RR HH24:MI'), --removed to_date to fix the bug 10273317 WE.WIP_ENTITY_NAME , WL.LINE_CODE , WT.OPERATION_SEQ_NUM , WT.RESOURCE_SEQ_NUM , WT.CREATION_DATE , WT.TRANSACTION_ID /*ORDER BY to_date(to_char (WT.TRANSACTION_DATE), 'DD-MON-RR HH24:MI') , WE.WIP_ENTITY_NAME , WL.LINE_CODE , WT.OPERATION_SEQ_NUM , WT.RESOURCE_SEQ_NUM , WT.CREATION_DATE , WT.TRANSACTION_ID*/ WIP WIPTRTXN_XML AR WIP تقرير حركة المورد (بتنسيق XML) Imported from BI Publisher Description: تقرير حركة المورد Application: العمل في الإنجاز Source: تقرير حركة المورد (بتنسيق XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG D WIP Ressourcentransaktionen Imported from BI Publisher Description: Ressourcentransaktionen Application: Fertigung Source: Ressourcentransaktionen (XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG E WIP Transacciones de Recursos Imported from BI Publisher Description: Informe de transacciones de recursos Application: Work in Process Source: Transacciones de Recursos (XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG F WIP Etat Mouvements de ressources Imported from BI Publisher Description: Etat Mouvements de ressources Application: Work In Process Source: Etat Mouvements de ressources (XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG I WIP Rapporto Transazione risorse Imported from BI Publisher Description: Rapporto Transazione risorse Application: Work in Process Source: Rapporto Transazione risorse (XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG JA WIP 生産資源取引レポート Imported from BI Publisher Description: 生産資源取引レポート Application: Work in Process Source: 生産資源取引レポート(XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG KO WIP 자원 트랜잭션 보고서 Imported from BI Publisher Description: 자원 트랜잭션 보고서 Application: Work in Process Source: 자원 트랜잭션 보고서(XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG PTB WIP Relatório de Transações de Recurso Imported from BI Publisher Description: Relatório Transações de Recurso Application: Work in Process Source: Relatório de Transações de Recurso (XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG RU WIP Отчет об транзакциях с ресурсами Imported from BI Publisher Description: Отчет об транзакциях с ресурсами Application: Незавершенное производство Source: Отчет об транзакциях с ресурсами (XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG S WIP Resurstransaktion - rapport Imported from BI Publisher Description: Resurstransaktion - rapport Application: Work in Process Source: Resurstransaktion - rapport (XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG TR WIP Kaynak İşlem Raporu Imported from BI Publisher Description: Kaynak İşlem Raporu Application: Üretim İzleme Source: Kaynak İşlem Raporu (XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG US WIP Resource Transaction Imported from BI Publisher Description: Resource Transaction Report Application: Work in Process Source: Resource Transaction Report (XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG ZHS WIP 资源事务处理报表 Imported from BI Publisher Description: 资源事务处理报表 Application: 在制品管理系统 Source: 资源事务处理报表 (XML) Short Name: WIPTRTXN_XML DB package: WIP_WIPTRTXN_XMLP_PKG BI Publisher &c_limit_activities &c_limit_assemblies &c_limit_dates &c_limit_emp &c_limit_jobs &c_limit_lines &c_limit_reasons &c_limit_resource &p_flexdata &p_flexwhere :p_conc_request_id :p_debug :p_flexdata :p_flexwhere :p_from_activity :p_from_assembly :p_from_date :p_from_date1 :p_from_employee :p_from_job :p_from_line :p_from_reason :p_from_resource :p_organization_id :p_qty_precision :p_show_details :p_sort :p_to_activity :p_to_assembly :p_to_date :p_to_date1 :p_to_employee :p_to_job :p_to_line :p_to_reason :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_sort LOV Oracle WIP_SRS_RES_TXN_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 (1,2,3) order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'WIP_REP_SRW_SORT' AND LOOKUP_CODE = 1 Y AR فرز بواسطة خيار فرز التقرير D Sortieren nach Sortieroption E Ordenar por opción de clasificación de informe F Tri par Option de tri d'état I Ordina per Opzione ordinamento rapporto JA ソート・キー レポート・ソート・オプション KO 정렬 기준 보고서 정렬 옵션 PTB Classificar por opção de classificação de relatório RU Сортировка параметр сортировки отчета S Sortera efter Sorteringsalternativ för rapport TR Sıralama Ölçütü rapor sıralama seçeneği US Sort By report sort option ZHS 排序依据 报表排序选项 4 20 :p_show_details 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 = 1 Y AR إظهار التفاصيل عرض بالتفاصيل D Details anzeigen Detail anzeigen E Mostrar Detalles visualizar en detalle F Afficher détails Afficher en détail I Mostra dettagli Visualizza in dettaglio JA 詳細の表示 詳細に表示 KO 상세내역 표시 상세 표시 PTB Mostrar Detalhes exibir em detalhes RU Отображение сведений Подробное отображение S Visa detaljer visa i detalj TR Detayları Göster detaylı olarak görüntüle US Show Details display in detail ZHS 显示详细信息 以详细资料显示 5 30 :p_from_job LOV Oracle WIP_SRS_ALL_ENTITIES_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') order by wip_entity_name AR أوامر الشغل/الجداول من أوامر شغل/جداول من D Von Fertigungsauftrag Von Fertigungsauftrag E De Orden de Fabricación/Programa de orden de fabricación/programa F OF/Programmes - De OF/Programmes - De I OdL/programmi - Da OdL/Programmi - Da JA 製造オーダー:自 製造オーダー:自 KO 단속 작업/반복 스케줄: 부터 단속 작업/반복 스케줄: 부터 PTB Ordens de Produção/Programações De OPs/Programações - De RU Задания/графики с задания/графики с S Från TO/planer TO/planer från TR İş Emirleri/Çizelgeler, İlk iş emirleri/çizelgeler: ilk US Jobs/Schedules From jobs/schedules from ZHS 任务/计划自 任务/计划自 6 40 :p_to_job LOV Oracle WIP_SRS_ALL_ENTITIES_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') order by wip_entity_name AR إلى أوامر شغل/جداول إلى D Bis Bis Fertigungsauftrag E A a orden de fabricación/programa F A OF/Programmes - A I A OdL/Programmi - A JA 至 製造オーダー:至 KO 까지 단속 작업/반복 스케줄: 까지 PTB Até OPs/Programações - até RU По задания/графики по S Till TO/planer till TR Son iş emirleri/çizelgeler: son US To jobs/schedules to ZHS 至 任务/计划至 7 50 :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 Resurser från TR Kaynaklar, İlk ilk kaynaklar US Resources From resources from ZHS 资源自 资源自 8 60 :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 إلى 2 الموارد إلى D Bis 2 Bis Ressource E A 2 a recurso F A 2 Ressources - A I A 2 Risorse - A JA 至 2 生産資源:至 KO 까지 2 자원: 까지 PTB Até 2 Recursos - até RU По 2 ресурсы по S Till 2 resurser till TR Son 2 kaynaklar: son US To 2 resources to ZHS 至 2 资源至 9 70 :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 生产线自 生产线自 10 80 :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 إلى 3 سطور إلى D Bis 3 Bis Linie E A 3 a línea F A 3 Lignes - A I A 3 Linee - A JA 至 3 ライン:至 KO 까지 3 라인: 까지 PTB Até 3 Linhas - até RU По 3 линии по S Till 3 rader till TR Son 3 Hat bitişi US To 3 lines to ZHS 至 3 生产线至 11 90 :p_from_assembly Char 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 装配件自 装配件自 12 100 :p_to_assembly Char AR إلى 4 المنتجات إلى D Bis 4 Bis Baugruppe E A 4 a conjunto F A 4 Produits - A I A 4 Assiemi - A JA 至 4 組立:至 KO 까지 4 조립품: 까지 PTB Até 4 Montagens - De RU По 4 сборки по S Till 4 produkter till TR Son 4 son ürünler US To 4 assemblies to ZHS 至 4 装配件至 13 110 :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 日期自 起始日期 14 120 :p_to_date Date AR إلى 5 التواريخ إلى D Bis 5 Bis E A 5 a fecha F A 5 Dates - Au I A 5 Date - A JA 至 5 日付:至 KO 까지 5 일자: 까지 PTB Até 5 Datas - De RU По 5 даты по S Till 5 datum till TR Son 5 Başlangıç Tarihi US To 5 dates to ZHS 至 5 终止日期 15 130 :p_from_employee LOV Oracle WIP_SRS_EMPLOYEES_OPT Y select full_name id, full_name value, null description from mtl_employees_view where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by full_name AR الموظفون من الموظفون من D Von Mitarbeiter Von Mitarbeiter E De Empleado de empleado F Employés - De Employés - De I Dipendenti da Dipendenti - Da JA 従業員:自 従業員:自 KO 사원: 부터 사원: 부터 PTB Funcionários - De Funcionários - De RU Работники с работники с S Anställda från anställda från TR Çalışanlar, İlk çalışanlar: ilk US Employees From employees from ZHS 员工自 员工自 16 140 :p_to_employee LOV Oracle WIP_SRS_EMPLOYEES_OPT Y select full_name id, full_name value, null description from mtl_employees_view where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by full_name AR إلى 6 الموظفون إلى D Bis 6 Bis Mitarbeiter E A 6 a empleado F A 6 Employés - A I A 6 Dipendenti - A JA 至 6 従業員:至 KO 까지 6 사원: 까지 PTB Até 6 Funcionários - até RU По 6 работники по S Till 6 anställda till TR Son 6 çalışanlar: son US To 6 employees to ZHS 至 6 员工至 17 150 :p_from_reason LOV Oracle WIP_SRS_REASONS_OPT Y select reason_name id, reason_name value, null description from mtl_transaction_reasons order by reason_name AR الأسباب من الأسباب من D Von Grund Von Grund E De Motivo de motivo F Motifs - De Motifs - De I Motivi da Motivi - Da JA 事由:自 事由:自 KO 사유: 부터 사유: 부터 PTB Motivos - De Motivos - De RU Основания с основания с S orsaker från orsaker från TR Nedenler, İlk nedenler: ilk US Reasons From reasons from ZHS 原因自 原因自 18 160 :p_to_reason LOV Oracle WIP_SRS_REASONS_OPT Y select reason_name id, reason_name value, null description from mtl_transaction_reasons order by reason_name AR إلى 7 الأسباب إلى D Bis 7 Bis Grund E A 7 a motivo F A 7 Motifs - A I A 7 Motivi - A JA 至 7 事由:至 KO 까지 7 사유: 까지 PTB Até 7 Motivos - até RU По 7 основания по S Till 7 orsaker till TR Son 7 nedenler: son US To 7 reasons to ZHS 至 7 原因至 19 170 :p_from_activity LOV Oracle WIP_SRS_ACTIVITIES_OPT Y select activity id, activity value, null description from cst_activities where (organization_id is null or organization_id= fnd_profile.value('MFG_ORGANIZATION_ID')) order by activity AR الأنشطة من الأنشطة من D Von Prozess Von Prozess E De Actividad de actividad F Activités - De Activités - De I Attività da Attività - Da JA 活動:自 活動:自 KO 활동: 부터 활동: 부터 PTB Atividades - De Atividades - De RU Операции с операции с S aktiviteter från aktiviteter från TR Aktiviteler, İlk aktiviteler: ilk US Activities From activities from ZHS 活动自 活动自 20 180 :p_to_activity LOV Oracle WIP_SRS_ACTIVITIES_OPT Y select activity id, activity value, null description from cst_activities where (organization_id is null or organization_id= fnd_profile.value('MFG_ORGANIZATION_ID')) order by activity AR إلى 8 الأنشطة إلى D Bis 8 Bis Prozess E A 8 a actividad F A 8 Activités - A I A 8 Attività - A JA 至 8 活動:至 KO 까지 8 활동: 까지 PTB Até 8 Atividades - até RU По 8 операции по S Till 8 aktiviteter till TR Son 8 aktiviteler: son US To 8 activities to ZHS 至 8 活动至