APPS.GMI_WF_LOT_CM SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

         SELECT  lot_id, lot_no , sublot_no ,expire_date ,
                 retest_date , item_id , created_by
         FROM    ic_lots_mst
         WHERE   delete_mark = 0 AND inactive_ind = 0
         FOR UPDATE; -- table is NOT updated, see NOTES section above

Line: 32

      SELECT SYSDATE  INTO l_date_at_start FROM  DUAL ;

Line: 54

         SELECT  lot_ctl,grade_ctl
         INTO    l_lot_ctl,l_grade_ctl
         FROM    ic_item_mst
         WHERE   item_id = ic_lots_mst_record.item_id
         AND     delete_mark = 0 ;

Line: 64

                SELECT nvl(lot_retest_note,0),nvl(lot_expiry_note,0)
                INTO   l_retest_interval_from_tab, l_expiry_interval_from_tab
                FROM   sy_wf_item_roles
                WHERE   item_id = ic_lots_mst_record.item_id;