APPS.GME_ERES_UTILS SQL Statements

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

Line: 21

       SELECT count(1)
       FROM   gme_material_details
       WHERE  phantom_id = p_batch_id
       AND    ROWNUM     = 1;

Line: 47

         SELECT organization_code || ' ' || batch_no
         FROM   gme_batch_header_vw
         WHERE  batch_id = v_batch_id;