eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_NET_SERVICES dependencies on FND_DATABASE_INSTANCES

Line 184: from fnd_database_instances a, fnd_database_services b,

180: then
181:
182: select count(*)
183: into l_valid_instance
184: from fnd_database_instances a, fnd_database_services b,
185: fnd_db_service_members c
186: where a.db_guid = l_db_guid
187: and a.Instance_Name = p_Instance_name
188: and a.db_guid = b.db_guid

Line 257: from fnd_tns_alias_descriptions a, fnd_database_instances b,

253: else
254:
255: select a.*
256: into l_sourceDesc
257: from fnd_tns_alias_descriptions a, fnd_database_instances b,
258: fnd_tns_aliases c
259: where b.db_guid = l_db_guid
260: and b.Instance_Name = p_instance_name
261: and b.Default_Tns_Alias_Guid = c.tns_alias_guid

Line 750: l_instRec fnd_database_instances%rowtype;

746: l_internal_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;
747:
748: l_listener_port_guid raw(16);
749:
750: l_instRec fnd_database_instances%rowtype;
751:
752: alt_instance_table alt_instance_type;
753: alt_check_table alt_instance_type;
754: empty_instance_table alt_instance_type;

Line 764: from fnd_database_instances a

760: l_db_alias_exists number;
761:
762: cursor c2(p_db_guid raw)
763: is select a.remote_listener_alias
764: from fnd_database_instances a
765: where a.db_guid = p_db_guid
766: and a.remote_listener_alias is not null;
767:
768: cursor c3(p_listener_guid raw)

Line 798: from fnd_database_services a,fnd_database_instances b

794: and f.sequence_number <> 0;
795:
796: cursor c5(p_db_guid raw,p_instance_guid raw,p_service_name varchar2)
797: is select a.service_name,b.instance_name
798: from fnd_database_services a,fnd_database_instances b
799: where a.db_guid = p_db_guid
800: and b.db_guid = p_db_guid
801: and ( b.Instance_Guid <> p_instance_guid
802: or ( b.Instance_Guid = p_instance_guid and

Line 970: from fnd_database_instances a

966: ) ;
967:
968: select a.*
969: into l_instRec
970: from fnd_database_instances a
971: where a.db_guid = l_db_guid
972: and a.Instance_Name = InstanceName;
973:
974: -- Register Sid - use Sid_Guid already allocated in fnd_database_instances.

Line 974: -- Register Sid - use Sid_Guid already allocated in fnd_database_instances.

970: from fnd_database_instances a
971: where a.db_guid = l_db_guid
972: and a.Instance_Name = InstanceName;
973:
974: -- Register Sid - use Sid_Guid already allocated in fnd_database_instances.
975:
976: fnd_app_system.register_Sid ( Sid => InstanceSid,
977: sid_guid => l_instRec.sid_guid
978: );

Line 1118: -- Set Remote_Listener_Alias in fnd_database_instances if null.

1114:
1115: -- Create Remote DB listener alias. We supply the Service Name, to make
1116: -- it easier to get all listeners.
1117:
1118: -- Set Remote_Listener_Alias in fnd_database_instances if null.
1119:
1120: if ( l_instRec.Remote_Listener_Alias is null or
1121: l_instRec.Remote_Listener_Alias <> l_remote_tns_alias_guid )
1122: then

Line 1377: from fnd_databases a,fnd_database_instances b,

1373:
1374: cursor c1(p_System_Guid raw) is
1375: select b.db_guid,b.default_tns_alias_guid instance_tns_alias_guid,
1376: a.default_tns_alias_guid db_tns_alias_guid,b.instance_guid
1377: from fnd_databases a,fnd_database_instances b,
1378: fnd_system_server_map c, fnd_app_servers d
1379: where c.system_guid = p_System_Guid
1380: and d.server_guid = c.server_guid
1381: and d.server_type = fnd_app_system.C_DB_SERVER_TYPE

Line 1697: from fnd_databases a, fnd_database_instances b, fnd_tns_aliases c,

1693:
1694: cursor c1(p_System_Guid raw) is
1695: select c.alias_name instance_alias,d.alias_name load_balance_alias,
1696: a.db_name
1697: from fnd_databases a, fnd_database_instances b, fnd_tns_aliases c,
1698: fnd_tns_aliases d
1699: where b.default_tns_alias_guid = c.tns_alias_guid
1700: and b.db_guid = a.db_guid
1701: and a.Default_TNS_Alias_GUID = d.tns_alias_guid

Line 2077: from fnd_database_services a, fnd_database_instances b,

2073: procedure show_service_instance(p_DB_Service_GUID raw,p_instance_guid raw)
2074: as
2075: cursor c1 is select a.service_name,b.Instance_Name,b.Instance_Number,
2076: c.instance_type
2077: from fnd_database_services a, fnd_database_instances b,
2078: fnd_db_service_members c
2079: where a.DB_Service_GUID = p_DB_Service_GUID
2080: and b.Instance_Guid = p_instance_guid
2081: and a.Db_Service_Guid = c.Db_Service_Guid

Line 2285: from fnd_database_instances

2281: cursor c1 is select db_guid,Instance_Guid,Instance_Name,Instance_Number,
2282: Sid_GUID,Default_TNS_Alias_GUID,sid,
2283: Local_Listener_Alias,Remote_Listener_Alias,
2284: Configuration,Description,Interconnect_name
2285: from fnd_database_instances
2286: where Server_Guid = p_Server_Guid;
2287:
2288: cursor c2(p_db_guid raw)
2289: is select db_name,db_domain,default_tns_alias_guid,is_rac_db,version

Line 2654: from fnd_database_instances a,fnd_databases b

2650: a.local_listener_alias,
2651: a.remote_listener_alias,
2652: b.db_guid,
2653: b.default_tns_alias_guid db_tns_alias_guid
2654: from fnd_database_instances a,fnd_databases b
2655: where a.Server_GUID = p_Server_GUID
2656: and a.Instance_Name = p_InstanceName
2657: and a.db_guid = b.db_guid
2658: and b.DB_Name = p_DatabaseName

Line 2733: delete from fnd_database_instances a

2729:
2730: for f_instance in c3(f_server.Server_GUID,InstanceName,DatabaseName,
2731: Domain) loop
2732:
2733: delete from fnd_database_instances a
2734: where a.instance_guid = f_instance.instance_guid;
2735:
2736: delete from fnd_db_service_members a
2737: where a.db_guid = f_instance.db_guid

Line 2752: from fnd_database_instances b

2748:
2749: delete from fnd_databases a
2750: where a.db_guid = f_instance.db_guid
2751: and not exists ( select b.instance_guid
2752: from fnd_database_instances b
2753: where b.db_guid = a.db_guid );
2754:
2755: delete from fnd_database_assignments a
2756: where a.db_guid = f_instance.db_guid

Line 2923: from fnd_database_instances a,fnd_databases b

2919: and b.name = p_ServerName;
2920:
2921: cursor c3(p_Server_GUID raw) is
2922: select a.instance_name,b.DB_Name,b.DB_Domain
2923: from fnd_database_instances a,fnd_databases b
2924: where a.Server_GUID = p_Server_GUID
2925: and a.db_guid = b.db_guid;
2926:
2927: cursor c4(p_Server_GUID raw) is