OPM Batch steps and activities

➜ Back to Library
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
Download
Related Blitz Reports
ECC Process Manufacturing, Outside Processing Batch GMD MUV Detail GMF MUV Detail OPM Batches GME Material Usage Variance OPM Batch Material Transactions ECC Process Genealogy and Trace, Process Batch OPM Batch Steps OPM batch steps resources
Blitz Report™

Blitz Report™ provides multiple benefits: