DBA Data[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1134: gme_batch_step_activities a

1130: SELECT a.activity,
1131: a.batchstep_activity_id
1132: FROM gme_batch_header h,
1133: gme_batch_steps s,
1134: gme_batch_step_activities a
1135: WHERE h.organization_id = p_organization_id
1136: AND h.batch_id = p_batch_id
1137: AND h.batch_type = 0
1138: AND h.batch_id = s.batch_id

Line 1184: gme_batch_step_activities a,

1180: SELECT r.resources,
1181: r.batchstep_resource_id
1182: FROM gme_batch_header h,
1183: gme_batch_steps s,
1184: gme_batch_step_activities a,
1185: gme_batch_step_resources r
1186: WHERE h.organization_id = p_org_id
1187: AND h.batch_id = p_batch_id
1188: AND h.batch_type = 0

Line 4001: gme_batch_step_activities a,

3997: , ROUND(DECODE(s.step_status, 2, r.plan_rsrc_usage, 3, r.actual_rsrc_usage),2)
3998: , r.usage_um
3999: FROM gme_batch_header h,
4000: gme_batch_steps s,
4001: gme_batch_step_activities a,
4002: gme_batch_step_resources r,
4003: gmp_resource_instances i,
4004: fnd_user u
4005: WHERE h.batch_id = p_batch_id

Line 4053: gme_batch_step_activities a,

4049: , r.resource_qty_um
4050: , ROUND(DECODE(s.step_status, 2, r.plan_rsrc_usage, 3, r.actual_rsrc_usage),2)
4051: , r.usage_um
4052: FROM gme_batch_steps s,
4053: gme_batch_step_activities a,
4054: gme_batch_step_resources r,
4055: gmp_resource_instances i,
4056: gme_resource_txns_gtmp t,
4057: gme_resource_txns rt,