OPM Batch steps and activities

Description
Categories: Toolkit - Operations
Columns: Batch Id, Batchstep Id, Batchstep Activity Id, Activity, Offset Interval, Plan Start Date, Actual Start Date, Plan Cmplt Date, Actual Cmplt Date, Plan Activity Factor ...
Listing of the batch steps with activity factors
SELECT batch_id,
       batchstep_id,
       batchstep_activity_id,
       activity,
       offset_interval,
       to_char(plan_start_date, 'DD-MON-YYYY HH24:MI:SS') as plan_start_date,
       to_char(actual_start_date, 'DD-MON-YYYY HH24:MI:SS') as actual_start_date,
       to_char(plan_cmplt_date, 'DD-MON-YYYY HH24:MI:SS') as plan_cmplt_date,
       to_char(actual_cmplt_date, 'DD-MON-YYYY HH24:MI:SS') as actual_cmplt_date,
       plan_activity_factor,
       actual_activity_factor,
       oprn_line_id
  FROM gme_batch_step_activities
 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