APPS.GME_GANTT_PKG dependencies on GME_BATCH_STEP_RESOURCES

Line 102: -- FROM gme_batch_step_resources d2

98: -- AND p_aux_rsrc_ind = 2
99: -- AND p_sec_rsrc_ind = 0)
100: -- OR (EXISTS (
101: -- SELECT 1
102: -- FROM gme_batch_step_resources d2
103: -- WHERE d2.batch_id = b.batch_id
104: -- AND d2.resources LIKE p_resource
105: -- AND ( d2.prim_rsrc_ind = p_prim_rsrc_ind
106: -- OR d2.prim_rsrc_ind = p_aux_rsrc_ind

Line 202: -- FROM gme_batch_step_resources d2

198: -- AND p_aux_rsrc_ind = 2
199: -- AND p_sec_rsrc_ind = 0)
200: -- OR (EXISTS (
201: -- SELECT 1
202: -- FROM gme_batch_step_resources d2
203: -- WHERE d2.batch_id = b.batch_id
204: -- AND d2.resources LIKE p_resource
205: -- AND ( d2.prim_rsrc_ind = p_prim_rsrc_ind
206: -- OR d2.prim_rsrc_ind = p_aux_rsrc_ind

Line 703: string_to_exec(string_to_exec.LAST +1) := ' AND :p_sec_rsrc_ind = 0) OR (EXISTS (SELECT 1 FROM GME_BATCH_STEP_RESOURCES D2 ';

699: gme_debug.put_line('After executing set_where_clause');
700: END IF;
701:
702: string_to_exec(string_to_exec.LAST +1) := ' ) A WHERE ( (:p_resource = ''%'' AND :p_prim_rsrc_ind = 1 AND :p_aux_rsrc_ind = 2 ';
703: string_to_exec(string_to_exec.LAST +1) := ' AND :p_sec_rsrc_ind = 0) OR (EXISTS (SELECT 1 FROM GME_BATCH_STEP_RESOURCES D2 ';
704: string_to_exec(string_to_exec.LAST +1) := ' WHERE D2.BATCH_ID = A.BATCH_ID AND D2.RESOURCES LIKE :p_resource AND (D2.PRIM_RSRC_IND = ';
705: string_to_exec(string_to_exec.LAST +1) := ' :p_prim_rsrc_ind OR D2.PRIM_RSRC_IND = :p_aux_rsrc_ind OR D2.PRIM_RSRC_IND = :p_sec_rsrc_ind )))))';
706:
707: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 1308: ,gme_batch_step_resources d

1304: ,date_to_clientdt (r.plan_cmplt_date) ) end_date
1305: --bug3746919 bsatpute
1306: ,NVL (r.terminated_ind, 0)
1307: FROM gme_batch_steps r
1308: ,gme_batch_step_resources d
1309: ,gmd_operations o
1310: ,gme_batch_header b
1311: WHERE r.batch_id = p_batch_id
1312: AND r.batch_id = d.batch_id

Line 1474: FROM gme_batch_step_resources o

1470: (DECODE (r.step_status
1471: ,3, date_to_clientdt (o.actual_cmplt_date)
1472: ,date_to_clientdt (o.plan_cmplt_date) ) )
1473: end_date
1474: FROM gme_batch_step_resources o
1475: ,gme_batch_steps r
1476: ,gme_batch_step_activities s
1477: ,gmd_activities a
1478: ,gme_batch_header b

Line 1647: ,gme_batch_step_resources o

1643: ,date_to_clientdt (o.plan_cmplt_date) )
1644: ,NVL (f.process_qty_um, ' '), NVL (r.step_status, 0)
1645: FROM gme_batch_steps r
1646: ,gme_batch_step_activities a
1647: ,gme_batch_step_resources o
1648: ,gmd_operations f
1649: ,gme_batch_header b
1650: ,cr_rsrc_mst c
1651: WHERE r.batch_id = p_batch_id