OPM Batch Steps

Description
Categories: Draft
Listing of batch steps and status
Run OPM Batch Steps and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT batch_id,
       batchstep_no,
       batchstep_id,
       step_status,
       gbt.oprn_id,
       oprn_no,
       oprn_vers,
       plan_step_qty,
       actual_step_qty,
       step_qty_um,
       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,
       steprelease_type,
       max_step_capacity,
       max_step_capacity_um,
       plan_charges,
       actual_charges,
       quality_status,
       routingstep_id
  FROM gme_batch_steps gbt, gmd_operations_b gob
 WHERE 
 1=1
 --batch_id in    (:batch_id1, :batch_id2, :batch_id3, :batch_id4, :batch_id5)
   And gbt.oprn_id = gob.oprn_id
 ORDER BY batch_id, batchstep_no