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 |
