select
rr.report_name,
rro.report_run_id,
rro.report_id,
rro.request_id,
rro.report_instance_id,
rro.report_query,
rro.output_delivery,
rro.report_output_attr1,
rro.report_output_attr2,
rro.report_output_attr3,
rro.report_output_attr4,
rro.report_output_attr5,
rro.created_by,
rro.creation_date,
rro.last_updated_by,
rro.last_update_date,
rro.object_version,
rro.status,
rro.phase,
rro.output_xls_flag,
rro.output_pivot_xls_flag,
rro.output_pdf_flag,
rro.output_rtf_flag,
rro.output_html_flag,
rro.output_xml_flag,
rro.output_csv_flag,
rro.pivot_definition,
rro.total_row_count,
rro.parameters,
rro.request_id_pdf,
rro.request_id_rtf,
rro.delete_flag,
rro.request_id_csv,
rro.template_id,
rro.request_id_html,
rro.xml_request_id,
rro.pyugen_request_id,
rro.zip_flag,
rro.parent_conc_request_id,
rro.request_id_excel,
rro.output_bi_excel_flag,
rro.delivery_plan_ids,
rro.row_limit_flag
from
rx_reports rr,
rx_report_output rro
where
1=1 and
rr.report_id=rro.report_id
order by
rro.report_run_id desc |
