OPM batch steps resources

Description
Listing of OPM batch step resources

How to Analyze OPM Variances FAQ (Doc ID 371064.1)

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 
       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