Oracle Process Manufacturing Query

Oracle Process Manufacturing Query:


SELECT 'gme_batch_header', gbh.*, 'gme_batch_steps', gbs.*,
       'gme_batch_step_activities', gbsa.*, 'gme_batch_step_resources',
       gbsr.*, 'gmp_process_parameters', gppp.*, 'gme_process_parameters',
       gpp.*
  FROM gmp_process_parameters gppp,
       gme_process_parameters gpp,
       gme_batch_step_resources gbsr,
       gme_batch_step_activities gbsa,
       gme_batch_steps gbs,
       gme_batch_header gbh
 WHERE 1=1
AND gbh.BATCH_STATUS =3
 and gbh.batch_id = gbs.batch_id
   AND gbs.batchstep_id = gbsa.batchstep_id
   AND gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
   AND gbh.batch_id = gpp.batch_id
   AND gbs.batchstep_id = gpp.batchstep_id
   AND gbsa.batchstep_activity_id = gpp.batchstep_activity_id
   AND gbsr.batchstep_resource_id = gpp.batchstep_resource_id
   AND gpp.parameter_id = gppp.parameter_id
   AND gbh.CREATION_DATE >= TO_DATE('01/07/2018 00:00:00', 'DD-MM-YYYY HH24:MI:SS')
   AND gbh.CREATION_DATE <= TO_DATE('05/07/2018 23:59:59', 'DD-MM-YYYY HH24:MI:SS')