ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 3543F6E30D10AB0DE0630100007F49EB Blitz Upload Name Y select xrv.report_name value, xrr.count description from xxen_reports_v xrv, (select count(*) count, xrr.report_id from xxen_report_runs xrr where xrr.run_id in (select xud.run_id from xxen_upload_data xud) group by xrr.report_id) xrr where xrv.report_id=xrr.report_id order by xrr.count desc, xrv.report_name US Blitz Upload name for which there still exists historical upload data. 3543F6E30D0BAB0DE0630100007F49EB 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 Y US Blitz Upload Data History of uploaded data, which is kept for profile option Blitz Upload Data Retention Days number of days. Enginatics &upload_columns 1=1 1 -10 &upload_columns select 'xud.*' from dual where nvl(:upload_name,';') like '%;%' Char x US Upload columns default 2 10 1=1 xrv.report_name=:upload_name LOV Blitz Upload Name 3543F6E30D10AB0DE0630100007F49EB Y select xrv.report_name value, xrr.count description from xxen_reports_v xrv, (select count(*) count, xrr.report_id from xxen_report_runs xrr where xrr.run_id in (select xud.run_id from xxen_upload_data xud) group by xrr.report_id) xrr where xrv.report_id=xrr.report_id order by xrr.count desc, xrv.report_name select xrv.report_name from (select xud.run_id from xxen_upload_data xud where xud.run_id=:$flex$.run_id and rownum=1) xud, xxen_report_runs xrr, xxen_reports_v xrv where xud.run_id=xrr.run_id and xrr.report_id=xrv.report_id union all select xrv.report_name from fnd_concurrent_requests fcr, xxen_report_runs xrr, xxen_reports_v xrv where fcr.parent_request_id=:$flex$.upload_request_id and fcr.request_id=xrr.request_id and xrr.report_id=xrv.report_id union all select xrv.report_name from xxen_report_runs xrr, xxen_reports_v xrv where xrr.request_id=:$flex$.report_request_id and xrr.report_id=xrv.report_id US Upload Name 3 &upload_columns select y.* from ( select 'xud.run_id,' column_text from dual union all select 'xud.upload_row,' from dual union all select 'xud.column1 action_code_,' from dual union all select 'xud.column2 status_code_,' from dual union all select x.* from ( select 'xud.column'||xucv.column_number||' '||xxen_xdo.column_name(xucv.column_name)||decode(max(xucv.column_number) over (),xucv.column_number,null,','||chr(10)) column_text from xxen_upload_columns_v xucv where xucv.report_name=:upload_name and xucv.column_name not in ('ACTION_','STATUS_','UPLOAD_ROW') order by xucv.column_number ) x ) y where :upload_name not like '%;%' US Upload Name 4 20 1=1 xrr.created_by=:user_name LOV custom Y select fu.user_id id, xxen_util.user_name(fu.user_id) value, xrr.count description from fnd_user fu, (select count(*) count, xrr.created_by from xxen_report_runs xrr where xrr.run_id in (select xud.run_id from xxen_upload_data xud) group by xrr.created_by) xrr where fu.user_id=xrr.created_by order by xrr.count desc, fu.user_name US User Name 5 30 1=1 xrr.creation_date>sysdate-:days Number select 1 from dual where :$flex$.upload_name is null and :$flex$.uploaded_by is null US Started within Days 6 40 1=1 xrr.upload_request_id=:upload_request_id LOV custom Y select xrr.upload_request_id value, xrr.creation_date||', '||xrv.report_name||', '||xxen_util.user_name(xrr.created_by) description from (select distinct xud.run_id from xxen_upload_data xud) xud, xxen_report_runs xrr, xxen_reports_v xrv where xrr.upload_request_id is not null and xud.run_id=xrr.run_id and xrr.report_id=xrv.report_id order by xud.run_id desc US Upload Request Id 7 50 1=1 xrr.request_id=:report_request_id LOV custom Y select xrr.request_id value, xrr.creation_date||', '||xrv.report_name||', '||xxen_util.user_name(xrr.created_by) description from (select distinct xud.run_id from xxen_upload_data xud) xud, xxen_report_runs xrr, xxen_reports_v xrv where xud.run_id=xrr.run_id and xrr.report_id=xrv.report_id order by xud.run_id desc US Report Request Id 8 60 1=1 xrr.run_id=:p_run_id LOV custom Y select xrr.run_id value, xrr.creation_date||', '||xrv.report_name||', '||xxen_util.user_name(xrr.created_by) description from (select distinct xud.run_id from xxen_upload_data xud) xud, xxen_report_runs xrr, xxen_reports_v xrv where xud.run_id=xrr.run_id and xrr.report_id=xrv.report_id order by xud.run_id desc US Run Id 9 70 1=1 xud.upload_row<:max_rows_per_upload+2 Number select 100 from dual where :$flex$.run_id is null and :$flex$.upload_request_id is null and :$flex$.result_request_id is null US Maximum rows per upload :$flex$.report_request_id Report Request Id Upload Name :$flex$.run_id Run Id Maximum rows per upload :$flex$.run_id Run Id Upload Name :$flex$.upload_name Upload Name Started within Days :$flex$.upload_request_id Upload Request Id Maximum rows per upload :$flex$.upload_request_id Upload Request Id Upload Name