OPM batch steps resources
Description
Listing of OPM batch step resources
How to Analyze OPM Variances FAQ (Doc ID 371064.1)
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 |