APPS.GME_GANTT_PKG dependencies on GME_BATCH_STEP_RESOURCES

Line 80: FROM gme_batch_step_resources d2

76: AND p_aux_rsrc_ind = 2
77: AND p_sec_rsrc_ind = 0)
78: OR (EXISTS (
79: SELECT 1
80: FROM gme_batch_step_resources d2
81: WHERE d2.batch_id = b.batch_id
82: AND d2.resources LIKE p_resource
83: AND ( d2.prim_rsrc_ind = p_prim_rsrc_ind
84: OR d2.prim_rsrc_ind = p_aux_rsrc_ind

Line 159: FROM gme_batch_step_resources d2

155: AND p_aux_rsrc_ind = 2
156: AND p_sec_rsrc_ind = 0)
157: OR (EXISTS (
158: SELECT 1
159: FROM gme_batch_step_resources d2
160: WHERE d2.batch_id = b.batch_id
161: AND d2.resources LIKE p_resource
162: AND ( d2.prim_rsrc_ind = p_prim_rsrc_ind
163: OR d2.prim_rsrc_ind = p_aux_rsrc_ind

Line 819: ,gme_batch_step_resources d

815: ,date_to_clientdt (r.plan_cmplt_date) ) end_date
816: --bug3746919 bsatpute
817: ,NVL (r.terminated_ind, 0)
818: FROM gme_batch_steps r
819: ,gme_batch_step_resources d
820: ,gmd_operations o
821: ,gme_batch_header b
822: WHERE r.batch_id = p_batch_id
823: AND r.batch_id = d.batch_id

Line 985: FROM gme_batch_step_resources o

981: (DECODE (r.step_status
982: ,3, date_to_clientdt (o.actual_cmplt_date)
983: ,date_to_clientdt (o.plan_cmplt_date) ) )
984: end_date
985: FROM gme_batch_step_resources o
986: ,gme_batch_steps r
987: ,gme_batch_step_activities s
988: ,gmd_activities a
989: ,gme_batch_header b

Line 1157: ,gme_batch_step_resources o

1153: ,date_to_clientdt (o.plan_cmplt_date) )
1154: ,NVL (f.process_qty_um, ' '), NVL (r.step_status, 0)
1155: FROM gme_batch_steps r
1156: ,gme_batch_step_activities a
1157: ,gme_batch_step_resources o
1158: ,gmd_operations f
1159: ,gme_batch_header b
1160: ,cr_rsrc_mst c
1161: WHERE r.batch_id = p_batch_id