OPM Batch Steps

Description
Categories: Draft
Columns: Batch Id, Batchstep No, Batchstep Id, Step Status, Oprn Id, Oprn No, Oprn Vers, Plan Step Qty, Actual Step Qty, Step Qty Um ...
Listing of batch steps and status
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