ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F6E51A9E05362FB09050512 select flex.item_number Item, lu2.meaning Eng_Routing, r.resource_code Res2, flex.Description Des, b.Process_revision Rev, rtg.alternate_routing_designator Alternate, os.operation_seq_num Op, d.department_code Department, to_char(os.effectivity_date,'DD-MON-RR HH24:MI:SS') Effective_Date, to_char(os.disable_date,'DD-MON-RR HH24:MI:SS') Disable_Date, ors.resource_seq_num seq_num, round(ors.assigned_units, :P_QTY_PRECISION) Units, substrb(lu1.meaning, 1, 5) Basis, round(ors.usage_rate_or_amount, :P_QTY_PRECISION) Usage_Rate, round(ors.usage_rate_or_amount_inverse, :P_QTY_PRECISION) Usage_Rate_Inverse from MTL_ITEM_FLEXFIELDS FLEX, BOM_RESOURCES R, mtl_rtg_item_revisions b, BOM_OPERATIONAL_ROUTINGS RTG, BOM_OPERATION_SEQUENCES OS, BOM_DEPARTMENTS D, BOM_OPERATION_RESOURCES ORS, MFG_LOOKUPS LU1, MFG_LOOKUPS LU2, CST_ACTIVITIES ACT where R.RESOURCE_ID = ORS.RESOURCE_ID AND ORS.OPERATION_SEQUENCE_ID = OS.OPERATION_SEQUENCE_ID AND OS.DEPARTMENT_ID = D.DEPARTMENT_ID AND OS.ROUTING_SEQUENCE_ID = RTG.COMMON_ROUTING_SEQUENCE_ID AND os.effectivity_date <= :P_EFFECTIVE_DATE and nvl(os.disable_date, :P_EFFECTIVE_DATE +1 ) > :P_EFFECTIVE_DATE and RTG.ASSEMBLY_ITEM_ID = FLEX.ITEM_ID AND RTG.ORGANIZATION_ID = FLEX.ORGANIZATION_ID AND ORS.ACTIVITY_ID = ACT.ACTIVITY_ID(+) AND (LU1.LOOKUP_TYPE = 'CST_BASIS' AND LU1.LOOKUP_CODE = ORS.BASIS_TYPE) AND (lu2.lookup_type='BOM_NO_YES' and lu2.lookup_code = rtg.routing_type) and r.organization_id = :P_ORG_ID and ((:P_ENG_BILL_FLAG='BOM' and rtg.routing_type=1) OR (:P_ENG_BILL_FLAG='ENG')) and b.inventory_item_id = nvl(rtg.common_assembly_item_id, rtg.assembly_item_id) and b.process_revision = (select max(b2.process_revision) from mtl_rtg_item_revisions b2 where b2.inventory_item_id = nvl(rtg.common_assembly_item_id, rtg.assembly_item_id) and b2.organization_id = :P_ORG_ID and b2.effectivity_date = (select max(b1.effectivity_date) from mtl_rtg_item_revisions b1 where b1.inventory_item_id = nvl(rtg.common_assembly_item_id, rtg.assembly_item_id) and b1.organization_id = :P_ORG_ID and b1.effectivity_date <= :P_EFFECTIVE_DATE) ) and b.organization_id = r.organization_id and r.resource_code=:Res order by flex.padded_item_number, os.operation_seq_num, ors.resource_seq_num ,rtg.alternate_routing_designator Y BOM BOMRWURSG_XML AR BOM واجهة المستخدم الرسومية لتقرير محل استخدام المورد (تنسيق XML) Imported from BI Publisher Description: تقرير محل استخدام المورد Application: شجرة المنتجات Source: واجهة المستخدم الرسومية لتقرير محل استخدام المورد (تنسيق XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG D BOM Ressourcen - Verwendungsnachweis (SC) - XML Imported from BI Publisher Description: Ressourcen - Verwendungsnachweis Application: Produktionsdaten Source: Ressourcen - Verwendungsnachweis (SC) - XML Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG E BOM Uso de Recursos - GUI Imported from BI Publisher Description: Informe de uso de recursos Application: Bills of Material Source: Uso de Recursos - GUI (XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG F BOM Etat Cas d'emploi des ressources - GUI Imported from BI Publisher Description: Etat Cas d'emploi des ressources Application: Bills of Material Source: Etat Cas d'emploi des ressources - GUI (XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG I BOM GUI rapporto Sede impiego risorsa Imported from BI Publisher Description: Rapporto Sede impiego risorsa Application: Bills of Material Source: GUI rapporto Sede impiego risorsa (XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG JA BOM 生産資源使用箇所レポート GUI Imported from BI Publisher Description: 生産資源使用箇所レポート Application: Bills of Material Source: 生産資源使用箇所レポート GUI(XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG KO BOM 자원 사용처 보고서 GUI Imported from BI Publisher Description: 자원 사용처 보고서 Application: Bills of Material Source: 자원 사용처 보고서 GUI(XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG PTB BOM Relatório de Utilização de Recursos GUI Imported from BI Publisher Description: Relatório de Utilização do Recurso Application: Bills of Material Source: Relatório de Utilização de Recursos GUI (XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG RU BOM ГИП ведомости использования ресурсов Imported from BI Publisher Description: Ведомость использования ресурсов Application: Спецификации Source: ГИП ведомости использования ресурсов (XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG S BOM Resurs ingår i - rapport GUI Imported from BI Publisher Description: Resurs ingår i - rapport Application: Bills of Material Source: Resurs ingår i - rapport GUI (XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG TR BOM Kaynak Kullanım Yeri Raporu GUI Imported from BI Publisher Description: Kaynak Kullanım Yeri Raporu Application: Ürün Ağacı Source: Kaynak Kullanım Yeri Raporu GUI (XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG US BOM Resource Where Used Report GUI Imported from BI Publisher Description: Resource Where Used Report Application: Bills of Material Source: Resource Where Used Report GUI (XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG ZHS BOM 资源使用处报表 GUI Imported from BI Publisher Description: 资源使用处报表 Application: 物料清单管理系统 Source: 资源使用处报表 GUI (XML) Short Name: BOMRWURSG_XML DB package: BOM_BOMRWURS_XMLP_PKG BI Publisher :p_conc_request_id :p_debug :p_effective_date :p_eng_bill_flag :p_org_id :p_qty_precision :p_resource_from :p_resource_to :res 1 -50 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR BOM_SRS_ORG_ID معرف التنظيم D BOM_SRS_ORG_ID Organisationskennung E BOM_SRS_ORG_ID Id Organización F BOM_SRS_ORG_ID ID organisation I BOM_SRS_ORG_ID Id organizzazione JA BOM_SRS_ORG_ID 組織ID KO BOM_SRS_ORG_ID 조직 ID PTB BOM_SRS_ORG_ID Id da organização RU BOM_SRS_ORG_ID Идентификатор организации S BOM_SRS_ORG_ID Organisations-id TR BOM_SRS_ORG_ID Organizasyon no US BOM_SRS_ORG_ID Organization id ZHS BOM_SRS_ORG_ID 组织标识 2 -40 :p_eng_bill_flag Char SELECT :parameter.PROGRAM_APPL_SHORT_NAME FROM DUAL Y AR علامة توجيه هندسي علامة التوجيه الهندسي D Konstruktions-Arbeitsplan Konstruktions-Arbeitsplan E Ruta de Diseño Ruta de Diseño F Indicateur Gamme étude Indicateur Gamme d'étude I Flag Ciclo tecnico Flag Ciclo tecnico JA 設計工順フラグ 設計工順フラグ KO 설계 공정순서 플래그 설계 공정순서 플래그 PTB Indicador de Roteiro de Eng. Indicador de roteiro de engenharia RU Флаг технологической карты Флаг технологической карты S Konstr.operationsflagga Konstruktionsoperationsflagga TR Mühendislik Rota İşareti Mühendislik rota işareti US Eng Routing Flag Engineering routing flag ZHS 工程工艺路线标志 工程工艺路线标志 3 -30 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') AR خيار الدقة الديناميكية الدقة الديناميكية D Option Nachkommastellen Nachkommastellen E Opción Precisión Dinámica Precisión Dinámica F Option précision dynamique Précision dynamique I Opzione precisione dinamica Precisione dinamica JA 動的演算精度オプション 動的精度 KO 동적 소수점자리 옵션 동적 소수점자리 PTB Opção de Precisão Dinâmica Precisão Dinâmica RU Динамическая точность Динамическая точность S Alternativ för dynamisk precision Dynamisk precision TR Dinamik Duyarlılık Seçeneği Dinamik Duyarlılık US Dynamic Precision Option Dynamic Precision ZHS 动态精确度选项 动态精确度 4 -20 :p_debug Char fnd_profile.value('MRP_TRACE') Y AR علامة التتبع خاصية التتبع D Trace Trace aktivieren E Rastreo Instalación de Rastreo F Indicateur Trace Fonction de trace I Flag Traccia Funzione di traccia JA トレース・フラグ トレース機能 KO 추적 플래그 추적 기능 PTB Indicador de Rastreamento Recurso de Rastro RU Флаг трассировки Программа трассировки S Spårningsflagga Spårningsfunktion TR İzleme İşareti İzleme Olanağı US Trace Flag Trace Facility ZHS 跟踪标志 跟踪设施 5 10 :p_resource_from LOV Oracle BOM_SRS_RESOURCE Y select resource_code id, resource_code value, description description from bom_resources where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and cost_code_type in (3,4) order by resource_code AR مورد من من المورد D Von Ressource Von Ressource E De Recurso De Recurso F Ressource - De Ressource - De I Risorsa - Da Risorse - Da JA 生産資源:自 生産資源:自 KO 자원: 부터 자원: 부터 PTB Recurso - De Recurso - De RU Ресурс с Исходный ресурс S Från resurs Från resurs TR Kaynak: İlk İlk kaynak US Resource From From resource ZHS 资源自 自资源 6 20 :p_resource_to LOV Oracle BOM_SRS_RESOURCE Y select resource_code id, resource_code value, description description from bom_resources where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and cost_code_type in (3,4) order by resource_code select :$flex$.resource_from from dual AR إلى إلى الموارد D Bis Bis Ressource E A A recursos F A Ressources - A I A Risorse - A JA 至 生産資源:至 KO 까지 자원: 까지 PTB Até Recurso - Até RU По Ресурсы по S Till Till resurser TR Son Kaynaklar: Son US To To resources ZHS 至 至资源 7 30 :p_effective_date DateTime sysdate Y AR تاريخ الفعالية تاريخ الفعالية D Gültigkeitsdatum Gültigkeitsdatum E Fecha en Vigor Fecha en Vigor F Date de validité Date validité I Data validità Data validità JA 有効日 有効日 KO 유효 일자 유효 일자 PTB Data Efetivação Data de efetivação RU Дата действия Дата действия S Giltighetsdatum Giltighetsdatum TR Geçerlilik Tarihi Geçerlilik tarihi US Effective Date Effective date ZHS 有效日期 有效日期 :$flex$.resource_from Resource From To