ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FC151A9E05362FB09050512Y SELECT r.whse_code, r.abc_code, r.rank_desc, r.cnt_intrvl, r.percent_warn, r.percent_reject, r.value_warn, r.value_reject, r.acceptwarn_ind, r.acceptreject_ind, r.delete_mark, w.whse_name FROM ic_rank_mst r,ic_whse_mst w WHERE r.whse_code = w.whse_code AND &RangeCF AND r.delete_mark=decode(:select_criteria,'1',0,'2',1,'3',r.delete_mark,0) ORDER BY &OrdCF GMI PIR01_XML AR GMI تقرير تحديد ترتيب ABC (بتنسيق XML) Imported from BI Publisher Description: تقرير تحديد ترتيب ABC لمخزون OPM الفعلي Application: مخازن التصنيع التشغيلي Source: تقرير تحديد ترتيب ABC (بتنسيق XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG D GMI ABC-Klassen - Auswahl Imported from BI Publisher Description: Auswertung "ABC-Klassen - Auswahl" in OPM PI Application: Process Manufacturing Materialwirtschaft Source: ABC-Klassen - Auswahl (XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG E GMI Selección de Rangos ABC Imported from BI Publisher Description: Informe de selección de rangos ABC de inventario físico de OPM Application: Process Manufacturing Inventory Source: Selección de Rangos ABC (XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG F GMI Sélection de classements ABC Imported from BI Publisher Description: Sélection de classements ABC - OPM PI Application: Process Manufacturing Inventory Source: Sélection de classements ABC (XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG I GMI Rapporto Selezione classe ABC Imported from BI Publisher Description: Rapporto Selezione classe ABC di OPM PI Application: Process Manufacturing Inventory Source: Rapporto Selezione classe ABC (XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG JA GMI ABCランク選択レポート Imported from BI Publisher Description: OPM PI ABCランク選択レポート Application: Process Manufacturing Inventory Source: ABCランク選択レポート(XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG KO GMI ABC 분류 선택 보고서 Imported from BI Publisher Description: OPM PI의 ABC 분류 선택 보고서 Application: Process Manufacturing Inventory Source: ABC 분류 선택 보고서(XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG PTB GMI Relatório de Seleção de Classificação ABC Imported from BI Publisher Description: Relatório de Seleção da Classificação ABC de OPM PI Application: Process Manufacturing Inventory Source: Relatório de Seleção de Classificação ABC (XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG RU GMI Отчет о выборе рангов ABC Imported from BI Publisher Description: Отчет о выборе рангов ABC ОИ УНП Application: Запасы УНП Source: Отчет о выборе рангов ABC (XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG S GMI ABC-rangordningsurval - rapport Imported from BI Publisher Description: ABC-rangordningsval i OPM LI - rapport Application: Process Manufacturing Inventory Source: ABC-rangordningsurval - rapport (XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG TR GMI Alfabetik Sıralı Seçim Raporu Imported from BI Publisher Description: OPM PI Alfabetik Sıralı Seçim Raporu Application: Üretim Prosesi Stok Yönetimi Source: Alfabetik Sıralı Seçim Raporu (XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG US GMI ABC Rank Selection Imported from BI Publisher Description: ABC Rank Selection Report of OPM PI Application: Process Manufacturing Inventory Source: ABC Rank Selection Report (XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG ZHS GMI ABC 级别选择报表 Imported from BI Publisher Description: OPM PI 的 ABC 级别选择报表 Application: OPM 库存管理系统 Source: ABC 级别选择报表 (XML) Short Name: PIR01_XML DB package: GMI_PIR01_XMLP_PKG BI Publisher &ordcf &rangecf :from_rank :from_whse :nonblocksql :order1 :p_conc_request_id :p_orgn :p_rows :rfrom_whse :rto_whse :select_criteria :sort_by :to_rank :to_whse 1 -30 :p_orgn Char fnd_profile.value('GEMMS_DEFAULT_ORGN') AR التنظيم الرئيسي التنظيم الرئيسي D Org. Org. E P Org. P Org. JA 処理組織 処理組織 KO P 조직 P 조직 PTB P org. P org. RU Р-орг. Р-орг. S P org. P org. TR P organizasyonu P organizasyonu US P orgn P orgn ZHS P 组织 P 组织 2 -20 :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 JA 未ブロックSQL 未ブロックSQL KO 비블럭 SQL 비블럭 SQL PTB Sql de Não-Bloqueio Sql de Não-Bloqueio 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 3 10 :sort_by LOV Oracle PI_PIR01_SORT1 Y select lookup_code id, meaning value, description description from fnd_lookup_values where lookup_type='PI_PIR01_SORT' and language=userenv('LANG') order by value,description 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 排序依据 排序依据 4 20 :order LOV Oracle PI_ORDER1 Y select lookup_code id, meaning value, description description from fnd_lookup_values where lookup_type='PI_ORDER' and language=userenv('LANG') order by value,description Y AR الترتيب الترتيب D Sortierfolge Sortierfolge E Orden Orden F Ordre Ordre I Ordine Ordine JA 順 順 KO 순서 순서 PTB Ordem Ordem RU Заказ Заказ TR Düzen Düzen US Order Order ZHS 顺序 顺序 5 30 :from_whse LOV Oracle PI_RK_WHSE Y select whse_code id, whse_code value, whse_name description from ic_whse_mst where delete_mark=0 order by whse_code AR From_Whse من المستودع D From_Whse Von Lager E From_Whse De Almacén F From_Whse Entrepôt - De I From_Whse Warehouse - Da JA From_Whse 倉庫:自 KO From_Whse 창고: 부터 PTB From_Whse Depósito - De RU From_Whse Склад с S From_Whse Från lager TR From_Whse Çıkış Deposu US From_Whse From Whse ZHS From_Whse 起始仓库 6 40 :to_whse LOV Oracle PI_RK_WHSE Y select whse_code id, whse_code value, whse_name description from ic_whse_mst where delete_mark=0 order by whse_code AR To_Whse إلى المستودع D To_Whse Bis Lager E To_Whse A Almacén F To_Whse Entrepôt - A I To_Whse Warehouse - A JA To_Whse 倉庫:至 KO To_Whse 창고: 까지 PTB To_Whse Depósito - Até RU To_Whse Склад по S To_Whse Till lager TR To_Whse Varış Deposu US To_Whse To Whse ZHS To_Whse 终止仓库 7 50 :from_rank LOV Oracle PI_RK_RANK Y select abc_code||':'||whse_code id, abc_code value, rank_desc description from ic_rank_mst where delete_mark=0 and whse_code>=nvl(:$flex$.from_whse:null,whse_code) and whse_code<=nvl(:$flex$.to_whse:null,whse_code) order by abc_code AR من ترتيب من ترتيب D Von Klasse Von Klasse E De Rango De rango F Classement - De Classement - De I Classe - Da Classe - Da JA ランク:自 ランク:自 KO 분류: 부터 분류: 부터 PTB Classificação - De Classificação - De RU Ранг с Ранг с S Från rangordning Från rangordning TR İlk Sıra İlk Sıra US From Rank From Rank ZHS 起始级别 起始级别 8 60 :to_rank LOV Oracle PI_RK_RANK Y select abc_code||':'||whse_code id, abc_code value, rank_desc description from ic_rank_mst where delete_mark=0 and whse_code>=nvl(:$flex$.from_whse:null,whse_code) and whse_code<=nvl(:$flex$.to_whse:null,whse_code) order by abc_code AR إلى ترتيب إلى ترتيب D Bis Klasse Bis Klasse E A Rango A rango F Classement - A Classement - A I Classe - A Classe - A JA ランク:至 ランク:至 KO 분류: 까지 분류: 까지 PTB Classificação - Até Classificação - Até RU Ранг по Ранг по S Till rangordning Till rangordning TR Son Sıra Son Sıra US To Rank To Rank ZHS 终止级别 终止级别 9 70 :select_criteria LOV Oracle PI_SELECTCRITERIA1 Y select lookup_code id, meaning value, description description from fnd_lookup_values where lookup_type='PI_SELECTCRITERIA' and language=userenv('LANG') order by value,description Y AR اختيار معايير اختيار معايير D Auswahlkriterien Auswahlkriterien E Criterios de Selección Criterios de selección F Critères de sélection Critères de sélection I Criteri di selezione Criteri di selezione JA 選択基準 選択基準 KO 선택 기준 선택 기준 PTB Selecionar Critérios Selecionar Critérios RU Выбор условий Выбор условий S Välj villkor Välj villkor TR Ölçütleri Seç Ölçütleri Seç US Select Criteria Select Criteria ZHS 选择标准 选择标准