OPM Batch steps and activities

➜ Back to Library
Description
Listing of the batch steps with activity factors

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 ECC Process Genealogy and Trace, Process Batch GME Material Usage Variance OPM Batches OPM Batch Material Transactions OPM Batch Steps OPM batch steps resources
Blitz Report™

Blitz Report™ provides multiple benefits: