OPM Batch steps and activities
Description
Listing of the batch steps with activity factors
Run
OPM Batch steps and activities and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |