GMI Lot Genealogy

Description
Categories: BI Publisher, Manufacturing
Application: Process Manufacturing Inventory
Source: Lot Genealogy Report (XML)
Short Name: GMILTGEN_XML
DB package: GMI_GMILTGEN_XMLP_PKG
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
Genealogy Type
 
LOV Oracle
Include Inventory Events
 
LOV Oracle
Include Inventory Balances
 
LOV Oracle
Include Quality Control Results
 
LOV Oracle
Sublot
 
LOV Oracle
Lot
 
LOV Oracle
Item
 
LOV Oracle