ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FC951A9E05362FB09050512Y select l.whse_code whscode , w.whse_name , i.item_no , i.item_desc1 , i.item_um , i.item_um2 , l.item_id , s.orgn_code orgn_code, s.orgn_name, GMI_RIWIN_XMLP_PKG.whse_qtyformula(l.whse_code, l.item_id) Whse_Qty, GMI_RIWIN_XMLP_PKG.total_qtyformula(l.item_id) Total_Qty, round(GMI_RIWIN_XMLP_PKG.whse_qty2formula(l.whse_code, l.item_id)) Whse_Qty2, round(GMI_RIWIN_XMLP_PKG.total_qty2formula(l.item_id)) Total_Qty2 from ic_item_mst i, ic_whse_mst w, ic_loct_inv l , sy_orgn_mst s where i.item_id = l.item_id and w.whse_code = l.whse_code and i.delete_mark = 0 and w.delete_mark = 0 and UPPER(l.whse_code) between UPPER(NVL(:From_whse,l.whse_code)) and UPPER(NVL(:To_whse,l.whse_code)) and UPPER(i.item_no) between UPPER(NVL(:From_item,i.item_no)) and UPPER(NVL(:To_item,i.item_no)) and w.orgn_code = s.orgn_code and w.orgn_code=:p_orgn group by l.whse_code, w.whse_name, i.item_no, i.item_desc1, i.item_um, i.item_um2, l.item_id, s.orgn_code, s.orgn_name having sum(l.loct_onhand) <> 0 or sum(l.loct_onhand2) <> 0 order by whscode,i.item_no asc GMI RIWIN_XML AR GMI تقرير مخزون المستودع (بتنسيق XML) Imported from BI Publisher Description: تقرير مخزون المستودع لمراقبة المخزون في OPM Application: مخازن التصنيع التشغيلي Source: تقرير مخزون المستودع (بتنسيق XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG D GMI Lagerbestand Imported from BI Publisher Description: Auswertung "Lagerbestand" in OPM IC Application: Process Manufacturing Materialwirtschaft Source: Lagerbestand (XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG E GMI Inventario de Almacenes Imported from BI Publisher Description: Informe de inventario de almacenes de IC de OPM Application: Process Manufacturing Inventory Source: Inventario de Almacenes (XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG F GMI Stock des entrepôts Imported from BI Publisher Description: Stock des entrepôts - OPM IC Application: Process Manufacturing Inventory Source: Stock des entrepôts (XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG I GMI Rapporto Scorte warehouse Imported from BI Publisher Description: Rapporto Scorte warehouse di OPM IC Application: Process Manufacturing Inventory Source: Rapporto Scorte warehouse (XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG JA GMI 倉庫在庫レポート Imported from BI Publisher Description: OPM IC倉庫在庫レポート Application: Process Manufacturing Inventory Source: 倉庫在庫レポート(XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG KO GMI 창고 재고 보고서 Imported from BI Publisher Description: OPM IC의 창고 재고 보고서 Application: Process Manufacturing Inventory Source: 창고 재고 보고서(XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG PTB GMI Relatório de Inventário do Depósito Imported from BI Publisher Description: Relatório de Inventário de Depósito de OPM IC Application: Process Manufacturing Inventory Source: Relatório de Inventário do Depósito (XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG RU GMI Подробный отчет о складских запасах Imported from BI Publisher Description: Отчет о складских запасах КЗ УНП Application: Запасы УНП Source: Подробный отчет о складских запасах (XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG S GMI Lagersaldo - rapport Imported from BI Publisher Description: Lagersaldo i OPM LS - rapport Application: Process Manufacturing Inventory Source: Lagersaldo - rapport (XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG TR GMI Depo Envanter Raporu Imported from BI Publisher Description: OPM IC Depo Envanteri Raporu Application: Üretim Prosesi Stok Yönetimi Source: Depo Envanter Raporu (XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG US GMI Warehouse Inventory Imported from BI Publisher Description: Warehouse Inventory Report of OPM IC Application: Process Manufacturing Inventory Source: Warehouse Inventory Report (XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG ZHS GMI 仓库库存报表 Imported from BI Publisher Description: OPM IC 的仓库库存报表 Application: OPM 库存管理系统 Source: 仓库库存报表 (XML) Short Name: RIWIN_XML DB package: GMI_RIWIN_XMLP_PKG BI Publisher :from_item :from_itemcp :from_whse :from_whsecp :nonblocksql :p_conc_request_id :p_orgn :to_item :to_itemcp :to_whse :to_whsecp :user_id 1 -30 :user_id Number fnd_profile.value('USER_ID') Y AR معرف المستخدم معرف المستخدم D Benutzerkennung Benutzerkennung E Id Usuario Identificador de usuario F ID utilisateur ID utilisateur I Id utente Id dell'utente JA ユーザーID ユーザーID KO 사용자 ID 사용자 ID PTB Id do Usuário Id do Usuário RU Идентификатор пользователя Идентификатор пользователя S Användar-id Användar-id TR Kullanıcı No Kullanıcı No US User Id User Id ZHS 用户标识 用户标识 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 :p_orgn LOV Oracle IC_ORGN Y select s.orgn_code id, s.orgn_code value, orgn_name description from sy_orgn_usr o,sy_orgn_mst s where o.orgn_code=s.orgn_code and o.user_id=fnd_global.user_id order by s.orgn_code fnd_profile.value('GEMMS_DEFAULT_ORGN') 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 组织 组织 4 20 :from_item LOV Oracle ITEM_LIST Y select item_no id, item_no value, item_desc1 description from ic_item_mst order by item_no 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 起始项目 起始项目 5 30 :to_item LOV Oracle ITEM_LIST Y select item_no id, item_no value, item_desc1 description from ic_item_mst order by item_no 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 终止项目 终止项目 6 40 :from_whse LOV Oracle ORGN_WHSES Y select whse_code id, whse_code value, whse_name description from ic_whse_mst where orgn_code=:$flex$.ic_orgn order by value,description AR من المستودع من المستودع D Von Lager Von Lager E De Almacén De Almacén F Entrepôt - De Entrepôt - De I Warehouse - Da Warehouse - Da JA 倉庫:自 倉庫:自 KO 창고: 부터 창고: 부터 PTB Depósito - De Depósito - De RU Склад с Склад с S Från lager Från lager TR Çıkış Deposu Çıkış Deposu US From Whse From Whse ZHS 起始仓库 起始仓库 7 50 :to_whse LOV Oracle ORGN_WHSES Y select whse_code id, whse_code value, whse_name description from ic_whse_mst where orgn_code=:$flex$.ic_orgn order by value,description AR إلى المستودع إلى المستودع D Bis Lager Bis Lager E A Almacén A Almacén F Entrepôt - A Entrepôt - A I Warehouse - A Warehouse - A JA 倉庫:至 倉庫:至 KO 창고: 까지 창고: 까지 PTB Depósito - Até Depósito - Até RU Склад по Склад по S Till lager Till lager TR Varış Deposu Varış Deposu US To Whse To Whse ZHS 终止仓库 终止仓库