GMI Lot Genealogy

➜ Back to Library
Description
Categories: BI Publisher
Application: Process Manufacturing Inventory
Source: Lot Genealogy Report (XML)
Short Name: GMILTGEN_XML
DB package: GMI_GMILTGEN_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Parameter Name SQL text Validation
Item 
 
 LOV Oracle
Lot 
 
 LOV Oracle
Sublot 
 
 LOV Oracle
Include Quality Control Results 
 
 LOV Oracle
Include Inventory Balances 
 
 LOV Oracle
Include Inventory Events 
 
 LOV Oracle
Genealogy Type 
 
 LOV Oracle
Download
 
Related Blitz Reports
GMI Daily Transaction Detail ECC Inventory Management, Inventory Trace Sales Orders GMI Inventory Transfer Report By Batch ECC Inventory Management, Inventory Trace Move ECC Inventory Management, Inventory Trace Inbound and On-Hand ECC Inventory Management, Inventory Trace Suppliers GMI Inventory Edit Journal ECC Inventory Management, Inventory Trace Issues GMI Daily Item Usage
Blitz Report™

Blitz Report™ provides multiple benefits: