DBA Data[Home] [Help]

APPS.GML_BATCH_OM_RES_PVT dependencies on IC_LOCT_INV

Line 519: /* check the lot_status in ic_loct_inv, where the status may have been changed from original setting*/

515: l_lot_status := l_gme_trans_row.lot_status ;
516: IF nvl(p_batch_line_rec.release_type,0) = 20 THEN
517: GMI_RESERVATION_UTIL.println('Create alloc: Regenerate allocations');
518: -- It is a regenerate (set it to value of 20 in regenerate, internal use )
519: /* check the lot_status in ic_loct_inv, where the status may have been changed from original setting*/
520: Select lot_status
521: Into l_lot_status
522: From ic_loct_inv
523: Where lot_id = l_gme_trans_row.lot_id

Line 522: From ic_loct_inv

518: -- It is a regenerate (set it to value of 20 in regenerate, internal use )
519: /* check the lot_status in ic_loct_inv, where the status may have been changed from original setting*/
520: Select lot_status
521: Into l_lot_status
522: From ic_loct_inv
523: Where lot_id = l_gme_trans_row.lot_id
524: AND location = l_gme_trans_row.location
525: AND whse_code = l_gme_trans_row.whse_code
526: AND item_id = l_gme_trans_row.item_id