GMI Lot Genealogy

Description
Categories: BI Publisher
Columns: Lot Trace Id, Item Id, Lot Id, Comp No, Level No, Cir Flg, Item No, Item Desc, Lot No, Sublot No ...
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