OPM batch steps resources

➜ Back to Library
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
Download
Related Blitz Reports
ECC Process Genealogy and Trace, Process Batch ECC Process Manufacturing, Outside Processing Batch GMD MUV Detail GME Material Usage Variance OPM Batches GMF MUV Detail OPM Batch steps and activities OPM Batch Steps OPM Batch Material Transactions
Blitz Report™

Blitz Report™ provides multiple benefits: