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 apps.ad_bugs
WHERE bug_number IN
(
'3438354',
'4017300',
'4125550',
'4334965',
'4676589',
'5473858',
'5903765',
'6241631')
order by bug_number desc
/
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps
Subscribe to:
Post Comments (Atom)
5 comments:
Hi, Thanks for this nice query. On question though. Why are you using bugnumber '3384350' in the WHERE claues and not in the SELECT clause?
Kind regards
Ger van de Lindt
Hi,
If you notice, the select cause is using decode function, that is the reason I have bug number in the select clause. It works like this, If you have a patch number, then the correct description needs to be shown.
- Vikram
Hi Vikram
Thanks for the query. I have the same question that was asked in the previous post. You probably have misunderstood the question. Why there is no description for the patch no 3384350?
Regards,
Nico
Hi Nico,
Thanks for pointing this out. I realize now that 3384350 is not supposed to be in the query. Patch 3384350 is the 11i SCM family pack J and has no meaning in this query. I have corrected the query and removed 3384350 from the query.
- Vikram
How to find the RUP level in R12 instance ??
Post a Comment