FNDNODES

 clear columns

set lines 180

set pages 50

col NODE_NAME for a15 WORD_WRAPPED

COL SUPPORT_DB for a12

COL SUPPORT_CP for a12

COL SUPPORT_ADMIN for a15

COL SUPPORT_FORMS for a15

COL SUPPORT_WEB for a12

COL HOST for a15 WORD_WRAPPED

Col STATUS for a10

col DOMAIN for a20 WORD_WRAPPED

select NODE_NAME,SUPPORT_DB,SUPPORT_CP,SUPPORT_ADMIN,SUPPORT_WEB,SUPPORT_FORMS,STATUS,HOST,DOMAIN 

from apps.fnd_nodes;