OPM batch steps resources

Description
Columns: Batch Id, Batchstep Id, Batchstep Activity Id, Batchstep Resource Id, Resources, Scale Type, Plan Rsrc Count, Actual Rsrc Count, Plan Rsrc Usage, Actual Rsrc Usage ...
Listing of OPM batch step resources

How to Analyze OPM Variances FAQ (Doc ID 371064.1)
SELECT 
       gbsr.batch_id,
       gbsr.batchstep_id,
       gbsr.batchstep_activity_id,
       gbsr.batchstep_resource_id,
       gbsr.resources,
       gbsr.scale_type,
       gbsr.plan_rsrc_count,
       gbsr.actual_rsrc_count,
       gbsr.plan_rsrc_usage,
       gbsr.actual_rsrc_usage,
       gbsr.usage_um,
       gbsr.plan_rsrc_qty,
       gbsr.actual_rsrc_qty,
       gbsr.resource_qty_um,
       to_char(gbsr.plan_start_date, 'DD-MON-YYYY HH24:MI:SS') as plan_start_date,
       to_char(gbsr.actual_start_date, 'DD-MON-YYYY HH24:MI:SS') as actual_start_date,
       to_char(gbsr.plan_cmplt_date, 'DD-MON-YYYY HH24:MI:SS') as plan_cmplt_date,
       to_char(gbsr.actual_cmplt_date, 'DD-MON-YYYY HH24:MI:SS') as actual_cmplt_date,
       gbsr.offset_interval,
       gbsr.min_capacity,
       gbsr.max_capacity,
       gbsr.capacity_um,
       gbsr.calculate_charges,
       gbsr.prim_rsrc_ind
  FROM gme_batch_step_resources gbsr
 WHERE 1=1
-- batch_id in      (:batch_id1, :batch_id2, :batch_id3, :batch_id4, :batch_id5)
 ORDER BY batch_id,
          batchstep_id,
          batchstep_activity_id,
          batchstep_resource_id