Blitz Upload Data

select
xrr.upload_request_id,
xrr.request_id report_request_id,
xrr.creation_date,
xxen_util.user_name(xrr.created_by) user_name,
frt.responsibility_name responsibility,
xrv.report_name,
xrr.upload_file_name file_name,
'begin xxen_upload.g_run_id:='||xud.run_id||'; end;'||chr(10)||chr(10)||'select xu.* from '||xrv.upload_view||' xu' sql,
&upload_columns
from
xxen_upload_data xud,
xxen_report_runs xrr,
xxen_reports_v xrv,
fnd_responsibility_tl frt
where
1=1 and
xud.run_id=xrr.run_id(+) and
xrr.report_id=xrv.report_id and
xrr.responsibility_application_id=frt.application_id(+) and
xrr.responsibility_id=frt.responsibility_id(+) and
frt.language(+)=userenv('lang')
order by
xud.run_id desc,
xud.upload_row

select xrr.upload_request_id, xrr.request_id report_request_id, xrr.creation_date, xxen_util.user_name(xrr.created_by) user_name, frt.responsibility_name responsibility, xrv.report_name, xrr.upload_file_name file_name, 'begin xxen_upload.g_run_id:='||xud.run_id||'; end;'||chr(10)||chr(10)||'select xu.* from '||xrv.upload_view||' xu' sql, &upload_columns from xxen_upload_data xud, xxen_report_runs xrr, xxen_reports_v xrv, fnd_responsibility_tl frt where 1=1 and xud.run_id=xrr.run_id(+) and xrr.report_id=xrv.report_id and xrr.responsibility_application_id=frt.application_id(+) and xrr.responsibility_id=frt.responsibility_id(+) and frt.language(+)=userenv('lang') order by xud.run_id desc, xud.upload_row