Query: Auto Refresh DISCO reports details

select FU.USER_NAME, FU.description,
BR.BR_CREATED_DATE,BR.BR_NEXT_RUN_DATE,
‘Every ‘ || br.br_num_freq_units || ‘ ‘ ||
DECODE(br.br_rfu_id,
2000,’Minutes’,
2001,’Hours’,
2002,’Days’,
2003,’Weeks’,
2004,’Months’,’Years’) “Run Frequency”,
BR.BR_WORKBOOK_NAME, BR.BR_NUM_FREQ_UNITS,BR.BR_RFU_ID,
BR.* from
DISCEUL_US.EUL5_BATCH_REPORTS BR, APPS.FND_USER FU
where
BR.BR_AUTO_REFRESH = 1
AND replace(BR.BR_CREATED_BY, ‘#’,”) = FU.USER_ID
ORDER BY USER_NAME;

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: