ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B071065CF4ABB3ABE053B46B6358C0A0Y 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 US OPM Batch steps and activities Listing of the batch steps with activity factors 1=1