ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FC051A9E05362FB09050512Y ( select t.item_id item_id, i.item_no item_no, i.item_desc1 item_desc1, i.inv_class class_code, t.whse_code whse_code, i.item_um uom, t.doc_id doc_id, t.line_id line_id, t.doc_type doc_type, t.reason_code reason_code, 100 flow_type, t.trans_qty quantity, t.orgn_code, s.orgn_name name, GMI_ICR04_XMLP_PKG.act_usageformula(t.doc_type, t.reason_code, t.item_id, t.whse_code) ACT_UsageCF, GMI_ICR04_XMLP_PKG.ytd_usagecfformula(t.doc_type, t.reason_code, t.item_id, t.whse_code) YTD_UsageCF, GMI_ICR04_XMLP_PKG.ytd_valuecfformula() YTD_ValueCF, GMI_ICR04_XMLP_PKG.Doc_Type_InCP_p Doc_Type_InCP, GMI_ICR04_XMLP_PKG.Reason_Code_InCP_p Reason_Code_InCP, GMI_ICR04_XMLP_PKG.Quantity_InCP_p Quantity_InCP, GMI_ICR04_XMLP_PKG.Doc_Type_OutCP_p Doc_Type_OutCP, GMI_ICR04_XMLP_PKG.Reason_Code_OutCP_p Reason_Code_OutCP, GMI_ICR04_XMLP_PKG.Quantity_OutCP_p Quantity_OutCP, GMI_ICR04_XMLP_PKG.R_Daily_Item_Usage(t.doc_type,t.reason_code) R_Daily_Item, GMI_ICR04_XMLP_PKG.F_Doc_Type_InCP(t.doc_type,t.reason_code, t.line_id,t.doc_id,t.trans_qty) F_Doc_Type_In, GMI_ICR04_XMLP_PKG.F_Doc_Type_OutCP(t.doc_type,t.reason_code, t.line_id,t.doc_id,t.trans_qty) F_Doc_Type_Out from ic_tran_cmp t, ic_item_mst i ,sy_orgn_mst s where t.item_id=i.item_id and t.orgn_code=s.orgn_code and t.doc_type not in ('GRDI','GRDR','STST','STSR','MGRI','MSTI','PICY','PIPH','REPI','REPR','MTRI','STSI') and i.item_no >= NVL(:from_item,'0') and i.item_no <= NVL(:to_item,'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz') and t.whse_code >= NVL(:from_whse,'0') and t.whse_code <= NVL(:to_whse,'zzzz') and t.trans_date >= :from_date and t.trans_date <=:to_date and i.delete_mark=0 and t.orgn_code=:P_ORGN ) union ( select t.item_id item_id, i.item_no item_no, i.item_desc1 item_desc1, i.inv_class class_code, t.whse_code whse_code, i.item_um uom, t.doc_id doc_id, t.line_id line_id, t.doc_type doc_type, t.reason_code reason_code, 100 flow_type, t.trans_qty quantity, t.orgn_code, s.orgn_name name, GMI_ICR04_XMLP_PKG.act_usageformula(t.doc_type, t.reason_code, t.item_id, t.whse_code) ACT_UsageCF, GMI_ICR04_XMLP_PKG.ytd_usagecfformula(t.doc_type, t.reason_code, t.item_id, t.whse_code) YTD_UsageCF, GMI_ICR04_XMLP_PKG.ytd_valuecfformula() YTD_ValueCF, GMI_ICR04_XMLP_PKG.Doc_Type_InCP_p Doc_Type_InCP, GMI_ICR04_XMLP_PKG.Reason_Code_InCP_p Reason_Code_InCP, GMI_ICR04_XMLP_PKG.Quantity_InCP_p Quantity_InCP, GMI_ICR04_XMLP_PKG.Doc_Type_OutCP_p Doc_Type_OutCP, GMI_ICR04_XMLP_PKG.Reason_Code_OutCP_p Reason_Code_OutCP, GMI_ICR04_XMLP_PKG.Quantity_OutCP_p Quantity_OutCP, GMI_ICR04_XMLP_PKG.R_Daily_Item_Usage(t.doc_type,t.reason_code) R_DAILY_ITEM, GMI_ICR04_XMLP_PKG.F_Doc_Type_InCP(t.doc_type,t.reason_code, t.line_id,t.doc_id,t.trans_qty) F_DOC_TYPE_IN, GMI_ICR04_XMLP_PKG.F_Doc_Type_OutCP(t.doc_type,t.reason_code, t.line_id,t.doc_id,t.trans_qty) F_DOC_TYPE_OUT from ic_tran_pnd t, ic_item_mst i, sy_orgn_mst s where t.item_id=i.item_id and t.orgn_code=s.orgn_code and t.doc_type not in ('GRDI','GRDR','STST','STSR','MGRI','MSTI','PIPH','PICY','REPR','REPI','MTRI') and i.item_no >= NVL(:from_item,'0') and i.item_no <= NVL(:to_item,'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz') and t.whse_code >= NVL(:from_whse,'0') and t.whse_code <= NVL(:to_whse,'zzzz') and t.trans_date >= :from_date and t.trans_date <=:to_date and i.delete_mark=0 and t.delete_mark=0 and t.completed_ind=1 and t.orgn_code=:P_ORGN ) GMI ICR04_XML AR GMI تقرير استخدام الصنف اليومي (بتنسيق XML) Imported from BI Publisher Description: تقرير استخدام الصنف اليومي لمراقبة المخزون في OPM Application: مخازن التصنيع التشغيلي Source: تقرير استخدام الصنف اليومي (بتنسيق XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG D GMI Tägliche Artikelverwendung Imported from BI Publisher Description: Auswertung "Tägliche Artikelverwendung" in OPM IC Application: Process Manufacturing Materialwirtschaft Source: Tägliche Artikelverwendung (XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG E GMI Uso Diario de Artículos Imported from BI Publisher Description: Informe de uso diario de artículos de IC de OPM Application: Process Manufacturing Inventory Source: Uso Diario de Artículos (XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG F GMI Utilisations journalières d'articles Imported from BI Publisher Description: Utilisations journalières d'articles - OPM IC Application: Process Manufacturing Inventory Source: Utilisations journalières d'articles (XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG I GMI Rapporto Uso giornaliero articolo Imported from BI Publisher Description: Rapporto Uso giornaliero articolo di OPM IC Application: Process Manufacturing Inventory Source: Rapporto Uso giornaliero articolo (XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG JA GMI 日次品目使用量レポート Imported from BI Publisher Description: OPM IC日次品目使用量レポート Application: Process Manufacturing Inventory Source: 日次品目使用量レポート(XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG KO GMI 일일 품목 사용량 보고서 Imported from BI Publisher Description: OPM IC의 일일 품목 사용량 보고서 Application: Process Manufacturing Inventory Source: 일일 품목 사용량 보고서(XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG PTB GMI Relatório de Uso Diário de Item Imported from BI Publisher Description: Relatório de Uso do Item Diário de OPM IC Application: Process Manufacturing Inventory Source: Relatório de Uso Diário de Item (XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG RU GMI Ведомость использования позиций за день Imported from BI Publisher Description: Ведомость использования позиций за день КЗ УНП Application: Запасы УНП Source: Ведомость использования позиций за день (XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG S GMI Daglig artikelanvändning - rapport Imported from BI Publisher Description: Daglig artikelanvändning i OPM LS - rapport Application: Process Manufacturing Inventory Source: Daglig artikelanvändning - rapport (XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG TR GMI Günlük Kalem Kullanım Raporu Imported from BI Publisher Description: OPM IC Günlük Kalem Kullanımı Raporu Application: Üretim Prosesi Stok Yönetimi Source: Günlük Kalem Kullanım Raporu (XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG US GMI Daily Item Usage Imported from BI Publisher Description: Daily Item Usage Report of OPM IC Application: Process Manufacturing Inventory Source: Daily Item Usage Report (XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG ZHS GMI 每日项目用量报表 Imported from BI Publisher Description: OPM IC 的每日项目用量报表 Application: OPM 库存管理系统 Source: 每日项目用量报表 (XML) Short Name: ICR04_XML DB package: GMI_ICR04_XMLP_PKG BI Publisher :cost_method :doc_type_incp :doc_type_outcp :fiscal_year :from_date :from_item :from_whse :nonblocksql :p_conc_request_id :p_orgn :quantity_incp :quantity_outcp :reason_code_incp :reason_code_outcp :to_date :to_item :to_whse 1 -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 2 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 组织 组织 3 20 :fiscal_year LOV Oracle FISCAL_YEAR Y select fiscal_year id, fiscal_year value, calendar_desc description from ic_cldr_hdr where orgn_code=(select a.co_code from sy_orgn_mst a where a.orgn_code=fnd_profile.value('GEMMS_DEFAULT_ORGN') and a.delete_mark=0) and delete_mark=0 order by fiscal_year Y AR السنة المالية السنة المالية D Geschäftsjahr Geschäftsjahr E Año Fiscal Año fiscal F Exercice Exercice I Anno fiscale Anno fiscale JA 会計年度 会計年度 KO 회계년도 회계년도 PTB Ano Fiscal Ano Fiscal RU Финансовый год Финансовый год S Räkenskapsår Räkenskapsår TR Mali Yıl Mali Yıl US Fiscal Year Fiscal Year ZHS 会计年度 会计年度 4 30 :cost_method LOV Oracle IC_COST_METHOD Y select cost_mthd_code id, cost_mthd_code value, cost_mthd_desc description from cm_mthd_mst where delete_mark=0 order by cost_mthd_code Y AR طريقة التكلفة طريقة التكلفة D Kostenrechnungsverfahren Kostenrechnungsverfahren E Método de Cálculo de Coste Método de Cálculo de Coste F Méthode de valorisation Méthode de valorisation I Metodo determinazione costi Metodo determinazione costi JA 原価方法 原価方法 KO 원가계산 방법 원가계산 방법 PTB Método de Custo Método de Custo RU Метод калькуляции затрат Метод калькуляции затрат S Kostnadsmetod Kostnadsmetod TR Maliyet Yöntemi Maliyet Yöntemi US Cost Method Cost Method ZHS 成本计算方法 成本计算方法 5 40 :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 Y 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 起始项目 起始项目 6 50 :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 Y 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 终止项目 终止项目 7 60 :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 Y 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 起始仓库 起始仓库 8 70 :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 Y 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 终止仓库 终止仓库 9 80 :from_date Date Y AR من تاريخ من تاريخ D Von Datum Von Datum E De Fecha De fecha F Date de début Date de début I Data - Da Data - Da JA 日付:自 日付:自 KO 일자: 부터 일자: 부터 PTB Data - De Data - De RU Дата начала Дата начала S Från datum Från datum TR Başlangıç Tarihi Başlangıç Tarihi US From Date From Date ZHS 起始日期 起始日期 10 90 :to_date Date Y AR إلى تاريخ إلى تاريخ D Bis Datum Bis Datum E A Fecha A fecha F Date de fin Date de fin I Data - A Data - A JA 日付:至 日付:至 KO 일자: 까지 일자: 까지 PTB Data - Até Data - Até RU Дата окончания Дата окончания S Till datum Till datum TR Bitiş Tarihi Bitiş Tarihi US To Date To Date ZHS 终止日期 终止日期