ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FC551A9E05362FB09050512Y Select i.item_no, i.item_desc1, l.lot_no, l.sublot_no, l.lot_desc, l.qc_grade, l.expaction_code, l.strength, l.inactive_ind, l.origination_type, l.expaction_date, l.lot_created, l.expire_date, l.retest_date From ic_item_mst i, ic_lots_mst l Where l.item_id =i.item_id and l.lot_id != 0 and i. item_no >= NVL(:from_item,'0') and i.item_no <= NVL(:to_item,'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz') and l.delete_mark = decode(:select_criteria,'Active',0,'Deleted',1,'All',l.delete_mark,0) Order by item_no asc ,lot_no asc GMI RILMS_XML AR GMI تقرير اللوط الرئيسي (بتنسيق XML) Imported from BI Publisher Description: تقرير اللوط الرئيسي لمراقبة المخزون في OPM Application: مخازن التصنيع التشغيلي Source: تقرير اللوط الرئيسي (بتنسيق XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG D GMI Chargenstamm Imported from BI Publisher Description: Auswertung "Chargenstamm" in OPM IC Application: Process Manufacturing Materialwirtschaft Source: Chargenstamm (XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG E GMI Maestro de Lotes Imported from BI Publisher Description: Informe de maestro de lotes de IC de OPM Application: Process Manufacturing Inventory Source: Maestro de Lotes (XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG F GMI Récapitulatif des lots Imported from BI Publisher Description: Récapitulatif des lots - OPM IC Application: Process Manufacturing Inventory Source: Récapitulatif des lots (XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG I GMI Rapporto Anagrafico lotto Imported from BI Publisher Description: Rapporto Anagrafico lotto di OPM IC Application: Process Manufacturing Inventory Source: Rapporto Anagrafico lotto (XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG JA GMI ロット・マスター・レポート Imported from BI Publisher Description: OPM ICロット・マスター・レポート Application: Process Manufacturing Inventory Source: ロット・マスター・レポート(XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG KO GMI 로트 마스터 보고서 Imported from BI Publisher Description: OPM IC의 로트 마스터 보고서 Application: Process Manufacturing Inventory Source: 로트 마스터 보고서(XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG PTB GMI Relatório Mestre do Lote Imported from BI Publisher Description: Relatório-Mestre de Lote de OPM IC Application: Process Manufacturing Inventory Source: Relatório Mestre do Lote (XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG RU GMI Основной отчет о партиях Imported from BI Publisher Description: Основной отчет о партиях КЗ УНП Application: Запасы УНП Source: Основной отчет о партиях (XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG S GMI Partihuvudrapport Imported from BI Publisher Description: Partihuvud i OPM LS - rapport Application: Process Manufacturing Inventory Source: Partihuvudrapport (XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG TR GMI Lot Ana Raporu Imported from BI Publisher Description: OPM IC Lot Ana Bilgileri Raporu Application: Üretim Prosesi Stok Yönetimi Source: Lot Ana Raporu (XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG US GMI Lot Master Imported from BI Publisher Description: Lot Master Report of OPM IC Application: Process Manufacturing Inventory Source: Lot Master Report (XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG ZHS GMI 批次主要资料报表 Imported from BI Publisher Description: OPM IC 的批次主要资料报表 Application: OPM 库存管理系统 Source: 批次主要资料报表 (XML) Short Name: RILMS_XML DB package: GMI_RILMS_XMLP_PKG BI Publisher :from_item :from_itemcp :nonblocksql :p_conc_request_id :p_orgn :select_criteria :to_item :to_itemcp :user_id 1 -40 :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 -30 :p_orgn Char fnd_profile.value('GEMMS_DEFAULT_ORGN') AR التنظيم الرئيسي التنظيم الرئيسي D Org. Org. E P Org. P Org. JA 処理組織 処理組織 KO P 조직 P 조직 PTB P org. P org. RU Р-орг. Р-орг. S P org. P org. TR P organizasyonu P organizasyonu US P orgn P orgn ZHS P 组织 P 组织 3 -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 4 10 :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 20 :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 30 :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 选择标准 选择标准