APPS.GMO_VALIDATE_BATCH_GRP SQL Statements

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

Line: 112

    select batchstep_id
    from gme_batch_steps
    where ((GMO_CONSTANTS_GRP.ENTITY_BATCH = P_ENTITY_NAME AND batch_id = p_entity_key) OR
           (GMO_CONSTANTS_GRP.ENTITY_OPERATION = P_ENTITY_NAME AND batchstep_id = p_entity_key));

Line: 118

    select batchstep_activity_id
    from  gme_batch_step_activities
    where batchstep_id = l_batchstep_id;

Line: 123

    select batchstep_resource_id
    from   gme_batch_step_resources gbsr
    where  batchstep_activity_id = l_batchstep_activity_id;

Line: 128

    select material_detail_id
    from gme_material_details
    where batch_id = p_entity_key;

Line: 133

    select material_detail_id
    from gme_batch_step_items
    where batchstep_id = l_batchstep_id;

Line: 138

    SELECT Dispense_id
    from gmo_material_dispenses
    WHERE  material_status = 'DISPENSD'
      and  material_detail_id = l_material_detail_id;

Line: 144

    SELECT unDispense_id
    from gmo_material_undispenses
    WHERE  material_status = 'DISPENSD'
      and  material_detail_id = l_material_detail_id;

Line: 272

      select count(*) into l_ncm_count
      from qa_results_v
      where PROCESS_BATCH_ID = p_entity_key
        and NONCONFORMANCE_STATUS <> 'CLOSED';

Line: 336

      select count(*) into l_ncm_count
      from qa_results_v
      where PROCESS_BATCHSTEP_ID = p_entity_key
        and NONCONFORMANCE_STATUS <> 'CLOSED';