Sunday 8 March 2015

EBS : Patchset level query

select fpi.patch_level,
fa.application_short_name,
fa.application_id
from fnd_product_installations fpi,
fnd_application fa
where fa.application_short_name = '&PATCHSET_SHORT_NAME'
and fa.application_id = fpi.application_id;

Note: Provide the patchset_short_name as input
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQL Developer displaying Junk characters (??????)

Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...