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 182: from fnd_database_instances a, fnd_database_services b,

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

Line 255: from fnd_tns_alias_descriptions a, fnd_database_instances b,

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

Line 748: l_instRec fnd_database_instances%rowtype;

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

Line 762: from fnd_database_instances a

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

Line 796: from fnd_database_services a,fnd_database_instances b

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

Line 968: from fnd_database_instances a

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

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

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

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

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

Line 1375: from fnd_databases a,fnd_database_instances b,

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

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

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

Line 2075: from fnd_database_services a, fnd_database_instances b,

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

Line 2283: from fnd_database_instances

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

Line 2652: from fnd_database_instances a,fnd_databases b

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

Line 2731: delete from fnd_database_instances a

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

Line 2750: from fnd_database_instances b

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

Line 2921: from fnd_database_instances a,fnd_databases b

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