ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F6851A9E05362FB09050512Y SELECT res.resource_id resource_id, res.resource_code Name, res.description Description, res.resource_type resource_type, lu1.meaning Type, res.functional_currency_flag functional_currencty_flag, lu2.meaning Functional_Currency, res.unit_of_measure UOM, res.cost_element_id cost_element_id, ce.cost_element Cost_Element, res.autocharge_type autocharge_type, lu3.meaning Autocharge, msi.description pi_description, gl1.description aa_description, gl2.description rv_description, res.allow_costs_flag allow_costs_flag, lu5.meaning Allow_Costs, res.standard_rate_flag standard_rate_flag, lu6.meaning Std_Rate, res.default_activity_id default_activity_id, act.activity Activity, res.default_basis_type default_basis_type, lu7.meaning Basis, res.disable_date Disable_Date, res.purchase_item_id purchase_item_id, res.absorption_account absorption_account, res.rate_variance_account rate_variance_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield2', 'SQLGL', 'GL#', gl1.CHART_OF_ACCOUNTS_ID, NULL, gl1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield3', 'SQLGL', 'GL#', gl2.CHART_OF_ACCOUNTS_ID, NULL, gl2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD3 FROM bom_resources res, mfg_lookups lu1, mfg_lookups lu2, mfg_lookups lu3, mfg_lookups lu5, mfg_lookups lu6, mfg_lookups lu7, cst_cost_elements ce, cst_activities act, mtl_system_items msi, gl_code_combinations gl1, gl_code_combinations gl2 WHERE res.organization_id = :P_ORG_ID and msi.inventory_item_id(+) = res.purchase_item_id and (msi.organization_id = res.organization_id or res.purchase_item_id is null) and gl1.code_combination_id(+) = res.absorption_account and gl2.code_combination_id(+) = res.rate_variance_account and ((res.resource_code between :P_FROM and :P_TO and :P_FROM is not null and :P_TO is not null) or (res.resource_code <= :P_TO and :P_FROM is null and :P_TO is not null) or (res.resource_code >= :P_FROM and :P_FROM is not null and :P_TO is null) or (:P_FROM is null and :P_TO is null)) and res.cost_code_type in (3,4) and res.cost_element_id = ce.cost_element_id and res.default_activity_id = act.activity_id(+) and lu1.lookup_type = 'BOM_RESOURCE_TYPE' and lu1.lookup_code = res.resource_type and lu2.lookup_type = 'SYS_YES_NO' and lu2.lookup_code = res.functional_currency_flag and lu3.lookup_type = 'BOM_AUTOCHARGE_TYPE' and lu3.lookup_code = res.autocharge_type and lu5.lookup_type = 'SYS_YES_NO' and lu5.lookup_code = res.allow_costs_flag and lu6.lookup_type = 'SYS_YES_NO' and lu6.lookup_code = res.standard_rate_flag and lu7.lookup_type(+) = 'CST_BASIS' and lu7.lookup_code(+) = res.default_basis_type ORDER BY resource_code BOM BOMRDORS_XML AR BOM تقرير المورد (تنسيق XML) Imported from BI Publisher Description: تقرير المورد Application: شجرة المنتجات Source: تقرير المورد (تنسيق XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG D BOM Ressourcen Imported from BI Publisher Description: Ressourcen Application: Produktionsdaten Source: Ressourcen (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG E BOM Recursos Imported from BI Publisher Description: Informe de recursos Application: Bills of Material Source: Recursos (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG F BOM Etat Ressources Imported from BI Publisher Description: Etat Ressources Application: Bills of Material Source: Etat Ressources (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG I BOM Rapporto Risorse Imported from BI Publisher Description: Rapporto Risorse Application: Bills of Material Source: Rapporto Risorse (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG JA BOM 生産資源レポート Imported from BI Publisher Description: 生産資源レポート Application: Bills of Material Source: 生産資源レポート(XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG KO BOM 자원 보고서 Imported from BI Publisher Description: 자원 보고서 Application: Bills of Material Source: 자원 보고서(XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG PTB BOM Relatório de Recurso Imported from BI Publisher Description: Relatório de Recurso Application: Bills of Material Source: Relatório de Recurso (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG RU BOM Отчет о ресурсах Imported from BI Publisher Description: Отчет о ресурсах Application: Спецификации Source: Отчет о ресурсах (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG S BOM Resursrapport Imported from BI Publisher Description: Resursrapport Application: Bills of Material Source: Resursrapport (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG TR BOM Kaynak Raporu Imported from BI Publisher Description: Kaynak Raporu Application: Ürün Ağacı Source: Kaynak Raporu (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG US BOM Resource Imported from BI Publisher Description: Resource Report Application: Bills of Material Source: Resource Report (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG ZHS BOM 资源报表 Imported from BI Publisher Description: 资源报表 Application: 物料清单管理系统 Source: 资源报表 (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG BI Publisher :chart_of_accounts_id :p_conc_request_id :p_debug :p_ext_precision :p_flexdata :p_flexdata2 :p_flexdata3 :p_from :p_org_id :p_report_type :p_std_precision :p_struct_num :p_to 1 -40 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR organization_id معرف التنظيم D organization_id Organisation E organization_id Id Organización F organization_id ID organisation I organization_id ID org. JA organization_id 組織ID KO organization_id 조직 ID PTB organization_id id da org. RU organization_id идентификатор организации S organization_id org.-id TR organization_id org no US organization_id org id ZHS organization_id 组织标识 2 -30 :chart_of_accounts_id Number fnd_profile.value('MFG_CHART_OF_ACCOUNTS_ID') Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kennung Kontenplan Kennung Kontenplan E Id Plan de Cuentas Id Plan de Cuentas F ID plan de comptes ID plan de comptes I ID piano dei conti ID del piano dei conti JA 勘定体系ID 勘定体系ID KO 계정코드집 id 계정코드집 id PTB Id do plano de contas Id do plano de contas RU Идентификатор плана счетов Идентификатор плана счетов S Kontoplans-id Kontoplans-id TR Hesap planı no Hesap planı no US Chart of accounts id Chart of accounts id ZHS 科目表标识 科目表标识 3 -20 :p_debug Char fnd_profile.value('MRP_TRACE') Y AR علامة التتبع تشغيل/إيقاف التتبع D Trace Trace aktivieren/deaktivieren E Rastreo Activar/Desactivar Rastreo F Indicateur Trace Activer/Désactiver Trace I Flag Traccia Attiva/Disattiva Traccia JA トレース・フラグ トレースのON/OFF KO 추적 플래그 추적 전환 ON/OFF PTB Indicador de Rastreamento Ativar/Desativar Rastreamento RU Флаг трассировки Включение/отключение трассировки S Spårningsflagga Slå på/av spårning TR İzleme İşareti İzlemeyi AÇ/KAPAT US Trace Flag Turn Trace ON/OFF ZHS 跟踪标志 打开/关闭跟踪 4 10 :p_report_type LOV Oracle BOM_SRS_YES_NO2 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 Ressourcendetails Details - Ja oder Nein? E Detalle de Recursos Detalles - Sí o No F Détail ressources Détails - Oui ou Non ? I Dettagli risorsa Dettagli - Sì o No? JA 生産資源詳細 詳細 - YesまたはNo? KO 자원 상세내역 상세내역 - Yes 또는 No? PTB Detalhe do Recurso Detalhes - Sim ou Não? RU Сведения о ресурсе Сведения - "Да" или "Нет"? S Resursdetalj Detaljer - Ja eller Nej? TR Kaynak Detayı Detaylar - Evet veya Hayır? US Resource Detail Details - Yes or No? ZHS 资源详细资料 详细资料 - 是或否？ 5 20 :p_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 Ressources - De Ressource - De I Risorse - Da Risorse - Da JA 生産資源:自 生産資源:自 KO 자원: 부터 자원: 부터 PTB Recursos - De Recursos - De RU Ресурсы с Ресурс с S Från resurser Resurs från TR Kaynaklar, İlk Kaynaklar: İlk US Resources From Resource from ZHS 资源自 资源自 6 30 :p_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$.resources_from from dual AR إلى مورد إلى D Bis Bis Ressource E A A Recurso F A Ressource - A I A Risorse - A JA 至 生産資源:至 KO 까지 자원: 까지 PTB Até Recursos - Até RU По Ресурсы по S Till Resurs till TR Son Kaynaklar: Son US To Resource to ZHS 至 资源至