ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472AE51A9E05362FB09050512Y SELECT &P_FLEXDATA C_FLEXDATA_DETAIL , DECODE(:P_SORT,1,&P_FLEXDATA,'X') C_FLEXDATA , WT.TRANSACTION_DATE DATE_DETAIL , DECODE(:P_SORT,2,WT.TRANSACTION_DATE,SYSDATE) , WE.WIP_ENTITY_NAME , WL.LINE_CODE , WT.FM_OPERATION_SEQ_NUM , BSO1.OPERATION_CODE FM_OPERATION_CODE , BD1.DEPARTMENT_CODE DEPARTMENT_CODE , ML1.MEANING MEANING , WT.TO_OPERATION_SEQ_NUM , BSO2.OPERATION_CODE TO_OPERATION_CODE , BD2.DEPARTMENT_CODE DEPARTMENT_CODE1 , ML2.MEANING MEANING1 , WT.TRANSACTION_QUANTITY , WT.TRANSACTION_UOM , WT.PRIMARY_QUANTITY , WT.PRIMARY_UOM , DECODE(:P_SORT,1,NVL(WE.PRIMARY_ITEM_ID,-1),0) ITEM_ID , NVL(WE.PRIMARY_ITEM_ID,-1) ITEM_ID_DETAIL , MTR.REASON_NAME , WT.REFERENCE , DECODE(:P_SORT,1,MSI.DESCRIPTION,'X') , MSI.DESCRIPTION DESC_DETAIL, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_sort', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_FLEX_SORT, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_assembly1', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_ASSEMBLY1, DECODE(:P_SORT,2,'C_ASSEMBLY_DET','X') C_ASSEMBLY_DET FROM MTL_SYSTEM_ITEMS MSI , BOM_DEPARTMENTS BD1 , BOM_DEPARTMENTS BD2 , BOM_STANDARD_OPERATIONS BSO1 , BOM_STANDARD_OPERATIONS BSO2 , MFG_LOOKUPS ML1 , MFG_LOOKUPS ML2 , WIP_ENTITIES WE , WIP_LINES WL , WIP_OPERATIONS WO1 , WIP_OPERATIONS WO2 , MTL_TRANSACTION_REASONS MTR , WIP_MOVE_TRANSACTIONS WT WHERE WT.ORGANIZATION_ID = :P_ORGANIZATION_ID &C_Limit_Dates AND NVL(BSO1.OPERATION_TYPE, 1) = 1 AND NVL(BSO2.OPERATION_TYPE, 1) = 1 AND BSO1.LINE_ID IS NULL AND BSO2.LINE_ID IS NULL AND BD1.DEPARTMENT_ID = WT.FM_DEPARTMENT_ID AND BD2.DEPARTMENT_ID = WT.TO_DEPARTMENT_ID AND WT.WIP_ENTITY_ID = WO1.WIP_ENTITY_ID AND WT.WIP_ENTITY_ID = WO2.WIP_ENTITY_ID AND WO1.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WO2.ORGANIZATION_ID = :P_ORGANIZATION_ID AND BSO1.ORGANIZATION_ID (+) = :P_ORGANIZATION_ID AND BSO2.ORGANIZATION_ID (+) = :P_ORGANIZATION_ID AND WT.FM_OPERATION_SEQ_NUM = WO1.OPERATION_SEQ_NUM AND WT.TO_OPERATION_SEQ_NUM = WO2.OPERATION_SEQ_NUM AND WO1.STANDARD_OPERATION_ID = BSO1.STANDARD_OPERATION_ID (+) AND WO2.STANDARD_OPERATION_ID = BSO2.STANDARD_OPERATION_ID (+) AND NVL(WO1.REPETITIVE_SCHEDULE_ID, -999) = (SELECT NVL(MIN(WMTA.REPETITIVE_SCHEDULE_ID), -999) FROM WIP_MOVE_TXN_ALLOCATIONS WMTA WHERE WMTA.TRANSACTION_ID = WT.TRANSACTION_ID) AND NVL(WO2.REPETITIVE_SCHEDULE_ID, -999) = (SELECT NVL(MIN(WMTA.REPETITIVE_SCHEDULE_ID), -999) FROM WIP_MOVE_TXN_ALLOCATIONS WMTA WHERE WMTA.TRANSACTION_ID = WT.TRANSACTION_ID) AND ML1.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP' AND ML1.LOOKUP_CODE = FM_INTRAOPERATION_STEP_TYPE AND ML2.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP' AND ML2.LOOKUP_CODE = TO_INTRAOPERATION_STEP_TYPE 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 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 --&C_Limit_Assemblies AND &P_FLEXWHERE /*ORDER BY WT.TRANSACTION_DATE , WE.WIP_ENTITY_NAME , WL.LINE_CODE , WT.FM_OPERATION_SEQ_NUM , WT.TO_OPERATION_SEQ_NUM , WT.CREATION_DATE , WT.TRANSACTION_ID */ ORDER BY 4 ASC , WT.TRANSACTION_DATE , WE.WIP_ENTITY_NAME , WL.LINE_CODE , WT.FM_OPERATION_SEQ_NUM , WT.TO_OPERATION_SEQ_NUM , WT.CREATION_DATE , WT.TRANSACTION_ID WIP WIPTSMOV_XML AR WIP تقرير حركة النقل (بتنسيق XML) Imported from BI Publisher Description: تقرير حركة النقل Application: العمل في الإنجاز Source: تقرير حركة النقل (بتنسيق XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG D WIP Arbeitsfortschrittsmeldungen Imported from BI Publisher Description: Arbeitsfortschrittsmeldungen Application: Fertigung Source: Arbeitsfortschrittsmeldungen (XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG E WIP Transacciones de Movimiento Imported from BI Publisher Description: Informe de transacciones de movimiento Application: Work in Process Source: Transacciones de Movimiento (XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG F WIP Etat Mouvements de transfert Imported from BI Publisher Description: Etat Mouvements de transfert Application: Work In Process Source: Etat Mouvements de transfert (XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG I WIP Rapporto Transazione spostamento Imported from BI Publisher Description: Rapporto Transazione spostamento Application: Work in Process Source: Rapporto Transazione spostamento (XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG JA WIP 移動取引レポート Imported from BI Publisher Description: 移動取引レポート Application: Work in Process Source: 移動取引レポート(XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG KO WIP 이동 트랜잭션 보고서 Imported from BI Publisher Description: 이동 트랜잭션 보고서 Application: Work in Process Source: 이동 트랜잭션 보고서(XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG PTB WIP Relatório de Transação de Movimentação Imported from BI Publisher Description: Rel.Movim.Transação Application: Work in Process Source: Relatório de Transação de Movimentação (XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG RU WIP Отчет об транзакциях перемещения Imported from BI Publisher Description: Отчет об транзакциях перемещения Application: Незавершенное производство Source: Отчет об транзакциях перемещения (XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG S WIP Transporttransaktion - rapport Imported from BI Publisher Description: Transporttransaktion - rapport Application: Work in Process Source: Transporttransaktion - rapport (XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG TR WIP Hareket İşlemi Raporu Imported from BI Publisher Description: Hareket İşlemi Raporu Application: Üretim İzleme Source: Hareket İşlemi Raporu (XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG US WIP Move Transaction Imported from BI Publisher Description: Move Transaction Report Application: Work in Process Source: Move Transaction Report (XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG ZHS WIP 移动事务处理报表 Imported from BI Publisher Description: 移动事务处理报表 Application: 在制品管理系统 Source: 移动事务处理报表 (XML) Short Name: WIPTSMOV_XML DB package: WIP_WIPTSMOV_XMLP_PKG BI Publisher &c_limit_assemblies &c_limit_dates &c_limit_jobs &c_limit_lines &c_limit_reasons &p_flexdata &p_flexwhere :p_conc_request_id :p_debug :p_flexdata :p_flexwhere :p_from_assembly :p_from_date :p_from_date1 :p_from_job :p_from_line :p_from_reason :p_organization_id :p_qty_precision :p_show_details :p_sort :p_to_assembly :p_to_date :p_to_date1 :p_to_job :p_to_line :p_to_reason :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_sort LOV Oracle WIP_SRS_MOVE_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) 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_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 生产线自 生产线自 8 60 :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 إلى 2 سطور إلى D Bis 2 Bis Linie E A 2 a línea F A 2 Lignes - A I A 2 Linee - A JA 至 2 ライン:至 KO 까지 2 라인: 까지 PTB Até 2 Linhas - até RU По 2 линии по S Till 2 rader till TR Son 2 Hat bitişi US To 2 lines to ZHS 至 2 生产线至 9 70 :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 装配件自 装配件自 10 80 :p_to_assembly Char AR إلى 3 المنتجات إلى D Bis 3 Bis Baugruppe E A 3 a conjunto F A 3 Produits - A I A 3 Assiemi - A JA 至 3 組立:至 KO 까지 3 조립품: 까지 PTB Até 3 Montagens - De RU По 3 сборки по S Till 3 produkter till TR Son 3 son ürünler US To 3 assemblies to ZHS 至 3 装配件至 11 90 :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 日期自 起始日期 12 100 :p_to_date Date AR إلى 4 التواريخ إلى D Bis 4 Bis E A 4 a fecha F A 4 Dates - Au I A 4 Date - A JA 至 4 日付:至 KO 까지 4 일자: 까지 PTB Até 4 Datas - De RU По 4 даты по S Till 4 datum till TR Son 4 Başlangıç Tarihi US To 4 dates to ZHS 至 4 终止日期 13 110 :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 原因自 原因自 14 120 :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 إلى 5 الأسباب إلى D Bis 5 Bis Grund E A 5 a motivo F A 5 Motifs - A I A 5 Motivi - A JA 至 5 事由:至 KO 까지 5 사유: 까지 PTB Até 5 Motivos - até RU По 5 основания по S Till 5 orsaker till TR Son 5 nedenler: son US To 5 reasons to ZHS 至 5 原因至