Saturday, November 06, 2010

Find your ATG Rollup Patch Level

Use the following query to find the ATG rollup Patch level in your application.

connect as apps:

SELECT (bug_number),
decode((bug_number),
'3438354','ATG_PF.H',
'4017300','ATG_PF.H RUP 1',
'4125550','ATG_PF.H RUP 2',
'4334965','ATG_PF.H RUP 3',
'4676589','ATG_PF.H RUP 4',
'5473858','ATG_PF.H RUP 5',
'5903765','ATG_PF.H RUP 6',
'6241631','ATG_PF.H RUP 7')
FROM ad_bugs
WHERE bug_number IN
('3384350',
'3438354',
'4017300',
'4125550',
'4334965',
'4676589',
'5473858',
'5903765',
'6241631')
order by bug_number desc





Regards,
Sukhwinder Singh.


.

1 comment:

  1. This is for 11i, how to find RUP level in R12??

    ReplyDelete

Note: Only a member of this blog may post a comment.