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
990: ,cm_alys_mst c
991: WHERE o.batch_id = p_batch_id
1152: ,NVL (date_to_clientdt (o.actual_cmplt_date)
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