OPM batch steps resources

Description
Listing of OPM batch step resources

How to Analyze OPM Variances FAQ (Doc ID 371064.1)
Run OPM batch steps resources and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT 
       gbsr.batch_id,
       gbsr.batchstep_id,
       gbsr.batchstep_activity_id,
       gbsr.batchstep_resource_id,
       gbsr.resources,
       gbsr.scale_type,
       gbsr.plan_rsrc_count,
       gbsr.actual_rsrc_count,
       gbsr.plan_rsrc_usage,
       gbsr.actual_rsrc_usage,
       gbsr.usage_um,
       gbsr.plan_rsrc_qty,
       gbsr.actual_rsrc_qty,
       gbsr.resource_qty_um,
       to_char(gbsr.plan_start_date, 'DD-MON-YYYY HH24:MI:SS') as plan_start_date,
       to_char(gbsr.actual_start_date, 'DD-MON-YYYY HH24:MI:SS') as actual_start_date,
       to_char(gbsr.plan_cmplt_date, 'DD-MON-YYYY HH24:MI:SS') as plan_cmplt_date,
       to_char(gbsr.actual_cmplt_date, 'DD-MON-YYYY HH24:MI:SS') as actual_cmplt_date,
       gbsr.offset_interval,
       gbsr.min_capacity,
       gbsr.max_capacity,
       gbsr.capacity_um,
       gbsr.calculate_charges,
       gbsr.prim_rsrc_ind
  FROM gme_batch_step_resources gbsr
 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,
          batchstep_resource_id
Blitz Report™