ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FC351A9E05362FB09050512Y SELECT b.journal_no,b.journal_comment, a.doc_line, a.last_updated_by, a.trans_type, i.item_no, a.whse_code, a.location, a.qty, a.item_um, a.qc_grade, a.lot_status, a.reason_code, decode(l.lot_no,'DEFAULT LOT',' ',l.lot_no) lot_no, l.sublot_no, a.qty2, a.item_um2, s.orgn_code, s.orgn_name, GMI_RIEDJL_XMLP_PKG.username_formulaformula(a.last_updated_by) Username_formula FROM ic_jrnl_mst b, ic_adjs_jnl a, ic_item_mst i, ic_lots_mst l, sy_orgn_mst s WHERE b.journal_id = a.journal_id and a.item_id = i.item_id and a.item_id = l.item_id and a.lot_id = l.lot_id and b.delete_mark = 0 and b.posted_ind = 0 and s.orgn_code = :P_orgn and b.journal_no between rtrim(nvl(:from_journal,'0')) and rtrim(nvl(:to_journal,'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz')) order by &sortCp GMI RIEDJL_XML AR GMI تقرير يومية تحرير المخزون (بتنسيق XML) Imported from BI Publisher Description: تقرير يومية تحرير المخزون لمراقبة المخزون في OPM Application: مخازن التصنيع التشغيلي Source: تقرير يومية تحرير المخزون (بتنسيق XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG D GMI Bestandsbearbeitung - Buchungen Imported from BI Publisher Description: Auswertung "Bestandsbearbeitung - Buchungen" in OPM IC Application: Process Manufacturing Materialwirtschaft Source: Bestandsbearbeitung - Buchungen (XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG E GMI Edición de Libro de Inventario Imported from BI Publisher Description: Informe de edición de libro de inventario de IC de OPM Application: Process Manufacturing Inventory Source: Edición de Libro de Inventario (XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG F GMI Edition du journal des stocks Imported from BI Publisher Description: Edition du journal des stocks - OPM IC Application: Process Manufacturing Inventory Source: Edition du journal des stocks (XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG I GMI Rapporto Scrittura contabile di modifica magazzino Imported from BI Publisher Description: Rapporto Scrittura contabile di modifica magazzino di OPM IC Application: Process Manufacturing Inventory Source: Rapporto Scrittura contabile di modifica magazzino (XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG JA GMI 在庫編集ジャーナル・レポート Imported from BI Publisher Description: OPM IC在庫編集ジャーナル・レポート Application: Process Manufacturing Inventory Source: 在庫編集ジャーナル・レポート(XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG KO GMI 재고 전표 편집 보고서 Imported from BI Publisher Description: OPM IC의 재고 전표 편집 보고서 Application: Process Manufacturing Inventory Source: 재고 전표 편집 보고서(XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG PTB GMI Relatório de Lançamento de Edição de Inventário Imported from BI Publisher Description: Relatório de Lançamento de Edição de Inventário de OPM IC Application: Process Manufacturing Inventory Source: Relatório de Lançamento de Edição de Inventário (XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG RU GMI Отчет об изменениях в журнале для запасов Imported from BI Publisher Description: Отчет об изменениях в журнале для запасов КЗ УНП Application: Запасы УНП Source: Отчет об изменениях в журнале для запасов (XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG S GMI Lagerredigeringsverifikation - rapport Imported from BI Publisher Description: Lagerredigeringsverifikation i OPM LS - rapport Application: Process Manufacturing Inventory Source: Lagerredigeringsverifikation - rapport (XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG TR GMI Envanter Düzenleme Fişi Raporu Imported from BI Publisher Description: OPM IC Envanter Düzenleme Fişi Raporu Application: Üretim Prosesi Stok Yönetimi Source: Envanter Düzenleme Fişi Raporu (XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG US GMI Inventory Edit Journal Imported from BI Publisher Description: Inventory Edit Journal Report of OPM IC Application: Process Manufacturing Inventory Source: Inventory Edit Journal Report (XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG ZHS GMI 库存编辑日记帐报表 Imported from BI Publisher Description: OPM IC 的库存编辑日记帐报表 Application: OPM 库存管理系统 Source: 库存编辑日记帐报表 (XML) Short Name: RIEDJL_XML DB package: GMI_RIEDJL_XMLP_PKG BI Publisher &sortcp :from_journal :nonblocksql :p_conc_request_id :p_orgn :sort_order :sort_order1 :sortcp :to_journal :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') 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_journal LOV Oracle JRNL_LIST Y select journal_no id, journal_no value, journal_comment description from ic_jrnl_mst where orgn_code=:$flex$.ic_orgn and posted_ind=0 and delete_mark=0 order by journal_no Y AR من اليومية من اليومية D Von Journal Von Journal E De Libro De libro F Journal - De Journal - De I Scrittura contabile - Da Scrittura contabile - Da JA ジャーナル:自 ジャーナル:自 KO 전표: 부터 전표: 부터 PTB Lançamento - De Lançamento - De RU Журнал с Журнал с S Från verifikation Från verifikation TR İlk Fiş İlk Fiş US From Journal From Journal ZHS 起始日志 起始日志 5 30 :to_journal LOV Oracle JRNL_LIST Y select journal_no id, journal_no value, journal_comment description from ic_jrnl_mst where orgn_code=:$flex$.ic_orgn and posted_ind=0 and delete_mark=0 order by journal_no Y AR إلى اليومية إلى اليومية D Bis Journal Bis Journal E A Libro A libro F Journal - A Journal - A I Scrittura contabile - A Scrittura contabile - A JA ジャーナル:至 ジャーナル:至 KO 전표: 까지 전표: 까지 PTB Lançamento - Até Lançamento - Até RU Журнал по Журнал по S Till verifikation Till verifikation TR Son Fiş Son Fiş US To Journal To Journal ZHS 终止日志 终止日志 6 40 :sort_order LOV Oracle SORT_ORDER_RIEDJL 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=108640 order by ffvv.flex_value Journal Entry AR ترتيب الفرز ترتيب الفرز D Sortierfolge Sortierfolge E Orden de Clasificación Orden de clasificación F Ordre de tri Ordre de tri I Ordinamento Ordinamento JA ソート順 ソート順 KO 정렬 순서 정렬 순서 PTB Ordem de Classificação Ordem de Classificação RU Порядок сортировки Порядок сортировки S Sorteringsordning Sorteringsordning TR Sıralama Düzeni Sıralama Düzeni US Sort Order Sort Order ZHS 排序次序 排序次序