Reports2017-11-18T12:27:27+00:00

FND Applications

Description
Categories: Application, Enginatics
Shows all applications, their installation status, correponding database schema and application top name

select
fav.application_name,
fav.application_short_name,
fav.product_code,
fou.oracle_username,
xxen_util.meaning(decode(du.editions_enabled,'Y','Y'),'YES_NO',0) editions_enabled,
xxen_util.meaning(fpi.status,'FND_PRODUCT_STATUS',0) status,
fav.basepath,
fav.description,
fav.application_id
from
fnd_application_vl fav,
fnd_product_installations fpi,
fnd_oracle_userid fou,
dba_users du
where
1=1 and
fav.application_id=fpi.application_id(+) and
fpi.oracle_id=fou.oracle_id(+) and
fou.oracle_username=du.username(+)
order by
fav.application_short_name

Parameter Name SQL text Validation
Application Name
fav.application_name=:application_name
LOV
Application Short Name
fav.application_short_name=:short_name
LOV

By continuing to use the site, you agree to the use of cookies. Accept