Query To Get FND NODES Details

Download(fndnodes.sql)

REM +======================================================================+
REM                    
REM File Name: fndnodes.sql
REM 
REM Description:
REM   Query To Get FND NODES Details 
REM   
REM Notes:
REM   Usage: sqlplus <apps_user/apps_passwd> @fndnodes.sql 
REM   
REM +======================================================================+

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;