DBA Data[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1107: gme_batch_step_activities a

1103: SELECT a.activity,
1104: a.batchstep_activity_id
1105: FROM gme_batch_header h,
1106: gme_batch_steps s,
1107: gme_batch_step_activities a
1108: WHERE h.organization_id = p_organization_id
1109: AND h.batch_id = p_batch_id
1110: AND h.batch_type = 0
1111: AND h.batch_id = s.batch_id

Line 1157: gme_batch_step_activities a,

1153: SELECT r.resources,
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

Line 3917: gme_batch_step_activities a,

3913: , ROUND(DECODE(s.step_status, 2, r.plan_rsrc_usage, 3, r.actual_rsrc_usage),2)
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

Line 3969: gme_batch_step_activities a,

3965: , r.resource_qty_um
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,