ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B1783FDD7FFD3681E053B46B63587571 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 Y US OPM batch steps resources Listing of OPM batch step resources How to Analyze OPM Variances FAQ (Doc ID 371064.1) 1=1