APPS.FND_NET_SERVICES dependencies on FND_DATABASES

Line 246: from fnd_tns_alias_descriptions a, fnd_databases b,

242: then
243:
244: select a.*
245: into l_sourceDesc
246: from fnd_tns_alias_descriptions a, fnd_databases b,
247: fnd_tns_aliases c
248: where b.db_guid = l_db_guid
249: and b.Default_Tns_Alias_Guid = c.tns_alias_guid
250: and c.tns_alias_guid = a.tns_alias_guid

Line 939: from fnd_databases a

935: );
936:
937: select a.db_guid , a.Default_TNS_Alias_Guid
938: into l_db_guid, l_db_Default_TNS_Alias_Guid
939: from fnd_databases a
940: where a.db_name = DatabaseName
941: and a.db_domain = Domain;
942:
943: fnd_app_system.register_Database_Asg

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 2290: from fnd_databases

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
2290: from fnd_databases
2291: where db_guid = p_db_guid;
2292:
2293: cursor c3(p_db_guid raw)
2294: is select assignment

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 2749: delete from fnd_databases a

2745: and not exists ( select b.instance_guid
2746: from fnd_db_service_members b
2747: where b.db_service_guid = a.db_service_guid );
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 );

Line 2759: from fnd_databases b

2755: delete from fnd_database_assignments a
2756: where a.db_guid = f_instance.db_guid
2757: and a.assignment = fnd_app_system.C_APP_DB_ASSIGNMENT
2758: and not exists ( select 1
2759: from fnd_databases b
2760: where b.db_guid = a.db_guid ) ;
2761:
2762: end loop;
2763:

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