ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FC751A9E05362FB09050512Y select lot_status Status, status_desc Description , qchold_res_code Reason_Code, Nettable_Ind Nettable, order_proc_ind Order_Proc, prod_ind Production, shipping_ind shipping, rejected_ind Rejected from ic_lots_sts where lot_status >= NVL(:From_Status,'0') and lot_status<= NVL(:To_Status ,'zzzz') and delete_mark=DECODE(:select_criteria,'All',delete_mark,'Deleted',1,0) order by lot_status &ORDERCF GMI RILSM_XML AR GMI تقرير موقف اللوط الرئيسي (بتنسيق XML) Imported from BI Publisher Description: تقرير موقف اللوط الرئيسي لمراقبة المخزون في OPM Application: مخازن التصنيع التشغيلي Source: تقرير موقف اللوط الرئيسي (بتنسيق XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG D GMI Chargenstatus-Stamm Imported from BI Publisher Description: Auswertung "Chargenstatus-Stamm" in OPM IC Application: Process Manufacturing Materialwirtschaft Source: Chargenstatus-Stamm (XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG E GMI Maestro de Estados de Lote Imported from BI Publisher Description: Informe de maestro de estados de lote de IC de OPM Application: Process Manufacturing Inventory Source: Maestro de Estados de Lote (XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG F GMI Statuts de lots Imported from BI Publisher Description: Statuts de lots - OPM IC Application: Process Manufacturing Inventory Source: Statuts de lots (XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG I GMI Rapporto Anagrafico stato lotto Imported from BI Publisher Description: Rapporto Anagrafico stato lotto di OPM IC Application: Process Manufacturing Inventory Source: Rapporto Anagrafico stato lotto (XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG JA GMI ロット・ステータス・マスター・レポート Imported from BI Publisher Description: OPM ICロット・ステータス・マスター・レポート Application: Process Manufacturing Inventory Source: ロット・ステータス・マスター・レポート(XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG KO GMI 로트 상태 마스터 보고서 Imported from BI Publisher Description: OPM IC의 로트 상태 마스터 보고서 Application: Process Manufacturing Inventory Source: 로트 상태 마스터 보고서(XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG PTB GMI Relatório Mestre de Status do Lote Imported from BI Publisher Description: Relatório-Mestre de Status de Lote de OPM IC Application: Process Manufacturing Inventory Source: Relatório Mestre de Status do Lote (XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG RU GMI Основной отчет о статусе партий Imported from BI Publisher Description: Основной отчет о статусе партий КЗ УНП Application: Запасы УНП Source: Основной отчет о статусе партий (XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG S GMI Partistatushuvud - rapport Imported from BI Publisher Description: Partistatushuvud i OPM LS - rapport Application: Process Manufacturing Inventory Source: Partistatushuvud - rapport (XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG TR GMI Lot Statüsü Ana Bilgiler Raporu Imported from BI Publisher Description: OPM IC Lot Statüsü Ana Bilgiler Raporu Application: Üretim Prosesi Stok Yönetimi Source: Lot Statüsü Ana Bilgiler Raporu (XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG US GMI Lot Status Master Imported from BI Publisher Description: Lot Status Master Report of OPM IC Application: Process Manufacturing Inventory Source: Lot Status Master Report (XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG ZHS GMI 批次状态主要资料报表 Imported from BI Publisher Description: OPM IC 的批次状态主要资料报表 Application: OPM 库存管理系统 Source: 批次状态主要资料报表 (XML) Short Name: RILSM_XML DB package: GMI_RILSM_XMLP_PKG BI Publisher &ordercf :from_status :from_statuscp :nonblocksql :order1 :p_conc_request_id :p_orgn :select_criteria :to_status :to_statuscp :user_id :user_id_1 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_status LOV Oracle STATUS_LIST Y select lot_status id, lot_status value, status_desc description from ic_lots_sts where delete_mark=0 order by lot_status AR من الموقف من الموقف D Von Status Von Status E De Estado De estado F Statut - De Statut - De I Stato - Da Stato - Da JA ステータス:自 ステータス:自 KO 상태: 부터 상태: 부터 PTB Status - De Status - De RU Статус с Статус с S Från status Från status TR İlk Statü İlk Statü US From Status From Status ZHS 起始状态 起始状态 5 20 :to_status LOV Oracle STATUS_LIST Y select lot_status id, lot_status value, status_desc description from ic_lots_sts where delete_mark=0 order by lot_status AR إلى الموقف إلى الموقف D Bis Status Bis Status E A Estado A estado F Statut - A Statut - A I Stato - A Stato - A JA ステータス:至 ステータス:至 KO 상태: 까지 상태: 까지 PTB Status - Até Status - Até RU Статус по Статус по S Till status Till status TR Son Statü Son Statü US To Status To Status 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 选择标准 选择标准 7 40 :order LOV Oracle ORDER_LIST 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=108653 order by ffvv.flex_value Ascending AR ترتيب حسب ترتيب حسب D Sortierfolge Sortierfolge E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA 順 順 KO 정렬 기준 정렬 기준 PTB Ordenar Por Ordenar Por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Bazı Sıralama Bazı US Order By Order By ZHS 排序顺序 排序顺序