ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FBC51A9E05362FB09050512 SELECT item_number, organization_id, organization_code, item_desc, lot_number, lot_desc, cost_level, component_code, analysis_code, component_cost, uom, sequence, component_id, component_desc, test FROM (SELECT DISTINCT iim.item_number item_number, lc.organization_id, mp.organization_code, iim.DESCRIPTION item_desc, lm.lot_number lot_number, lm.DESCRIPTION lot_Desc, decode(lcd.cost_level,0,'Unit Cost',1,'Lower Level Cost','None') cost_level, cmm.cost_cmpntcls_code component_code, lcd.cost_analysis_code analysis_code, lcd.component_cost * :p_exchange_rate component_cost, iim.primary_uom_code uom, cmm.sort_sequence sequence, cmm.cost_cmpntcls_id component_id, cmm.cost_cmpntcls_desc component_desc, decode(nvl(lc.final_cost_flag,0), 1, null, 0, '***') test, rank() over (Partition by lc.inventory_item_id, lc.organization_id, lc.lot_number, lc.cost_mthd_code order by lc.cost_date desc, lc.header_id desc) lot_cost_rank FROM mtl_item_flexfields iim, gmf_lot_costs lc, gmf_lot_cost_details lcd, cm_cmpt_mst cmm, mtl_lot_numbers lm, mtl_parameters mp, hr_organization_information hoi, mtl_categories_kfv mckfv, mtl_item_categories mic, gmd_org_access_vw oa WHERE lc.cost_type_id = :p_cost_type_id AND hoi.org_information2 = :p_legal_entity_id AND iim.inventory_item_id = lm.inventory_item_id AND iim.organization_id = lc.organization_id AND lm.organization_id = lc.organization_id AND lm.lot_number = lc.lot_number AND iim.inventory_item_id = lc.inventory_item_id AND cmm.cost_cmpntcls_id = lcd.cost_cmpntcls_id AND lcd.delete_mark = 0 AND lc.delete_mark = 0 AND lc.header_id = lcd.header_id AND hoi.org_information_context = 'Accounting Information' AND hoi.organization_id = lc.organization_id AND mp.organization_id = lc.organization_id AND mic.inventory_item_id(+) = iim.inventory_item_id AND mic.organization_id(+) = iim.organization_id AND mic.category_id = mckfv.category_id(+) and mckfv.structure_id(+) = :p_structure_id AND iim.organization_id = oa.organization_id &organizationcp &itemcp &CostCategoryCP &LotCP ORDER BY 1,2,4,9,5,6) WHERE lot_cost_rank = 1 Y GMF GMFLCDTL_XML AR GMF تقرير تفاصيل تكلفة اللوط في OPM (تنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل تكلفة اللوط في OPM Application: ماليات التصنيع التشغيلي Source: تقرير تفاصيل تكلفة اللوط في OPM (تنسيق XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG D GMF Chargenkostendetails Imported from BI Publisher Description: OPM Auswertung "Chargenkostendetails" Application: Process Manufacturing Financials Source: Chargenkostendetails (XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG E GMF Detalle de Costes de Lote Imported from BI Publisher Description: Detalle de costes de lote de OPM Application: Process Manufacturing Financials Source: Detalle de Costes de Lote (XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG F GMF OPM - Etat détaillé des coûts de lot Imported from BI Publisher Description: OPM - Etat détaillé des coûts de lot Application: Process Manufacturing Financials Source: OPM - Etat détaillé des coûts de lot (XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG I GMF Rapporto Dettagli costo lotto OPM Imported from BI Publisher Description: Rapporto Dettagli costo lotto OPM Application: Process Manufacturing Financials Source: Rapporto Dettagli costo lotto OPM (XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG JA GMF OPMロット原価詳細レポート Imported from BI Publisher Description: OPMロット原価詳細レポート Application: Process Manufacturing Financials Source: OPMロット原価詳細レポート(XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG KO GMF OPM 로트 원가 상세내역 보고서 Imported from BI Publisher Description: OPM 로트 원가 상세내역 보고서 Application: Process Manufacturing Financials Source: OPM 로트 원가 상세내역 보고서(XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG PTB GMF OPM - Relatório Detalhado de Custo do Lote Imported from BI Publisher Description: OPM - Relatório Detalhado de Custo do Lote Application: Process Manufacturing Financials Source: OPM - Relatório Detalhado de Custo do Lote (XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG RU GMF подробный отчет о затратах партии Imported from BI Publisher Description: УНП: подробный отчет о затратах партии Application: Финансы УНП Source: УНП: подробный отчет о затратах партии (XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG S GMF Kostnadsdetalj för parti Imported from BI Publisher Description: OPM: Kostnadsdetalj för parti Application: Processtillverkning: Ekonomi Source: OPM: Kostnadsdetalj för parti (XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG TR GMF OPM Lot Maliyet Detay Raporu Imported from BI Publisher Description: OPM Lot Maliyet Detay Raporu Application: Üretim Prosesi Finansal Yönetim Source: OPM Lot Maliyet Detay Raporu (XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG US GMF OPM Lot Cost Detail Imported from BI Publisher Description: OPM Lot Cost Detail Report Application: Process Manufacturing Financials Source: OPM Lot Cost Detail Report (XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG ZHS GMF OPM 批次成本明细报表 Imported from BI Publisher Description: OPM 批次成本明细报表 Application: OPM 财务管理系统 Source: OPM 批次成本明细报表 (XML) Short Name: GMFLCDTL_XML DB package: GMF_GMFLCDTL_XMLP_PKG BI Publisher &costcategorycp &itemcp &lotcp &organizationcp :costcategorycp :from_cost_category :from_item :from_orgn :itemcp :lotcp :lp_from_lot :lp_to_lot :nonblocksql :organizationcp :p_conc_request_id :p_cost_type_id :p_currency_code :p_exchange_rate :p_from_cost_category_id :p_from_item_id :p_from_lot :p_from_organization_id :p_legal_entity_id :p_organization_context :p_structure_id :p_to_cost_category_id :p_to_item_id :p_to_lot :p_to_organization_id :sy_all :to_cost_category :to_item :to_orgn 1 -50 :p_structure_id LOV Oracle GMF_SRS_CATEGORY_STRUCTURE_ID Y select mcs.structure_id id, mcs.structure_id value, null description from mtl_default_category_sets mdc,mtl_category_sets mcs where mdc.functional_area_id=19 and mcs.category_set_id=mdc.category_set_id order by value,description SELECT mcs.structure_id FROM mtl_default_category_sets mdc, mtl_category_sets mcs WHERE mdc.functional_area_id = 19 and mcs.category_set_id = mdc.category_set_id AR معرف الهيكل الافتراضي معرف الهيكل الافتراضي D Dummy-Strukturkennung Dummy-Strukturkennung E Id Estructura Ficticia Id Estructura Ficticia F ID structure fictif ID structure fictif I Id struttura fittizia Id della struttura fittizia JA ダミー体系ID ダミー体系ID KO Dummy 구조 ID Dummy 구조 ID PTB ID da Estrutura Fictícia ID da Estrutura Fictícia RU Фиктивный идентификатор структуры Фиктивный идентификатор структуры S Id för dummy-struktur Id för dummy-struktur TR Sözde Yapı No Sözde Yapı No US Dummy Structure ID Dummy Structure ID ZHS 虚拟结构标识 虚拟结构标识 2 -40 :p_organization_context Number fnd_profile.value('MFG_ORGANIZATION_ID') AR سياق التنظيم سياق التنظيم D Organisationskontext Organisationskontext E Contexto de Organización Contexto de Organización F Contexte de l'organisation Contexte de l'organisation I Contesto organizzazione Contesto dell'organizzazione JA 組織コンテキスト 組織コンテキスト KO 조직 컨텍스트 조직 컨텍스트 PTB Contexto da Organização Contexto da Organização RU Контекст организации Контекст организации S Organisationssammanhang Organisationssammanhang TR Organizasyon İçeriği Organizasyon İçeriği US Organization Context Organization Context ZHS 组织上下文 组织上下文 3 -30 :nonblocksql LOV Oracle NONBLOCKSQL Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=108473 order by ffvv.flex_value NO AR Sql غير مدرج بالقطعة SQL غير مدرج بالقطعة D Non Block Sql Non Block Sql E SQL No Bloqueante SQL no bloqueante F SQL hors bloc SQL hors bloc I Non Block Sql Non Block Sql JA 未ブロックSQL 未ブロックSQL KO 비블록 SQL 비블록 SQL PTB SQL Não bloco SQL Não bloco RU SQL без блоков SQL без блоков S Icke-blockerande SQL Icke-blockerande SQL TR Blok Dışı Sql Blok Dışı SQL US Non Block sql Non Block SQL ZHS 非块结构 SQL 非块结构 SQL 4 -20 :sy_all Char fnd_profile.value('SY$ALL') AR تزامن الكل SY ALL E Todo SY SY ALL F Sy. tout SY ALL I Tutto il sistema SY ALL JA すべて同期 SY ALL KO Sy 모두 SY ALL PTB Sy - Tudo SY ALL RU С. все SY ALL TR SY ALL SY ALL US Sy All SY ALL ZHS 全部同步 SY ALL 5 10 :p_legal_entity_id LOV Oracle GMF_SRS_LEGAL_ENTITY Y select legal_entity_id id, legal_entity_name value, null description from gmf_legal_entities where legal_entity_id in (select legal_entity_id from gmf_fiscal_policies) order by legal_entity_name SELECT legal_entity_name FROM gmf_legal_entities where legal_entity_id=:PARAMETER.NUMBER1 Y AR الكيان القانوني الكيان القانوني D Mandant Mandant E Entidad Jurídica Entidad Jurídica F Entité juridique Entité juridique I Persona giuridica Persona giuridica JA 法的エンティティ 法的エンティティ KO 법인 법인 PTB Pessoa Jurídica Pessoa Jurídica RU Юридическое лицо Юридическое лицо S Juridisk enhet Juridisk enhet TR Tüzel Kişilik Tüzel Kişilik US Legal Entity Legal Entity ZHS 法人主体 法人主体 6 20 :p_cost_type_id LOV Oracle GMF_SRS_LOT_COST_TYPES Y select mthd.cost_type_id id, mthd.cost_mthd_code value, mthd.cost_mthd_desc description from cm_mthd_mst mthd where mthd.cost_type=6 and delete_mark=0 order by mthd.cost_mthd_code SELECT distinct cost_mthd_code FROM cm_mthd_mst WHERE cost_type = 6 and cost_type_id = :PARAMETER.NUMBER2 Y AR نوع التكلفة نوع التكلفة D Kostenrechnungsart Kostenrechnungsart E Tipo de Coste Tipo de Coste F Type de coût Type de coût I Tipo di costo Tipo di costo JA 原価タイプ 原価タイプ KO 원가 유형 원가 유형 PTB Tipo de Custo Tipo de Custo RU Тип затрат Тип затрат S Kostnadstyp Kostnadstyp TR Maliyet Tipi Maliyet Tipi US Cost Type Cost Type ZHS 成本类型 成本类型 7 30 :p_from_organization_id LOV Oracle GMF_SRS_FROM_ORGANIZATION Y select ood.organization_id id, ood.organization_code value, ood.organization_name description from org_organization_definitions ood,mtl_parameters mp where ood.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and ood.legal_entity=:$flex$.gmf_srs_legal_entity order by value,description SELECT distinct organization_code FROM mtl_parameters WHERE organization_id = :PARAMETER.NUMBER4 AR من التنظيم من التنظيم D Von Organisation Von Organisation E De Organización De Organización F Organisation d'origine Organisation d'origine I Organizzazione - Da Organizzazione - Da JA 組織:自 組織:自 KO 조직: 부터 조직: 부터 PTB Da Organização Da Organização RU Организация с Организация с S Från organisation Från organisation TR İlk Organizasyon İlk Organizasyon US From Organization From Organization ZHS 起始组织 起始组织 8 40 :p_to_organization_id LOV Oracle GMF_SRS_TO_ORGANIZATION Y select ood.organization_id id, ood.organization_code value, ood.organization_name description from org_organization_definitions ood,mtl_parameters mp where ood.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and ood.legal_entity=:$flex$.gmf_srs_legal_entity and ood.organization_code>=:$flex$.gmf_srs_from_organization.value order by value,description SELECT distinct organization_code FROM mtl_parameters WHERE organization_id = :PARAMETER.NUMBER4 AR إلى التنظيم إلى التنظيم D Nach Organisation Nach Organisation E A Organización A Organización F Organisation - A Organisation - A I Organizzazione - A Organizzazione - A JA 組織:至 組織:至 KO 조직: 까지 조직: 까지 PTB Organização - Até Organização - Até RU Организация по Организация по S Till organisation Till organisation TR Son Organizasyon Son Organizasyon US To Organization To Organization ZHS 目标组织 目标组织 9 50 :p_from_item_id Char SELECT distinct item_number FROM mtl_item_flexfields where inventory_item_id = :PARAMETER.NUMBER3 AR P_FROM_ITEM من الصنف D P_FROM_ITEM Von Artikel E P_FROM_ITEM De Artículo F P_FROM_ITEM Article - De I P_FROM_ITEM Articolo - Da JA P_FROM_ITEM 品目:自 KO P_FROM_ITEM 품목: 부터 PTB P_FROM_ITEM Item - De RU P_FROM_ITEM Позиция с S P_FROM_ITEM Från artikel TR P_FROM_ITEM İlk Kalem US P_FROM_ITEM From Item ZHS P_FROM_ITEM 起始物料 10 60 :p_to_item_id Char SELECT distinct item_number FROM mtl_item_flexfields where inventory_item_id = :PARAMETER.NUMBER3 AR P_TO_ITEM إلى الصنف D P_TO_ITEM Bis Artikel E P_TO_ITEM A Artículo F P_TO_ITEM Article - A I P_TO_ITEM Articolo - A JA P_TO_ITEM 品目:至 KO P_TO_ITEM 품목: 까지 PTB P_TO_ITEM Item - Até RU P_TO_ITEM Позиция по S P_TO_ITEM Till artikel TR P_TO_ITEM Son Kalem US P_TO_ITEM To Item ZHS P_TO_ITEM 终止物料 11 70 :p_from_lot LOV Oracle GMF_SRS_FROM_LOT_NUMBERS Y select lot_number id, lot_number value, null description from mtl_lot_numbers where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and inventory_item_id=:$flex$.p_from_item order by lot_number AR من اللوط من اللوط D Von Charge Von Charge E De Lote De Lote F Lot - Du Lot - Du I Lotto - Da Lotto - Da JA ロット:自 ロット:自 KO 시작 로트 시작 로트 PTB Lote - De Lote - De RU Партия с Партия с S Från parti Från parti TR İlk Lot İlk Lot US From Lot From Lot ZHS 起始批次 起始批次 12 80 :p_to_lot LOV Oracle GMF_SRS_TO_LOT_NUMBERS Y select lot_number id, lot_number value, null description from mtl_lot_numbers where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and inventory_item_id=:$flex$.p_to_item order by lot_number AR إلى اللوط إلى اللوط D Bis Charge Bis Charge E A Lote A Lote F Lot - A Lot - A I Lotto - A Lotto - A JA ロット:至 ロット:至 KO 종료 로트 종료 로트 PTB Lote - Até Lote - Até RU Партия по Партия по S Till parti Till parti TR Son Lot Son Lot US To Lot To Lot ZHS 终止批次 终止批次 13 90 :p_from_cost_category_id Char AR من فئة تكلفة الصنف من فئة تكلفة الصنف D Von Artikelkostenkategorie Von Artikelkostenkategorie E De Categoría de Coste de Artículo De Categoría de Coste de Artículo F Catégorie de coût article - De Catégorie de coût article - De I Categoria costo articolo - Da Categoria costo articolo - Da JA 品目原価カテゴリ:自 品目原価カテゴリ:自 KO 시작 품목 원가 범주 시작 품목 원가 범주 PTB De - Categoria de Custo do Item De - Categoria de Custo do Item RU Категория стоимости позиций с Категория стоимости позиций с S Från artikelkostnadskategori Från artikelkostnadskategori TR İlk Kalem Maliyet Kategorisi İlk Kalem Maliyet Kategorisi US From Item Cost Category From Item Cost Category ZHS 起始项目成本类别 起始项目成本类别 14 100 :p_to_cost_category_id Char AR إلى فئة تكلفة الصنف إلى فئة تكلفة الصنف D Bis Artikelkostenkategorie Bis Artikelkostenkategorie E A Categoría de Coste de Artículo A Categoría de Coste de Artículo F Catégorie de coût article - A Catégorie de coût article - A I Categoria costo articolo - A Categoria costo articolo - A JA 品目原価カテゴリ:至 品目原価カテゴリ:至 KO 종료 품목 원가 범주 종료 품목 원가 범주 PTB Até - Categoria de Custo do Item Até - Categoria de Custo do Item RU Категория стоимости позиций по Категория стоимости позиций по S Till artikelkostnadskategori Till artikelkostnadskategori TR Son Kalem Maliyet Kategorisi Son Kalem Maliyet Kategorisi US To Item Cost Category To Item Cost Category ZHS 终止项目成本类别 终止项目成本类别 15 110 :p_currency_code LOV Oracle GMF_GL_CURRENCY Y select currency_code id, currency_code value, description description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code SELECT base_currency_code FROM gmf_fiscal_policies where legal_entity_id = :$flex$.legal_entity AR العملة رمز العملة D Währung Währung E Divisa Código de Divisa F Devise Code devise I Divisa Codice divisa JA 通貨 通貨コード KO 통화 통화 코드 PTB Moeda Cód. da Moeda RU Валюта Код валюты S Valuta Valutakod TR Para Birimi Para Birimi Kodu US Currency Currency Code ZHS 币种 币种代码 16 120 :p_exchange_rate Number 1.000000000000000 AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs E Tipo de Cambio Tipo de Cambio F Taux de change Taux de change I Tasso di cambio Tasso di cambio JA 換算レート 換算レート KO 환율 환율 PTB Taxa de Câmbio Taxa de Câmbio RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz Kuru US Exchange Rate Exchange Rate ZHS 汇率 汇率 :$flex$.gmf_srs_from_organization.value From Organization To Organization value :$flex$.gmf_srs_legal_entity Legal Entity From Organization :$flex$.gmf_srs_legal_entity Legal Entity To Organization :$flex$.legal_entity Legal Entity Currency :$flex$.p_from_item P_FROM_ITEM From Lot :$flex$.p_to_item P_TO_ITEM To Lot