ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FFA51A9E05362FB09050512 select sys.item_number, sys.description, com.sequence_number, com.compile_quantity, round (nvl(com.compile_value,0), :C_std_prec) compile_value, to_number(decode (com.compile_quantity, 0, null, round(com.compile_value / com.compile_quantity, :C_std_prec) ) ) compile_unit_cost, sys1.primary_uom_code uom, decode (sys1.planning_make_buy_code, null,'', mfg.meaning ) org_code, decode(:P_DisplayCumValue, 1, round(com.cumulative_value,:C_std_prec), 2, com.cumulative_quantity, decode( decode( hdr.compile_type, 1,1,4,1,5,1,7,1,9,1,10,1,2), 1, com.cumulative_quantity, round(com.cumulative_value,:C_std_prec) )) cumulative_column, decode( :P_DisplayCumValue, 1,2, 2,1, decode(hdr.compile_type, 1,1,4,1,5,1,7,1,9,1,10,1,2)) qty_base from mfg_lookups mfg, mtl_item_flexfields sys, mtl_abc_compile_headers hdr, mtl_system_items sys1, mtl_abc_compiles com where sys.organization_id = :ORGANIZATION_ID and sys1.organization_id = :ORGANIZATION_ID and com.organization_id = :ORGANIZATION_ID and com.compile_id = hdr.compile_id and hdr.organization_id = com.organization_id and com.compile_id = :COMPILE_ID and com.inventory_item_id = sys.item_id and sys1.inventory_item_id = sys.item_id and ( mfg.lookup_code = decode(sys1.planning_make_buy_code,NULL,2, sys1.planning_make_buy_code) and mfg.lookup_type = 'MTL_PLANNING_MAKE_BUY' ) ORDER BY com.sequence_number Y INV INVARADV_XML AR INV تقرير قيمة ABC التنازلية (بتنسيق XML) Imported from BI Publisher Description: تقرير القيمة التنازلية ABC Application: المخازن Source: تقرير قيمة ABC التنازلية (بتنسيق XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG D INV ABC-Rangfolgebewertung Imported from BI Publisher Description: ABC-Rangfolgebewertung Application: Lager Source: ABC-Rangfolgebewertung (XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG E INV Valores Descendentes ABC Imported from BI Publisher Description: Valores Descendentes ABC Application: Inventory Source: Valores Descendentes ABC (XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG F INV Classification ABC par valeur décroissante Imported from BI Publisher Description: Classification ABC par valeur décroissante Application: Inventory Source: Classification ABC par valeur décroissante (XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG I INV Rapporto Valori ABC in ordine decrescente Imported from BI Publisher Description: Rapporto Valori ABC in ordine decrescente Application: Inventory Source: Rapporto Valori ABC in ordine decrescente (XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG JA INV ABC降順レポート Imported from BI Publisher Description: ABC降順レポート Application: Inventory Source: ABC降順レポート(XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG KO INV ABC 내림차순 금액 보고서 Imported from BI Publisher Description: ABC 내림차순 금액 보고서 Application: Inventory Source: ABC 내림차순 금액 보고서(XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG PTB INV Relatório de valor decrescente ABC Imported from BI Publisher Description: Relatório de valor decrescente ABC Application: Inventário Source: Relatório de valor decrescente ABC (XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG RU INV Результаты анализа ABC, упорядоченные по убыванию Imported from BI Publisher Description: Результаты анализа ABC, упорядоченные по убыванию Application: Запасы Source: Результаты анализа ABC, упорядоченные по убыванию (XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG S INV Fallande värde - rapport Imported from BI Publisher Description: ABC: minskande värde - rapport Application: Inventory Source: ABC: Fallande värde - rapport (XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG TR INV ABC azalan değer raporu Imported from BI Publisher Description: ABC azalan değer raporu Application: Stok Yönetimi Source: ABC azalan değer raporu (XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG US INV ABC descending value Imported from BI Publisher Description: ABC descending value report Application: Inventory Source: ABC descending value report (XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG ZHS INV ABC 降序值报表 Imported from BI Publisher Description: ABC 降序值报表 Application: 库存管理系统 Source: ABC 降序值报表 (XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG BI Publisher :c_std_prec :compile_id :organization_id :p_cbo_flag :p_conc_request_id :p_displaycumvalue :p_qty_precision :p_trace_flag :qty_precision 1 -20 :organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 2 10 :compile_id LOV Oracle INV_SRS_COMPILE_HDR Y select compile_id id, compile_name value, null description from mtl_abc_compile_headers where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and compile_status=2 order by compile_name Y AR عنوان تجميع ABC عنوان التجميع D Kopfdaten ABC-Lauf Kopfdaten ABC-Lauf E Cabecera de Compilación ABC Cabecera de Compilación F En-tête calcul ABC En-tête calcul I Intestazione compilazione ABC Intestazione compilazione JA ABC集計ヘッダー 集計ヘッダー KO ABC 컴파일 헤더 컴파일 헤더 PTB Cabeçalho de Compilação ABC Cabeçalho de Compilação RU Заголовок анализа ABC Заголовок анализа S ABC-analyshuvud Analyshuvud TR ABC Derleme Başlığı Derleme Başlığı US ABC Compile Header Compile Header ZHS ABC 编译题头 编译题头 3 20 :p_displaycumvalue LOV Oracle INV_SRS_CUMULATIVE_CRITERIA Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_CUMULATIVE_CRITERIA' order by lookup_code AR معايير العرض التراكمي معايير العرض التراكمي D Kumulative Anzeige-Kriterien Kumulative Anzeige-Kriterien E Criterios de Visualización Acumulados Criterios de Visualización Acumulados F Critères d'affichage cumulés Critères d'affichage cumulés I Criteri visualizzazione cumulativi Criteri visualizzazione cumulativi JA 累積表示基準 累積表示基準 KO 누적 표시 기준 누적 표시 기준 PTB Critérios Cumulativos Exibição Critérios Cumulativos Exibição RU Совокупные условия вывода Совокупные условия вывода S Ackumul. visningskriterier Ackumul. visningskriterier TR Kümüle Görüntüleme Ölçütü Kümüle Görüntüleme Ölçütü US Cumulative Display Criteria Cumulative Display Criteria ZHS 累计显示标准 累计显示标准