APPS.GMI_WF_LOT_EXPIRY SQL Statements

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

Line: 60

                          ( SELECT  expiry_role_name,expiry_role_display_name,NVL(lot_expiry_note,0)
         		    FROM    sy_wf_item_roles
         		    WHERE   whse_item_id = c_whse_item_id);

Line: 64

                          ( SELECT  expiry_role_name,expiry_role_display_name,NVL(lot_expiry_note,0)
         		    FROM    sy_wf_item_roles
         		    WHERE   item_id = c_item_id);

Line: 69

                          ( SELECT whse_item_id
                            FROM ic_item_mst
			    WHERE item_id = c_item_id);

Line: 75

      SELECT sysdate INTO l_wf_start_date FROM dual;

Line: 78

      SELECT  USER_NAME, DESCRIPTION
      INTO    l_performer_name,l_performer_display_name
      FROM    FND_USER
      WHERE   USER_ID = p_created_by ;

Line: 84

      SELECT  item_no , item_desc1 , item_um ,item_um2 , dualum_ind
      INTO    l_item_no ,l_item_desc1 , l_item_um , l_item_um2 ,  l_dualum_ind
      FROM    ic_item_mst
      WHERE   item_id = p_item_id ;

Line: 320

         SELECT    COUNT(*)
         INTO      l_count_lots_mst
         FROM      ic_lots_mst
         WHERE     lot_id = l_lot_id
         AND       delete_mark = 0 ;

Line: 334

               SELECT nvl(SUM(loct_onhand),0) ,  nvl(SUM(loct_onhand2),0)
               INTO   l_sum_loct_onhand , l_sum_loct_onhand2
               FROM   ic_loct_inv
               WHERE  lot_id = l_lot_id
               AND    delete_mark = 0 ;