302: lots.sublot_no,
303: loct.INVENTORY_LOCATION_ID locator_id
304: FROM IC_TRAN_PND tran,
305: IC_LOTS_MST lots,
306: IC_LOCT_MST loct
307: WHERE lots.lot_id = tran.lot_id
308: AND lots.item_id = tran.item_id
309: AND lots.delete_mark = 0
310: AND tran.line_id = p_line_id
2948: IS
2949: SELECT trans_id, trans_qty, trans_qty2
2950: FROM IC_TRAN_PND tran,
2951: IC_LOTS_MST lots,
2952: IC_LOCT_MST loct
2953: WHERE lots.lot_id = tran.lot_id
2954: AND lots.item_id = tran.item_id
2955: AND lots.delete_mark = 0
2956: AND tran.line_id = p_line_id