1154: r.batchstep_resource_id
1155: FROM gme_batch_header h,
1156: gme_batch_steps s,
1157: gme_batch_step_activities a,
1158: gme_batch_step_resources r
1159: WHERE h.organization_id = p_org_id
1160: AND h.batch_id = p_batch_id
1161: AND h.batch_type = 0
1162: AND h.batch_id = s.batch_id
3914: , r.usage_um
3915: FROM gme_batch_header h,
3916: gme_batch_steps s,
3917: gme_batch_step_activities a,
3918: gme_batch_step_resources r,
3919: gmp_resource_instances i,
3920: fnd_user u
3921: WHERE h.batch_id = p_batch_id
3922: AND h.batch_id = s.batch_id
3966: , ROUND(DECODE(s.step_status, 2, r.plan_rsrc_usage, 3, r.actual_rsrc_usage),2)
3967: , r.usage_um
3968: FROM gme_batch_steps s,
3969: gme_batch_step_activities a,
3970: gme_batch_step_resources r,
3971: gmp_resource_instances i,
3972: gme_resource_txns_gtmp t,
3973: gme_resource_txns rt,
3974: fnd_user u