ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4729C51A9E05362FB09050512Y select &P_ASSY_FLEX C_ASSY_FLEX, MSI.description, WE.wip_entity_name Job, DJ.lot_number Lot, round(DJ.start_quantity,:P_Qty_Precision) Qty_Planned, DJ.date_released Release_Date, ML.meaning Status, round(DJ.quantity_completed,:P_Qty_Precision) Qty_Completed, DJ.date_completed Complete_Date, MSI.primary_uom_code UOM, DJ.bom_revision Revision, DJ.wip_entity_id, WE.primary_item_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('assembly1', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') Assembly1 from wip_entities WE, mfg_lookups ML, mtl_system_items MSI, wip_discrete_jobs DJ where exists (select 1 from MTL_TRANSACTION_LOT_NUMBERS MTV where MTV.TRANSACTION_SOURCE_TYPE_ID =5 and MTV.TRANSACTION_SOURCE_ID = DJ. wip_entity_id and MTV.organization_id = :P_Organization_Id and rownum =1) and WE.organization_id = :P_Organization_Id and DJ.organization_id = :P_Organization_Id and MSI.organization_id &P_OUTER = :P_Organization_Id and DJ.status_type = ML.lookup_code and ML.lookup_type = 'WIP_JOB_STATUS' and DJ.wip_entity_id = WE.wip_entity_id and DJ.primary_item_id = MSI.inventory_item_id &P_OUTER &Limit_Dates &Limit_Jobs &Limit_Lots --&Limit_Assembly and &P_FLEXWHERE &Sort_Option WIP WIPMTDLT_XML AR WIP تقرير تركيب لوط أمر الشغل (بتنسيق XML) Imported from BI Publisher Description: تقرير تركيب لوط أمر الشغل Application: العمل في الإنجاز Source: تقرير تركيب لوط أمر الشغل (بتنسيق XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG D WIP Loszusammenstellung Imported from BI Publisher Description: Loszusammenstellung Application: Fertigung Source: Loszusammenstellung (XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG E WIP Composición de Lotes de Órdenes de Fabricación Imported from BI Publisher Description: Informe de composición de lotes de órdenes de fabricación Application: Work in Process Source: Composición de Lotes de Órdenes de Fabricación (XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG F WIP Etat Lots de composants par OF Imported from BI Publisher Description: Etat Lots de composants par OF Application: Work In Process Source: Etat Lots de composants par OF (XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG I WIP Rapporto Composizione lotto per OdL Imported from BI Publisher Description: Rapporto Composizione lotto per OdL Application: Work in Process Source: Rapporto Composizione lotto per OdL (XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG JA WIP 製造オーダー・ロット構成レポート Imported from BI Publisher Description: 製造オーダー・ロット構成レポート Application: Work in Process Source: 製造オーダー・ロット構成レポート(XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG KO WIP 작업 로트 구성 보고서 Imported from BI Publisher Description: 작업 로트 구성 보고서 Application: Work in Process Source: 작업 로트 구성 보고서(XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG PTB WIP Relatório de Composição Lotes da OP Imported from BI Publisher Description: Relatório Compos.de Lotes da OP Application: Work in Process Source: Relatório de Composição Lotes da OP (XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG RU WIP Отчет о составе партии для задания Imported from BI Publisher Description: Отчет о составе партии для задания Application: Незавершенное производство Source: Отчет о составе партии для задания (XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG S WIP TO-partisammansättning - rapport Imported from BI Publisher Description: TO-partisammansättning - rapport Application: Work in Process Source: TO-partisammansättning - rapport (XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG TR WIP İş Emri Lot Oluşturma Raporu Imported from BI Publisher Description: İş Emri Lot Oluşturma Raporu Application: Üretim İzleme Source: İş Emri Lot Oluşturma Raporu (XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG US WIP Job Lot Composition Imported from BI Publisher Description: Job Lot Composition Report Application: Work in Process Source: Job Lot Composition Report (XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG ZHS WIP 任务批次构成报表 Imported from BI Publisher Description: 任务批次构成报表 Application: 在制品管理系统 Source: 任务批次构成报表 (XML) Short Name: WIPMTDLT_XML DB package: WIP_WIPMTDLT_XMLP_PKG BI Publisher &limit_assembly &limit_dates &limit_jobs &limit_lots &p_assy_flex &p_flexwhere &p_outer &sort_option :p_assembly :p_assy_flex :p_conc_request_id :p_debug :p_flexwhere :p_from_date :p_from_date1 :p_from_job :p_from_lot :p_organization_id :p_outer :p_qty_precision :p_sort :p_struct_num :p_to_date :p_to_date1 :p_to_job :p_to_lot 1 -40 :p_struct_num Number select chart_of_accounts_id from org_organization_definitions where organization_id = fnd_profile.value('mfg_organization_id') Y AR رقم هيكل مرن رقم هيكل مرن D FlexFeld-Struktur-Nummer FlexFeld-Struktur-Nummer E Número de Tipo de Estructura Número de Tipo de Estructura F Numéro structure flexible Numéro structure flexible I Numero struttura flexfield Numero struttura flexfield JA フレックス体系番号 フレックス体系番号 KO 가변 구조 번호 가변 구조 번호 PTB Número da Estrutura do Flexfield Número da Estrutura de Flexfield RU Номер структуры ГП Номер структуры ГП S Flexstrukturnummer Flexstrukturnummer TR Esnekalan yapı numarası Esnek Yapı Numarası US Flex structure number Flex Structure Number ZHS 弹性结构编号 弹性结构编号 2 -30 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف التنظيم معرف التنظيم D Organisation Organisation E Id Org. Id Org. F ID org ID org I ID org. ID dell'organizzazione JA 組織ID 組織ID KO 조직 ID 조직 ID PTB Id da Org. Id da Org. RU Идент. орг. Идент. орг. S Org.-id Org.-id TR Org No Org No US Org Id Org Id ZHS 组织标识 组织标识 3 -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 Quanitity Precision Quanitity Precision ZHS 数量精确度 数量精确度 4 10 :p_sort LOV Oracle WIP_SRS_LOT_SORT_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_LOT_SORT' order by meaning select meaning from mfg_lookups where lookup_code = 1 and lookup_type = 'WIP_LOT_SORT' Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Ölçütü Sıralama Ölçütü US Sort By Sort By ZHS 排序依据 排序依据 5 20 :p_assembly Char AR المنتج المنتج D Baugruppe Baugruppe E Conjunto Conjunto F Produit Produit I Assieme Assieme JA 組立品 組立品 KO 조립품 조립품 PTB Montagem Montagem RU Сборка Сборка S Montering Montering TR Ürün Ürün US Assembly Assembly ZHS 装配件 装配件 6 30 :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 Från datum TR Tarihler, İlk Tarihler, İlk US Dates From Dates From ZHS 日期自 日期自 7 40 :p_to_date Date AR إلى التواريخ إلى D Bis Bis E A A Fecha F A Dates - Au I A Date - A JA 至 日付:至 KO 까지 일자: 까지 PTB Até Datas - até RU По Даты по S Till Till datum TR Son Tarihler: Son US To Dates To ZHS 至 终止日期 8 50 :p_from_job LOV Oracle WIP_SRS_DISCRETE_JOBS_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') and entity_type not in (2,9,10) order by wip_entity_name AR أوامر الشغل من أوامر الشغل من D Von Fertigungsauftrag Von Fertigungsauftrag E De Orden de Fabricación De Orden de Fabricación F Ordres de fabrication - De Ordres de fabrication - De I OdL - Da OdL - Da JA 製造オーダー:自 製造オーダー:自 KO 작업: 부터 작업: 부터 PTB Ordens de Produção - De Ordens de Produção - De RU Задания с Задания с S Från TO Från TO TR İş Emirleri, İlk İş Emirleri, İlk US Jobs From Jobs From ZHS 任务自 任务自 9 60 :p_to_job LOV Oracle WIP_SRS_DISCRETE_JOBS_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') and entity_type not in (2,9,10) order by wip_entity_name AR إلى 2 أوامر شغل إلى D Bis 2 Bis Fertigungsauftrag E A 2 A Orden de Fabricación F A 2 Ordres de fabrication - A I A 2 OdL - A JA 至 2 製造オーダー:至 KO 까지 2 작업: 까지 PTB Até 2 Ordens de Produção - Até RU По 2 Задания по S Till 2 Till TO TR Son 2 İş Emirleri: Son US To 2 Jobs To ZHS 至 2 任务至 10 70 :p_from_lot LOV Oracle WIP_SRS_LOTS_OPT Y select lot_number id, lot_number value, null description from wip_discrete_jobs where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and lot_number is not null order by value,description AR اللوطات من اللوطات من D Von Los Von Los E De Lote De Lote F Lots - De Lots - De I Lotti - Da Lotti - Da JA ロット:自 ロット:自 KO 로트: 부터 로트: 부터 PTB Lotes - De Lotes - De RU Партии с Партии с S Från parti Från parti TR Lotlar, İlk Lotlar, İlk US Lots From Lots From ZHS 批次自 批次自 11 80 :p_to_lot LOV Oracle WIP_SRS_LOTS_OPT Y select lot_number id, lot_number value, null description from wip_discrete_jobs where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and lot_number is not null order by value,description AR إلى 3 الرزم إلى D Bis 3 Bis Los E A 3 A Lote F A 3 Lots - A I A 3 Lotti - A JA 至 3 ロット:至 KO 까지 3 로트: 까지 PTB Até 3 Lotes - até RU По 3 Партии по S Till 3 Partier till TR Son 3 Lotlar: Son US To 3 Lots To ZHS 至 3 批次至