APPS.GMI_OM_UTIL dependencies on IC_LOTS_MST

Line 59: FROM ic_tran_pnd itp, ic_lots_mst ilm

55:
56: CURSOR trans_dtl IS
57: SELECT itp.lot_id, ilm.lot_no, ilm.sublot_no, ABS(itp.trans_qty) trans_qty, itp.trans_um,
58: ABS(itp.trans_qty2) trans_qty2, itp.trans_um2
59: FROM ic_tran_pnd itp, ic_lots_mst ilm
60: WHERE itp.doc_type ='OMSO'
61: AND itp.line_id = p_original_line_rec.reference_line_id
62: AND itp.delete_mark = 0
63: AND itp.completed_ind = 1