Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

no output in output files [Oracle Applications]

edited Aug 10, 2018 9:43AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered ✓

PROCEDURE show_prog_maxminavg (u_con_prog_name varchar2, u_no_of_days number)

is

cursor cal_prog_avg

is

select v.user_concurrent_program_name, c.concurrent_program_id,

round (AVG ( ( nvl(c.actual_completion_date, SYSDATE) - c.ACTUAL_START_DATE)*24*60),3) avg_run_value,

round (MAX ( ( nvl(c.actual_completion_date, SYSDATE) - c.ACTUAL_START_DATE)*24*60),3) max_run_value,

round (MIN ( ( nvl(c.actual_completion_date, SYSDATE) - c.ACTUAL_START_DATE)*24*60),3) min_run_value

from fnd_concurrent_programs_vl v join fnd_concurrent_requests_bkp c

on(v.concurrent_program_id = c.concurrent_program_id)

where v.USER_CONCURRENT_PROGRAM_NAME = u_con_prog_name

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center