DBA Data[Home] [Help]

APPS.GMI_PICK_WAVE_CONFIRM_PVT dependencies on IC_LOCT_MST

Line 306: IC_LOCT_MST loct

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

Line 2952: IC_LOCT_MST loct

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