ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FC451A9E05362FB09050512 select inv.whse_code whscode, i.item_no, l.lot_no, l.sublot_no, w.whse_name, s.orgn_code orgn_code, i.item_desc1, i.item_um, i.item_um2, l. lot_created, l.expire_date, inv.location, inv.lot_status as lot_status, round(sum( inv.loct_onhand),2) as sum_inv_loct_onhand, round(sum(inv.loct_onhand2),2) as sum_inv_loct_onhand2, i.delete_mark, s.orgn_name name from ic_item_mst i, ic_lots_mst l, ic_loct_inv inv, ic_whse_mst w , sy_orgn_mst s where i.item_id = l.item_id and l.item_id = inv.item_id and l.lot_id = inv.lot_id and l.lot_no != :deflot and inv.whse_code = w.whse_code and w.orgn_code=s.orgn_code and inv.whse_code between NVL(:FROM_WHSE, inv.whse_code ) and NVL(:TO_WHSE,inv.whse_code) and i.item_no between NVL( :FROM_ITEM,i.item_no) and NVL(:TO_ITEM, i.item_no) and i.delete_mark=decode(:select_criteria,'Active',0,'Deleted',1,'All',i.delete_mark,0) and w.orgn_code =:p_orgn group by inv.whse_code, item_no, lot_no, sublot_no, w.whse_name, item_desc1, item_um, item_um2, lot_created, expire_date, location, s.orgn_code, i.delete_mark , s.orgn_name, inv.lot_status having sum(inv.loct_onhand) <> 0 or sum(inv.loct_onhand2) <> 0 Y GMI RILIN_XML AR GMI تقرير مخزون اللوط (بتنسيق XML) Imported from BI Publisher Description: تقرير مخزون اللوط لمراقبة المخزون في OPM Application: مخازن التصنيع التشغيلي Source: تقرير مخزون اللوط (بتنسيق XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG D GMI Chargenbestand Imported from BI Publisher Description: Auswertung "Chargenbestand" in OPM IC Application: Process Manufacturing Materialwirtschaft Source: Chargenbestand (XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG E GMI Inventario de Lotes Imported from BI Publisher Description: Informe de inventario de lotes de IC de OPM Application: Process Manufacturing Inventory Source: Inventario de Lotes (XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG F GMI Inventaire des lots Imported from BI Publisher Description: Inventaire des lots - OPM IC Application: Process Manufacturing Inventory Source: Inventaire des lots (XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG I GMI Rapporto Scorte lotto Imported from BI Publisher Description: Rapporto Scorte lotto di OPM IC Application: Process Manufacturing Inventory Source: Rapporto Scorte lotto (XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG JA GMI ロット在庫レポート Imported from BI Publisher Description: OPM ICロット在庫レポート Application: Process Manufacturing Inventory Source: ロット在庫レポート(XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG KO GMI 로트 재고 보고서 Imported from BI Publisher Description: OPM IC의 로트 재고 보고서 Application: Process Manufacturing Inventory Source: 로트 재고 보고서(XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG PTB GMI Relatório de Inventário do Lote Imported from BI Publisher Description: Relatório de Inventário de Lote de OPM IC Application: Process Manufacturing Inventory Source: Relatório de Inventário do Lote (XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG RU GMI Отчет о партиях запасов Imported from BI Publisher Description: Отчет о партиях запасов КЗ УНП Application: Запасы УНП Source: Отчет о партиях запасов (XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG S GMI Partilagerrapport Imported from BI Publisher Description: Partilager i OPM LS - rapport Application: Process Manufacturing Inventory Source: Partilagerrapport (XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG TR GMI Lot Envanter Raporu Imported from BI Publisher Description: OPM IC Lot Envanter Raporu Application: Üretim Prosesi Stok Yönetimi Source: Lot Envanter Raporu (XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG US GMI Lot Inventory Imported from BI Publisher Description: Lot Inventory Report of OPM IC Application: Process Manufacturing Inventory Source: Lot Inventory Report (XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG ZHS GMI 批次库存报表 Imported from BI Publisher Description: OPM IC 的批次库存报表 Application: OPM 库存管理系统 Source: 批次库存报表 (XML) Short Name: RILIN_XML DB package: GMI_RILIN_XMLP_PKG BI Publisher :deflot :from_item :from_itemcp :from_whse :from_whsecp :nonblocksql :p_conc_request_id :p_orgn :select_criteria :to_item :to_itemcp :to_whse :to_whsecp :user_id :user_id_1 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 终止仓库 终止仓库 8 60 :select_criteria LOV Oracle SELECT_CRITERIA 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=108652 order by ffvv.flex_value Active 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 选择标准 选择标准 :$flex$.ic_orgn Organization From Whse :$flex$.ic_orgn Organization To Whse