[Home] [Help]
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
1479: ,cm_alys_mst c
1480: WHERE o.batch_id = p_batch_id
1642: ,NVL (date_to_clientdt (o.actual_cmplt_date)
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