FND Nodes
Description
Categories: Enginatics
Repository: Github
Repository: Github
FND_NODES stores information about the nodes that are used to
install and run Oracle Application at your site. Each row includes
the name of the node and the platform code. The column name
NODE_NAME is the given name used to refer to the machine or node
at the site. The column PLATFORM_CODE specifies the make of the
machine or node (e.g. DEC VMS, Sequent Ptx, etc.). This
informat ... more
install and run Oracle Application at your site. Each row includes
the name of the node and the platform code. The column name
NODE_NAME is the given name used to refer to the machine or node
at the site. The column PLATFORM_CODE specifies the make of the
machine or node (e.g. DEC VMS, Sequent Ptx, etc.). This
informat ... more
select fn.node_name, xxen_util.meaning(decode(fn.support_db,'Y','Y'),'YES_NO',0) database, xxen_util.meaning(decode(fn.support_cp,'Y','Y'),'YES_NO',0) concurrent, xxen_util.meaning(decode(fn.support_forms,'Y','Y'),'YES_NO',0) forms, xxen_util.meaning(decode(fn.support_web,'Y','Y'),'YES_NO',0) web, xxen_util.meaning(decode(fn.support_admin,'Y','Y'),'YES_NO',0) admin, xxen_util.meaning(decode(fn.status,'Y','Y'),'YES_NO',0) status, fn.description, fn.ping_response, xxen_util.meaning(fn.platform_code,'PLATFORM',0) platform, fn.server_address ip_address, fn.host, fn.domain, fn.webhost, fn.virtual_ip, fn.server_id, fn.appltop_id, fn.node_mode, xxen_util.user_name(fn.created_by) created_by, xxen_util.client_time(fn.creation_date) creation_date, xxen_util.user_name(fn.last_updated_by) last_updated_by, xxen_util.client_time(fn.last_update_date) last_update_date from fnd_nodes fn order by fn.support_db desc, fn.support_cp desc, fn.node_name |