SQL & PL/SQL

SELECT ol.header_id,

               ol.line_id line_id

  FROM oe_order_lines_all ol,

       oe_order_headers_all oh

WHERE oh.header_id = ol.header_id

  AND ol.booked_flag = 'Y'

  AND ol.line_id = ol.top_model_line_id

          AND GREATEST (oh.booked_date, ol.creation_Date) BETWEEN TO_DATE (

                                                                      TO_CHAR (

                                                                         :l_date_from,

                                                                         'DD/MM/YYYY HH24:MI:SS'

                                                                      ),

                                                                      'DD/MM/YYYY HH24:MI:SS'

                                                                   )

                                                               AND  TO_DATE (

                                                                       TO_CHAR (

                                                                          :l_date_to,

                                                                          'DD/MM/YYYY HH24:MI:SS'

                                                                       ),

                                                                       'DD/MM/YYYY HH24:MI:SS'

                                                                    )