DBA Data[Home] [Help]

APPS.GMI_PICK_WAVE_CONFIRM_PVT dependencies on IC_LOTS_MST

Line 305: IC_LOTS_MST lots,

301: lots.lot_id,
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

Line 2951: IC_LOTS_MST lots,

2947: CURSOR lot_loct_ctl_trans
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