1.Operating system
uname -a
2. Database
sqlplus apps/apps
3. Oracle applications
select release_name from fnd_product_group;
4. Forms, sql, pls, reports
strings file_name |grep $Header
or use this:
SELECT 'strings $'
|| DECODE (app_short_name,
'OFA', 'FA',
'SQLGL', 'GL',
'SQLAP', 'AP',
app_short_name
)
|| '_TOP/'
|| subdir
|| '/'
|| filename
|| ' | grep Header'
FROM ad_files
WHERE filename = '<your file name>';
5. Database objects
select text
from user_source
where name='&package_name' and text like '%$Header%';
select name, text
from dba_source
where text like '%.pls%' and line < 10;
select VIEW_NAME, TEXT
from USER_VIEWS
where VIEW_NAME = '&VIEW_NAME';
6. Workflow
select * from WF_RESOURCES where NAME='WF_VERSION';
No comments:
Post a Comment