ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FBA51A9E05362FB09050512 SELECT DISTINCT prod_ind, BEXP.ORDER_LINK, LEVEL2 C_LEVEL, cpt.cost_cmpntcls_code C_COST_COMPONENT, (LEVEL2 || cpt.cost_cmpntcls_code|| cpt.c_usage || cpt.cost_analysis_code || formulaline_id) C_LC, cpt.C_USAGE, cpt.cost_analysis_code C_ANALYSIS_CODE, /* Item_name C_ITEM_NAME, */ /* Commented against BUG#14102431 */ Decode(prod_ind, 'P', Item_name||' '||rcp, Item_name) C_ITEM_NAME, /* Added against BUG#14102431 */ /* (TO_NUMBER(SUBSTR(QTY,1,(INSTR(QTY,'/')-1))) * (SUM(cst.cmpnt_cost) OVER (PARTITION BY cst.organization_id,cst.inventory_item_id,LEVEL2,ccm.cost_cmpntcls_code,cst.cost_analysis_code))) C_EXT_COMP_COST, */ /* Commented against BUG#14102431 */ (TO_NUMBER((SUBSTR(qty,1,(INSTR(qty,'/')-1))+ (SUBSTR(qty,1,(INSTR(qty,'/')-1)) * scrap_factor))) * (cpt.unit_cost1)) C_EXT_COMP_COST, /* Added against BUG#14102431 */ cpt.unit_cost1 C_COMPONENT_COST, DECODE(LEVEL2,0,(TO_NUMBER((SUBSTR(qty,1,(INSTR(qty,'/')-1))+ (SUBSTR(qty,1,(INSTR(qty,'/')-1)) * scrap_factor))) * (cpt.unit_cost1)),0) C_EXT_COMP_COST1, /* Added against BUG#14102431 */ DECODE(LEVEL2,0,cpt.unit_cost1,0) C_COMPONENT_COST1, /* DECODE(prod_ind,'P', (TO_NUMBER(SUBSTR(QTY,1,(INSTR(QTY,'/')-1))) * (SUM(cst.cmpnt_cost) OVER (PARTITION BY cst.inventory_item_id,cst.organization_id ))) , (TO_NUMBER(SUBSTR(QTY,1,(INSTR(QTY,'/')-1))) * bexp.cost_alloc * (SUM(cst.cmpnt_cost) OVER (PARTITION BY cst.inventory_item_id,cst.organization_id ))) )C_EXT_UNIT_COST, */ /* Commented against BUG#14102431 */ DECODE(prod_ind,'P', (TO_NUMBER((SUBSTR(qty,1,(INSTR(qty,'/')-1))+ (SUBSTR(qty,1,(INSTR(qty,'/')-1)) * scrap_factor))) * (cpt.unit_cost1)), (TO_NUMBER((SUBSTR(qty,1,(INSTR(qty,'/')-1))+ (SUBSTR(qty,1,(INSTR(qty,'/')-1)) * scrap_factor))) * bexp.cost_alloc * (cpt.unit_cost1)) )C_EXT_UNIT_COST, /* Added against BUG#14102431 */ cpt.unit_cost1 C_UNIT_COST, /* TO_NUMBER(SUBSTR(QTY,1,(INSTR(QTY,'/')-1))) C_QUANTITY, */ /* Commented against BUG#14102431 */ TO_NUMBER((SUBSTR(qty,1,(INSTR(qty,'/')-1))+ (SUBSTR(qty,1,(INSTR(qty,'/')-1)) * scrap_factor))) C_QUANTITY, /* Added against BUG#14102431 */ LTRIM(SUBSTR(QTY,(INSTR(QTY,'/')+1)),' ') C_UOM, DECODE(cpt.unit_cost1,0,0,( ((cpt.unit_cost1)/(cpt.unit_cost1))* 100)) C_PERCENTAGE, FORMULA_QTY C_FORMULA_QTY, FORMULA_UOM C_FORMULA_UOM, primary_uom_code,secondary_uom_code, DECODE(secondary_uom_code,NULL,NULL, inv_convert.inv_um_convert( bexp.item_id, NULL, bexp.organization_id, 5, TO_NUMBER(SUBSTR(QTY,1,(INSTR(QTY,'/')-1))), bexp.primary_uom_code, bexp.secondary_uom_code, NULL, NULL) ) C_SECONDARY_QTY FROM (SELECT SYS_CONNECT_BY_PATH (ccd.INVENTORY_ITEM_ID,'.') ORDER_LINK, DECODE(fmd.line_type,1,DECODE(grv.inventory_item_id,fmd.inventory_item_id,'P','C'),-1,'I',2,'B') prod_ind,CONNECT_BY_ISLEAF isleaf, DECODE(fmd.line_type,1,(LEVEL-1),LEVEL) LEVEL2, msi.concatenated_segments Item_name, msi.primary_uom_code,msi.secondary_uom_code,msi.dual_uom_control, ccd.INVENTORY_ITEM_ID PRODUCT_ITEM, ccd.organization_id, ccd.fmeff_id, grv.std_qty, gr.formula_id, ffm.formula_no ||'-VER:' || ffm.formula_vers FORMULA_DTL, fmd.line_type,fmd.scrap_factor,fmd.INVENTORY_ITEM_ID ITEM_ID, fmd.qty FORMULA_QTY,fmd.formulaline_id,fmd.detail_uom FORMULA_UOM, /* Added fmd.scrap_factor against BUG#14102431 */ gmf_cbom_rep_pkg.Get_cost_alloc(fmd.inventory_item_id, ccd.inventory_item_id, DECODE(fmd.line_type,1,DECODE(grv.inventory_item_id,fmd.inventory_item_id,'P','C'), -1,'I',2,'B'), msi.organization_id, ccd.cost_type_id, ccd.period_id, fmd.qty) Cost_alloc, ccd.period_id, ccd.cost_type_id, gr.recipe_id, 'Recipe:' || (gr.RECIPE_NO || '/'|| gr.RECIPE_VERSION) RCP,grv.revision,grv.detail_uom, gmf_cbom_rep_pkg.Get_Quantity(fmd.inventory_item_id, ccd.inventory_item_id, DECODE(fmd.line_type,1,DECODE(grv.inventory_item_id,fmd.inventory_item_id,'P','C'), -1,'I',2,'B'), msi.organization_id, ccd.cost_type_id, ccd.period_id, fmd.qty) QTY FROM (SELECT DISTINCT ORGANIZATION_ID, INVENTORY_ITEM_ID, period_id, cost_type_id, fmeff_id FROM cm_cmpt_dtl WHERE period_id = &P_PERIOD_ID AND cost_type_id = &P_COST_TYPE_ID AND organization_id = &H_ORG_ID) ccd, gmd_recipes_b gr, gmd_recipe_validity_rules grv, (select fmd.* from fm_matl_dtl fmd,fm_form_mst_b ffm where ffm.formula_id = fmd.formula_id AND ffm.FORMULA_STATUS in (700,900)) fmd, fm_form_mst_b ffm, mtl_system_items_b_kfv msi WHERE gr.recipe_id = grv.recipe_id AND ccd.fmeff_id = grv.recipe_validity_rule_id AND ccd.INVENTORY_ITEM_ID = grv.INVENTORY_ITEM_ID AND ccd.organization_id = NVL(grv.organization_id,ccd.organization_id) AND msi.INVENTORY_ITEM_ID = fmd.INVENTORY_ITEM_ID AND gr.recipe_status in (700,900) AND ccd.organization_id = msi.organization_id AND fmd.formula_id = gr.formula_id AND ffm.formula_id = fmd.formula_id AND ccd.organization_id = &H_ORG_ID /*26003084 */ AND grv.delete_mark = 0 AND NOT EXISTS (SELECT 1 FROM gmd_recipe_validity_rules grv1 WHERE grv.preference > grv1.preference AND grv.inventory_item_id = grv1.inventory_item_id ) AND NOT EXISTS (SELECT 1 FROM gmd_recipe_validity_rules grv1 WHERE grv.recipe_use < grv1.recipe_use AND grv.recipe_id = grv1.recipe_id ) /*26003084 */ START WITH ccd.inventory_item_id = &H_ITEM_ID AND ccd.fmeff_id IS NOT NULL CONNECT BY PRIOR fmd.INVENTORY_ITEM_ID = ccd.INVENTORY_ITEM_ID AND msi.organization_id = ccd.organization_id AND PRIOR fmd.line_type <> 1 ) BEXP, /* cm_cmpt_mst ccm, cm_cmpt_dtl cst */ /* Commented against BUG#14102431 */ (SELECT ccd.inventory_item_id,ccd.organization_id, ccd.period_id, ccd.cost_type_id, ccd.cost_analysis_code,ccm.cost_cmpntcls_code, DECODE(ccm.usage_ind, 1, 'Material',2, 'Overhead',3, 'Resource',4, 'Expense Alloc',5, 'Std Cost Adj') C_USAGE, SUM(ccd.cmpnt_cost * DECODE(ccm.usage_ind, 1, 1, 0)) material_cost, SUM(ccd.cmpnt_cost * DECODE(ccm.usage_ind, 3, 1, 0)) resource_cost, SUM(ccd.cmpnt_cost * DECODE(ccm.usage_ind, 2, 1, 0)) fixed_overhead, SUM(ccd.cmpnt_cost * DECODE(ccm.usage_ind, 5, 1, 0)) std_cost_adj, SUM(ccd.cmpnt_cost) unit_cost1 FROM cm_cmpt_dtl ccd, cm_cmpt_mst ccm WHERE ccm.cost_cmpntcls_id = ccd.cost_cmpntcls_id AND ccd.period_id = &P_PERIOD_ID AND ccd.cost_type_id = &P_COST_TYPE_ID AND ccd.organization_id = &H_ORG_ID GROUP BY ccd.inventory_item_id,ccd.organization_id ,ccd.period_id,ccd.cost_type_id, ccd.cost_analysis_code,ccm.cost_cmpntcls_code,ccm.usage_ind) cpt /* Added cpt against BUG#14102431 */ WHERE 1 = 1 /* DECODE(BEXP.ISLEAF,0,(DECODE(BEXP.PROD_IND,'I',-1,BEXP.PROD_IND)),BEXP.ISLEAF) = 1 */ /* Commented against BUG#14102431 */ AND BEXP.PROD_IND <> 'C' AND cpt.inventory_item_id = BEXP.item_id AND BEXP.period_id = cpt.period_id AND BEXP.cost_type_id = cpt.cost_type_id AND BEXP.organization_id = cpt.organization_id AND BEXP.LEVEL2 <= NVL(&P_MAX_LEVELS,BEXP.LEVEL2) ORDER BY BEXP.ORDER_LINK,BEXP.LEVEL2,cpt.cost_cmpntcls_code,cpt.c_usage,cpt.cost_analysis_code,C_Item_name Y GMF GMFCIBOM AR GMF تقرير شجرة المنتجات المجزأة محددة التكاليف Imported from BI Publisher Application: ماليات التصنيع التشغيلي Source: تقرير شجرة المنتجات المجزأة محددة التكاليف Short Name: GMFCIBOM DB package: D GMF Bewertete mehrstufige Rezepturauswertung Imported from BI Publisher Application: Process Manufacturing Financials Source: Bewertete mehrstufige Rezepturauswertung Short Name: GMFCIBOM DB package: E GMF Informe de lista de materiales multinivel con costes Imported from BI Publisher Application: Process Manufacturing Financials Source: Informe de lista de materiales multinivel con costes Short Name: GMFCIBOM DB package: F GMF Etat Nomenclature arborescente valorisée Imported from BI Publisher Application: Process Manufacturing Financials Source: Etat Nomenclature arborescente valorisée Short Name: GMFCIBOM DB package: I GMF Rapporto Distinte base ramificate attribuite a costi Imported from BI Publisher Application: Process Manufacturing Financials Source: Rapporto Distinte base ramificate attribuite a costi Short Name: GMFCIBOM DB package: JA GMF 原価階層フォーミュラ・レポート Imported from BI Publisher Application: Process Manufacturing Financials Source: 原価階層フォーミュラ・レポート Short Name: GMFCIBOM DB package: KO GMF 원가 계산된 다단계 BOM 보고서 Imported from BI Publisher Application: Process Manufacturing Financials Source: 원가 계산된 다단계 BOM 보고서 Short Name: GMFCIBOM DB package: PTB GMF Relatório de Lista de Materiais Endentadas Custeadas Imported from BI Publisher Application: Process Manufacturing Financials Source: Relatório de Lista de Materiais Endentadas Custeadas Short Name: GMFCIBOM DB package: RU GMF Отчет об оценке многоуровневых спецификаций Imported from BI Publisher Application: Финансы УНП Source: Отчет об оценке многоуровневых спецификаций Short Name: GMFCIBOM DB package: S GMF Kostn.beräkn. nivåindelad produktstruktur - rapport Imported from BI Publisher Application: Processtillverkning: Ekonomi Source: Kostn.beräkn. nivåindelad produktstruktur - rapport Short Name: GMFCIBOM DB package: TR GMF Maliyetlendirilmiş Girintili Ürün Ağacı Raporu Imported from BI Publisher Application: Üretim Prosesi Finansal Yönetim Source: Maliyetlendirilmiş Girintili Ürün Ağacı Raporu Short Name: GMFCIBOM DB package: US GMF Costed Indented Bill of Materials Imported from BI Publisher Application: Process Manufacturing Financials Source: Costed Indented Bill of Materials Report Short Name: GMFCIBOM DB package: ZHS GMF 已计成本多级物料清单报表 Imported from BI Publisher Application: OPM 财务管理系统 Source: 已计成本多级物料清单报表 Short Name: GMFCIBOM DB package: BI Publisher &h_item_id &h_org_id &p_cost_type_id &p_max_levels &p_period_id :p_where_clause 1 -10 :p_dummy_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 struttura fittizia JA ダミー体系ID ダミー体系ID KO Dummay 구조 ID Dummay 구조 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 Dummay Structure ID Dummay Structure ID ZHS 虚拟结构标识 虚拟结构标识 2 10 :p_legal_entity_id LOV Oracle GMF_SRS_LEGAL_ENTITIES_VS Y select gfp.legal_entity_id id, glp.legal_entity_name value, null description from gmf_legal_entities glp,gmf_fiscal_policies gfp where glp.legal_entity_id=gfp.legal_entity_id order by glp.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 法人主体 法人主体 3 20 :p_calendar_code LOV Oracle GMF_SRS_CALENDAR_CODE_VS Y select h.calendar_code id, h.calendar_code value, h.calendar_desc description from cm_cldr_hdr h where exists (select 1 from gmf_period_statuses gps where gps.legal_entity_id=:$flex$.gmf_srs_legal_entities_vs and gps.calendar_code=h.calendar_code) order by h.calendar_code SELECT calendar_code FROM cm_cldr_hdr_tl where calendar_code = :PARAMETER.CHAR1 AND language = userenv('LANG') Y AR التقويم التقويم D Kalender Kalender E Calendario Calendario F Calendrier Calendrier I Calendario Calendario JA カレンダ カレンダ KO 달력 달력 PTB Calendário Calendário RU Календарь Календарь S Kalender Kalender TR Takvim Takvim US Calendar Calendar ZHS 日历 日历 4 30 :p_period_code LOV Oracle GMF_SRS_PERIOD_CODE_VS Y select d.period_code id, d.period_code value, d.period_desc description from cm_cldr_dtl d where exists (select 1 from gmf_period_statuses gps where gps.calendar_code=:$flex$.gmf_srs_calendar_code_vs and gps.legal_entity_id=:$flex$.gmf_srs_legal_entities_vs and gps.period_code=d.period_code and gps.calendar_code=d.calendar_code ) order by d.end_date SELECT period_code FROM gmf_period_statuses where period_id = :PARAMETER.NUMBER2 Y AR الفترة رمز الفترة D Periode Periodencode E Período Código de Período F Période Code période I Periodo Codice periodo JA 期間 期間コード KO 기간 기간 코드 PTB Período Código do Período RU Период Код периода S Period Periodkod TR Dönem Dönem Kodu US Period Period Code ZHS 期间 期间代码 5 40 :p_cost_type_id LOV Oracle GMF_SRS_STAND_COST_TYPE Y select cm.cost_type_id id, cm.cost_mthd_code value, cm.cost_mthd_desc description from gmf_period_statuses gps,cm_mthd_mst cm where gps.legal_entity_id=:$flex$.gmf_srs_legal_entities_vs and gps.calendar_code=:$flex$.gmf_srs_calendar_code_vs and gps.period_code=:$flex$.gmf_srs_period_code_vs and gps.cost_type_id=cm.cost_type_id and cm.cost_type=0 order by cm.cost_mthd_code SELECT distinct cost_mthd_code FROM cm_mthd_mst WHERE cost_type_id = :PARAMETER.NUMBER3 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 成本类型 成本类型 6 50 :p_from_organization LOV Oracle GMF_SRS_ORGANIZATIONS_VS Y select organization_code id, organization_code value, organization_name description from gmf_organization_definitions where legal_entity_id=:$flex$.gmf_srs_legal_entities_vs order by value,description SELECT 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 起始组织 起始组织 7 60 :p_to_organization LOV Oracle GMF_SRS_ORGANIZATIONS_VS Y select organization_code id, organization_code value, organization_name description from gmf_organization_definitions where legal_entity_id=:$flex$.gmf_srs_legal_entities_vs order by value,description SELECT organization_code FROM mtl_parameters WHERE organization_id = :PARAMETER.NUMBER5 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 目标组织 目标组织 8 70 :p_from_item_id Char SELECT concatenated_segments FROM mtl_system_items_b_kfv WHERE inventory_item_id = TO_NUMBER(:PARAMETER.CHAR2) AND organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') AR من الصنف من الصنف D Von Artikel Von Artikel E De Artículo De Artículo F Article - De Article - De I Articolo - Da Articolo - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR İlk Kalem İlk Kalem US From Item From Item ZHS 起始物料 起始物料 9 80 :p_to_item_id Char SELECT concatenated_segments FROM mtl_system_items_b_kfv WHERE inventory_item_id = TO_NUMBER(:PARAMETER.CHAR3) AND organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') AR إلى الصنف إلى الصنف D Bis Artikel Bis Artikel E A Artículo A Artículo F Article - A Article - A I Articolo - A Articolo - A JA 品目:至 品目:至 KO 품목: 까지 품목: 까지 PTB Item - Até Item - Até RU Позиция по Позиция по S Till artikel Till artikel TR Son Kalem Son Kalem US To Item To Item ZHS 终止物料 终止物料 10 90 :p_from_cost_category_id Char SELECT concatenated_segments FROM mtl_categories_kfv WHERE concatenated_segments =:PARAMETER.CHAR4 AND structure_id = :$flex$.dummay_structure_id AR من فئة التكلفة من فئة التكلفة D Von Kostenkategorie Von Kostenkategorie E De Categoría de Coste De Categoría de Coste F Catégorie de coût - De Catégorie de coût - De I Categoria costi - Da Categoria costi - Da JA 原価カテゴリ:自 原価カテゴリ:自 KO 시작 원가 범주 시작 원가 범주 PTB De - Categoria de Custo De - Categoria de Custo RU Категория затрат с Категория затрат с S Från kostnadskategori Från kostnadskategori TR İlk Maliyet Kategorisi İlk Maliyet Kategorisi US From Cost Category From Cost Category ZHS 起始成本类别 起始成本类别 11 100 :p_to_cost_category_id Char SELECT concatenated_segments FROM mtl_categories_kfv WHERE concatenated_segments =:PARAMETER.CHAR5 AND structure_id = :$flex$.dummay_structure_id AR إلى فئة التكلفة إلى فئة التكلفة D Bis Kostenkategorie Bis Kostenkategorie E A Categoría de Coste A Categoría de Coste F Catégorie de coût - A Catégorie de coût - A I Categoria costi - A Categoria costi - A JA 原価カテゴリ:至 原価カテゴリ:至 KO 종료 원가 범주 종료 원가 범주 PTB Até - Categoria de Custo Até - Categoria de Custo RU Категория затрат по Категория затрат по S Till kostnadskategori Till kostnadskategori TR Son Maliyet Kategorisi Son Maliyet Kategorisi US To Cost Category To Cost Category ZHS 终止成本类别 终止成本类别 12 110 :p_max_levels Number 10 Y AR الحد الأقصى لمستويات شجرة المنتجات الحد الأقصى لمستويات شجرة المنتجات D Maximale Stücklistenebenen Maximale Stücklistenebenen E Niveles Máximos de BOM Niveles Máximos de BOM F Niveaux de nomenclature maximum Niveaux de nomenclature maximum I Livelli massimi distinta base Livelli massimi distinta base JA 最大BOMレベル 最大BOMレベル KO 최대 BOM 레벨 최대 BOM 레벨 PTB Níveis Máximos de BOM Níveis Máximos de BOM RU Максимальное число уровней спецификации Максимальное число уровней спецификации S Maximala STR-nivåer Maximala STR-nivåer TR Maksimum Ürün Ağacı Düzeyi Maksimum Ürün Ağacı Düzeyi US Maximum BOM Levels Maximum BOM Levels ZHS 最大 BOM 层 最大 BOM 层 13 120 :p_ident_chars Number 2 Y AR أحرف التجزئة أحرف التجزئة D Einrückungszeichen Einrückungszeichen E Caracteres Multinivel Caracteres Multinivel F Caractères d'indentation Caractères d'indentation I Caratteri di ramificazione Caratteri di ramificazione JA 階層文字 階層文字 KO 들여쓰기 문자 들여쓰기 문자 PTB Caracteres de Endentação Caracteres de Endentação RU Символы отступа Символы отступа S Indragstecken Indragstecken TR Satır Başı Karakterler Satır Başı Karakterler US Indentation Characters Indentation Characters ZHS 缩排字符 缩排字符 14 130 :p_report_type LOV Oracle GMF_SRS_CIBOM_REPORT_TYPE_VS Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='GMF_CIBOM_REPORT_TYPE' and enabled_flag='Y' order by value,description SELECT Meaning FROM GEM_LOOKUPS WHERE lookup_type = 'GMF_CIBOM_REPORT_TYPE' AND lookup_code = 1 AND enabled_flag = 'Y' Y AR نوع التقرير نوع التقرير D Auswertungsart Auswertungsart E Tipo de Informe Tipo de Informe F Type d'état Type d'état I Tipo di rapporto Tipo di rapporto JA レポート・タイプ レポート・タイプ KO 보고서 유형 보고서 유형 PTB Tipo de Relatório Tipo de Relatório RU Тип отчета Тип отчета S Rapporttyp Rapporttyp TR Rapor Tipi Rapor Tipi US Report Type Report Type ZHS 报表类型 报表类型 15 140 :p_sort_by LOV Oracle GMF_SRS_CIBOM_SORT_BY_VS Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='GMF_CIBOM_SORT_BY' and enabled_flag='Y' order by value,description SELECT Meaning FROM GEM_LOOKUPS WHERE lookup_type = 'GMF_CIBOM_SORT_BY' AND lookup_code = 1 AND enabled_flag = 'Y' 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 排序依据 排序依据 :$flex$.dummay_structure_id Dummay Structure ID From Cost Category :$flex$.dummay_structure_id Dummay Structure ID To Cost Category :$flex$.gmf_srs_calendar_code_vs Calendar Cost Type :$flex$.gmf_srs_calendar_code_vs Calendar Period :$flex$.gmf_srs_legal_entities_vs Legal Entity Calendar :$flex$.gmf_srs_legal_entities_vs Legal Entity Cost Type :$flex$.gmf_srs_legal_entities_vs Legal Entity From Organization :$flex$.gmf_srs_legal_entities_vs Legal Entity Period :$flex$.gmf_srs_legal_entities_vs Legal Entity To Organization :$flex$.gmf_srs_period_code_vs Period Cost Type