OPM Batch Steps
Description
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 |