ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FBF51A9E05362FB09050512Y (select t.doc_type, t.whse_code Warehouse, w.whse_name Whse_name, t.trans_id Trans_no, t.item_id, i.item_no Item, t.doc_id, t.line_id, to_char(t.trans_date,'DD-MON-YYYY') Trans_Date, t.trans_qty Quantity, t.trans_um UOM, t.trans_qty2 Quantity2, t.trans_um2 Uom2, t.location Location, t.lot_id, GMI_ICR03_XMLP_PKG.unit_costcfformula(t.item_id, t.whse_code, t.trans_date) unit_costCF, --GMI_ICR03_XMLP_PKG.cost_accumcfformula(:unit_costCF, :count_QtySC) cost_accumCF, --GMI_ICR03_XMLP_PKG.defaultcurrcfformula(:cost_accumCF) defaultcurrCF, GMI_ICR03_XMLP_PKG.doc_typecfformula(t.doc_type) doc_typeCF, GMI_ICR03_XMLP_PKG.document_nocfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Document_NoCF, GMI_ICR03_XMLP_PKG.formula_nocfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Formula_NoCF, GMI_ICR03_XMLP_PKG.verscfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) VersCF, GMI_ICR03_XMLP_PKG.vend_ship_locationcfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Vend_Ship_LocationCF, GMI_ICR03_XMLP_PKG.frtbill_mthdcfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Frtbill_MthdCF, GMI_ICR03_XMLP_PKG.shipping_mthdcfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Shipping_mthdCF, GMI_ICR03_XMLP_PKG.shipper_namecfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Shipper_nameCF, GMI_ICR03_XMLP_PKG.doc_typeCP_p doc_typeCP, GMI_ICR03_XMLP_PKG.Document_NoCP_p Document_NoCP, GMI_ICR03_XMLP_PKG.Formula_NoCP_p Formula_NoCP, GMI_ICR03_XMLP_PKG.VersCP_p VersCP, GMI_ICR03_XMLP_PKG.Vend_Ship_LocationCP_p Vend_Ship_LocationCP, GMI_ICR03_XMLP_PKG.Frtbill_MthdCP_p Frtbill_MthdCP, GMI_ICR03_XMLP_PKG.Shipping_MthdCP_p Shipping_MthdCP, GMI_ICR03_XMLP_PKG.Shipper_NameCP_p Shipper_NameCP from ic_tran_pnd t, ic_item_mst i, ic_whse_mst w, cm_mthd_mst cm where t.whse_code >=NVL( :FROM_WHSE,'0') and t.whse_code <= NVL(:TO_WHSE,'zzzz') and t.trans_date >= :FROM_TRANSDATE and t.trans_date < :TO_TRANSDATE+1 and cm.cost_mthd_code = :cost_method and t.delete_mark = 0 and t.item_id = i.item_id and t.whse_code = w.whse_code and t.completed_ind = 1 ) UNION (select t.doc_type, t.whse_code Warehouse, w.whse_name Whse_Name, t.trans_id Trans_No, t.item_id, i.item_no Item, t.doc_id, t.line_id, to_char(t.trans_date,'DD-MON-YYYY') Trans_Date, t.trans_qty Qty, t.trans_um UOM, t.trans_qty2 Qty2, t.trans_um2 UOM2, t.location Location, t.lot_id, GMI_ICR03_XMLP_PKG.unit_costcfformula(t.item_id, t.whse_code, t.trans_date) unit_costCF, --GMI_ICR03_XMLP_PKG.cost_accumcfformula(:unit_costCF, :count_QtySC) cost_accumCF, --GMI_ICR03_XMLP_PKG.defaultcurrcfformula(:cost_accumCF) defaultcurrCF, GMI_ICR03_XMLP_PKG.doc_typecfformula(t.doc_type) doc_typeCF, GMI_ICR03_XMLP_PKG.document_nocfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Document_NoCF, GMI_ICR03_XMLP_PKG.formula_nocfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Formula_NoCF, GMI_ICR03_XMLP_PKG.verscfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) VersCF, GMI_ICR03_XMLP_PKG.vend_ship_locationcfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Vend_Ship_LocationCF, GMI_ICR03_XMLP_PKG.frtbill_mthdcfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Frtbill_MthdCF, GMI_ICR03_XMLP_PKG.shipping_mthdcfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Shipping_mthdCF, GMI_ICR03_XMLP_PKG.shipper_namecfformula(t.doc_type, t.doc_id, t.line_id, t.item_id) Shipper_nameCF, GMI_ICR03_XMLP_PKG.doc_typeCP_p doc_typeCP, GMI_ICR03_XMLP_PKG.Document_NoCP_p Document_NoCP, GMI_ICR03_XMLP_PKG.Formula_NoCP_p Formula_NoCP, GMI_ICR03_XMLP_PKG.VersCP_p VersCP, GMI_ICR03_XMLP_PKG.Vend_Ship_LocationCP_p Vend_Ship_LocationCP, GMI_ICR03_XMLP_PKG.Frtbill_MthdCP_p Frtbill_MthdCP, GMI_ICR03_XMLP_PKG.Shipping_MthdCP_p Shipping_MthdCP, GMI_ICR03_XMLP_PKG.Shipper_NameCP_p Shipper_NameCP from ic_tran_cmp t, ic_item_mst i, ic_whse_mst w, cm_mthd_mst cm --Bug#3315846 Modified the following where clause where ((t.whse_code >= NVL(:FROM_WHSE,'0') and t.whse_code <= NVL(:TO_WHSE,'zzzz')) or (t.whse_code is null and t.doc_type in ('GRDI','GRDR'))) and t.trans_date >= :FROM_TRANSDATE and t.trans_date < :TO_TRANSDATE+1 and cm.cost_mthd_code = :cost_method and t.item_id = i.item_id and t.whse_code = w.whse_code(+) ) order by 2,3,6,5,1,7,4 GMI ICR03_XML AR GMI تقرير تفاصيل الحركة اليومية (بتنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل الحركة اليومية لمراقبة المخزون في OPM Application: مخازن التصنيع التشغيلي Source: تقرير تفاصيل الحركة اليومية (بتنسيق XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG D GMI Tagestransaktionen - Details Imported from BI Publisher Description: Auswertung "Tagestransaktionen - Details" in OPM IC Application: Process Manufacturing Materialwirtschaft Source: Tagestransaktionen - Details (XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG E GMI Detalle de Transacciones Diarias Imported from BI Publisher Description: Informe de detalle de transacciones diarias de IC de OPM Application: Process Manufacturing Inventory Source: Detalle de Transacciones Diarias (XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG F GMI Détail journalier des mouvements Imported from BI Publisher Description: Détail journalier des mouvements - OPM IC Application: Process Manufacturing Inventory Source: Détail journalier des mouvements (XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG I GMI Rapporto Dettaglio transazioni giornaliere Imported from BI Publisher Description: Rapporto Dettaglio transazioni giornaliere di OPM IC Application: Process Manufacturing Inventory Source: Rapporto Dettaglio transazioni giornaliere (XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG JA GMI 日次トランザクション詳細レポート Imported from BI Publisher Description: OPM IC日次トランザクション詳細レポート Application: Process Manufacturing Inventory Source: 日次トランザクション詳細レポート(XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG KO GMI 일일 트랜잭션 상세 보고서 Imported from BI Publisher Description: OPM IC의 일일 트랜잭션 상세 보고서 Application: Process Manufacturing Inventory Source: 일일 트랜잭션 상세 보고서(XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG PTB GMI Relatório Detalhado da Transação Diária Imported from BI Publisher Description: Relatório Detalhado sobre Transação Diária de OPM IC Application: Process Manufacturing Inventory Source: Relatório Detalhado da Transação Diária (XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG RU GMI Подробный отчет о транзакциях за день Imported from BI Publisher Description: Подробный отчет о транзакциях за день КЗ УНП Application: Запасы УНП Source: Подробный отчет о транзакциях за день (XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG S GMI Dagliga transaktioner - detaljrapport Imported from BI Publisher Description: Dagliga transaktioner i OPM LS - detaljrapport Application: Process Manufacturing Inventory Source: Dagliga transaktioner - detaljrapport (XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG TR GMI Günlük İşlem Detay Raporu Imported from BI Publisher Description: OPM IC Günlük İşlem Detay Raporu Application: Üretim Prosesi Stok Yönetimi Source: Günlük İşlem Detay Raporu (XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG US GMI Daily Transaction Detail Imported from BI Publisher Description: Daily Transaction Detail Report of OPM IC Application: Process Manufacturing Inventory Source: Daily Transaction Detail Report (XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG ZHS GMI 每日事务处理详细信息报表 Imported from BI Publisher Description: OPM IC 的每日事务处理详细信息报表 Application: OPM 库存管理系统 Source: 每日事务处理详细信息报表 (XML) Short Name: ICR03_XML DB package: GMI_ICR03_XMLP_PKG BI Publisher :cost_method :default_curr :doc_typecp :document_nocp :formula_nocp :from_transdate :from_transdate1 :from_whse :frtbill_mthdcp :nonblocksql :p_conc_request_id :p_orgn :shipper_namecp :shipping_mthdcp :to_transdate :to_transdate1 :to_whse :vend_ship_locationcp :verscp 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 :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 起始仓库 起始仓库 4 30 :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 终止仓库 终止仓库 5 40 :from_transdate Date Y AR من تاريخ الحركة من تاريخ الحركة D Von Transaktionsdatum Von Transaktionsdatum E De Fecha de Transacción De fecha de transacción F Date du mouvement - Du Date du mouvement - Du I Data trs - Da Data trs - Da JA トランザクション日:自 トランザクション日:自 KO 트랜잭션: 부터 트랜잭션: 부터 PTB Data de Transação - De Data de Transação - De RU Дата транзакции с Дата транзакции с S Från trans.datum Från trans.datum TR İlk İşlem Tarihi İlk İşlem Tarihi US From Transdate From Transdate ZHS 事务处理起始日期 事务处理起始日期 6 50 :to_transdate Date Y AR إلى تاريخ الحركة إلى تاريخ الحركة D Bis Transaktionsdatum Bis Transaktionsdatum E A Fecha de Transacción A fecha de transacción F Date du mouvement - Au Date du mouvement - Au I Data trs - A Data trs - A JA トランザクション日:至 トランザクション日:至 KO 트랜잭션: 까지 트랜잭션: 까지 PTB Data de Transação - Até Data de Transação - Até RU Дата транзакции по Дата транзакции по S Till trans.datum Till trans.datum TR Son İşlem Tarihi Son İşlem Tarihi US To Transdate To Transdate ZHS 事务处理终止日期 事务处理终止日期 7 60 :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 成本计算方法 成本计算方法