ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFD53869E053B46B63588994 select a.*, GMI_GMILTGEN_XMLP_PKG.item_noformula(a.ITEM_ID, a.LOT_ID) Item_no, GMI_GMILTGEN_XMLP_PKG.Item_desc_p Item_desc, GMI_GMILTGEN_XMLP_PKG.lot_no_p lot_no, GMI_GMILTGEN_XMLP_PKG.sublot_no_p sublot_no, GMI_GMILTGEN_XMLP_PKG.inv_type_p inv_type, GMI_GMILTGEN_XMLP_PKG.Shelf_life_p Shelf_life, GMI_GMILTGEN_XMLP_PKG.inv_class_p inv_class, GMI_GMILTGEN_XMLP_PKG.grade_p grade, GMI_GMILTGEN_XMLP_PKG.Retest_interval_p Retest_interval, GMI_GMILTGEN_XMLP_PKG.lot_Creation_type_p lot_Creation_type, GMI_GMILTGEN_XMLP_PKG.lot_Creation_type_desc_p lot_Creation_type_desc, GMI_GMILTGEN_XMLP_PKG.begining_qty_p begining_qty, GMI_GMILTGEN_XMLP_PKG.creation_date_p creation_date, GMI_GMILTGEN_XMLP_PKG.expire_date_p expire_date, GMI_GMILTGEN_XMLP_PKG.retest_date_p retest_date, GMI_GMILTGEN_XMLP_PKG.plant_code_p plant_code, GMI_GMILTGEN_XMLP_PKG.batch_no_p batch_no, GMI_GMILTGEN_XMLP_PKG.vend_no_p vend_no, GMI_GMILTGEN_XMLP_PKG.vend_name_p vend_name, GMI_GMILTGEN_XMLP_PKG.Trans_um_p Trans_um, GMI_GMILTGEN_XMLP_PKG.vend_lot_no_p vend_lot_no, GMI_GMILTGEN_XMLP_PKG.po_orgn_code_p po_orgn_code, GMI_GMILTGEN_XMLP_PKG.po_no_p po_no, GMI_GMILTGEN_XMLP_PKG.recv_orgn_code_p recv_orgn_code, GMI_GMILTGEN_XMLP_PKG.recv_no_p recv_no, GMI_GMILTGEN_XMLP_PKG.jrnl_orgn_code_p jrnl_orgn_code, GMI_GMILTGEN_XMLP_PKG.journal_no_p journal_no, GMI_GMILTGEN_XMLP_PKG.M_6FormatTrigger(a.ITEM_ID, a.LOT_ID) M_6FT, GMI_GMILTGEN_XMLP_PKG.M_5FormatTrigger(a.ITEM_ID, a.LOT_ID) M_5FT from gmi_lot_trace a where a.lot_trace_id = :p_trace_id order by a.comp_no Y GMI GMILTGEN_XML AR GMI تقرير أصل اللوط (بتنسيق XML) Application: مخازن التصنيع التشغيلي Source: تقرير أصل اللوط (بتنسيق XML) Short Name: GMILTGEN_XML DB package: GMI_GMILTGEN_XMLP_PKG D GMI Chargenherkunft Application: Process Manufacturing Materialwirtschaft Source: Chargenherkunft (XML) Short Name: GMILTGEN_XML DB package: GMI_GMILTGEN_XMLP_PKG F GMI Généalogie de lot Application: Process Manufacturing Inventory Source: Généalogie de lot (XML) Short Name: GMILTGEN_XML DB package: GMI_GMILTGEN_XMLP_PKG US GMI Lot Genealogy Application: Process Manufacturing Inventory Source: Lot Genealogy Report (XML) Short Name: GMILTGEN_XML DB package: GMI_GMILTGEN_XMLP_PKG ZHS GMI 批次历史记录报表 Application: OPM 库存管理系统 Source: 批次历史记录报表 (XML) Short Name: GMILTGEN_XML DB package: GMI_GMILTGEN_XMLP_PKG BI Publisher :accept_flg :batch_no :begining_qty :creation_date :disp_orgn_code :expire_date :grade :i_item_desc :i_lot_no :i_sublot_no :ind_key :inv_class :inv_type :item_desc :journal_no :jrnl_orgn_code :lot_creation_type :lot_creation_type_desc :lot_no :max_spec :min_spec :p_conc_request_id :p_delimit :p_event_flg :p_item_id :p_item_no :p_loct_flg :p_lot_comp_title :p_lot_id :p_lot_no :p_qc_flg :p_rep_title :p_source_flg :p_sublot_no :p_trace_id :p_view_by :plant_code :po_no :po_orgn_code :recv_no :recv_orgn_code :result :retest_date :retest_interval :shelf_life :sublot_no :trans_um :uom2 :vend_lot_no :vend_name :vend_no 1 10 :p_item_no LOV Oracle GMI_ITEM_LIST Y Y select item_no id, item_no value, item_desc1 description from ic_item_mst where delete_mark=0 and lot_ctl=1 order by item_no Y AR الصنف D Artikel F Article US Item ZHS 项目 2 20 :p_lot_no LOV Oracle GMI_LOT_LIST Y select lot_no id, lot_no value, null description from ic_lots_mst il,ic_item_mst im where il.item_id=im.item_id and im.item_no=:$flex$.gmi_item_list and il.lot_id<>0 and il.delete_mark=0 and im.delete_mark=0 and il.rowid in (select max(rowid) from ic_lots_mst il1 where il.lot_no=il1.lot_no and il.item_id=il1.item_id) order by lot_no Y AR اللوط D Charge US Lot ZHS 批次 3 30 :p_sublot_no LOV Oracle GMI_SUBLOT_LIST Y select sublot_no id, sublot_no value, null description from ic_lots_mst il,ic_item_mst im where il.item_id=im.item_id and im.item_no=:$flex$.gmi_item_list and il.lot_no=:$flex$.gmi_lot_list and il.lot_id<>0 and il.delete_mark=0 and im.delete_mark=0 order by sublot_no AR اللوط الفرعي D Teilcharge F Sous-lot US Sublot ZHS 子批次 4 40 :p_qc_flg LOV Oracle GMI_YES_NO_ALL Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='GMI_YES_NO_ALL' order by value,description Y Y AR تضمين نتائج مراقبة الجودة D Mit Qualitätskontroll-Ergebnissen F Inclure résultats contrôle qualité US Include Quality Control Results ZHS 包括质量控制结果 5 50 :p_loct_flg LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y AR تضمين أرصدة المخزون D Mit Lagerbeständen F Inclure les soldes de stock US Include Inventory Balances ZHS 包括库存现有量 6 60 :p_event_flg LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y AR تضمين الأحداث المخزنية D Mit Lagerereignissen F Inclure les événements de stock US Include Inventory Events ZHS 包括库存事件 7 70 :p_view_by LOV Oracle GMI_GEN_TYPE Y select lookup_code id, meaning value, null description from gem_lookups where lookup_type='GMI_GEN_TYPE' order by value,description Y AR نوع الأصل D Herkunftsart F Type de généalogie US Genealogy Type ZHS 历史记录类型 :$flex$.gmi_item_list Item Lot :$flex$.gmi_item_list Item Sublot :$flex$.gmi_lot_list Lot Sublot