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_TNS_ALIASES

Line 245: fnd_tns_aliases c

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

Line 256: fnd_tns_aliases c

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
260: and c.tns_alias_guid = a.tns_alias_guid

Line 418: from fnd_tns_aliases a, fnd_tns_alias_sets b

414: if ( l_tns_alias_guid is null )
415: then
416: select a.tns_alias_guid
417: into l_tns_alias_guid
418: from fnd_tns_aliases a, fnd_tns_alias_sets b
419: where b.tns_alias_set_name = p_alias_set_name
420: and b.tns_alias_set_guid = a.alias_set_guid
421: and a.alias_name = p_alias_name;
422: end if;

Line 775: -- FND_TNS_ALIASES and FND_TNS_ALIAS_DESCRIPTIONS we can remove this

771: -- Cursor c4 was originally designed just to fetch unresolved descriptors
772: -- (seq_no < 0 ). But because we clone alt descriptors we need to rebuild
773: -- every alt descriptor on each call. So we look for all non-zero
774: -- sequence_numbers. When we add a detail table to sit in between
775: -- FND_TNS_ALIASES and FND_TNS_ALIAS_DESCRIPTIONS we can remove this
776: -- restriction.
777:
778: cursor c4(p_system_guid raw)
779: is select f.Tns_Alias_Description_Guid,

Line 783: fnd_tns_aliases e, fnd_tns_alias_descriptions f

779: is select f.Tns_Alias_Description_Guid,
780: e.alias_name,d.tns_alias_set_name
781: from fnd_system_server_map a, fnd_app_servers b,
782: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,
783: fnd_tns_aliases e, fnd_tns_alias_descriptions f
784: where a.System_GUID = p_System_Guid
785: and a.Server_GUID = b.Server_GUID
786: and b.server_type = fnd_app_system.C_DB_SERVER_TYPE
787: and a.Server_GUID = c.Server_GUID

Line 1217: fnd_tns_aliases e

1213: select count(*)
1214: into l_db_alias_exists
1215: from fnd_system_server_map a, fnd_app_servers b,
1216: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,
1217: fnd_tns_aliases e
1218: where a.System_GUID = l_System_Guid
1219: and a.Server_GUID = b.Server_GUID
1220: and b.server_type = fnd_app_system.C_DB_SERVER_TYPE
1221: and b.server_guid <> l_Server_Guid

Line 1235: from fnd_tns_aliases a

1231: begin
1232:
1233: select a.TNS_ALIAS_GUID
1234: into l_tns_db_alias
1235: from fnd_tns_aliases a
1236: where a.Alias_Name = DatabaseName
1237: and a.alias_set_guid = l_tns_alias_set_guid_pub;
1238:
1239: exception

Line 1280: from fnd_tns_aliases a

1276: -- Register InstanceSid if different to database.
1277:
1278: select count(*)
1279: into l_db_alias_exists
1280: from fnd_tns_aliases a
1281: where a.Alias_Name = InstanceSid
1282: and a.alias_set_guid = l_tns_alias_set_guid_pub;
1283:
1284: if ( l_db_alias_exists = 0 )

Line 1325: -- between FND_TNS_ALIASES and FND_TNS_ALIAS_DESCRIPTIONS.

1321:
1322: -- Now've registered, see if this instance fixes any unresolved
1323: -- descriptors. Note c4 fetches all alt descriptors not just unresolved
1324: -- descriptors. This is due to the model not having a detail table
1325: -- between FND_TNS_ALIASES and FND_TNS_ALIAS_DESCRIPTIONS.
1326:
1327: for f_resolve in c4(l_system_guid) loop
1328:
1329: select a.*

Line 1364: l_tns_aliases_rec fnd_tns_aliases%rowtype;

1360: l_db_service_guid raw(16);
1361: l_port_list_tns_guid raw(16);
1362: l_system_name varchar2(100);
1363:
1364: l_tns_aliases_rec fnd_tns_aliases%rowtype;
1365: l_tns_descriptions_rec fnd_tns_alias_descriptions%rowtype;
1366:
1367: l_db_alias_exists boolean;
1368: l_app_alias_exists boolean;

Line 1390: from fnd_tns_aliases a

1386: where a.db_guid = p_db_guid ;
1387:
1388: cursor c3(p_alias_name varchar2,p_alias_set_guid raw,p_alias_type varchar2) is
1389: select a.tns_alias_guid,a.alias_type
1390: from fnd_tns_aliases a
1391: where a.alias_name = p_alias_name
1392: and a.alias_set_guid = p_alias_set_guid
1393: and ( a.alias_type = nvl(p_alias_type,a.alias_type)
1394: or a.alias_type = fnd_app_system.C_DB_INST_TNS_ALIAS_TYPE );

Line 1409: fnd_tns_aliases e

1405: cursor c5(p_System_Guid raw,p_alias_name varchar2,p_alias_type varchar2) is
1406: select e.Tns_Alias_Guid,e.Alias_Type
1407: from fnd_system_server_map a,fnd_tns_alias_set_usage b,
1408: fnd_tns_alias_sets c, fnd_app_servers d,
1409: fnd_tns_aliases e
1410: where a.system_guid = p_System_Guid
1411: and a.server_guid = b.server_guid
1412: and b.tns_alias_set_guid = c.tns_alias_set_guid
1413: and c.tns_alias_set_type = fnd_app_system.C_ALIAS_SET_NAME_PUB

Line 1450: from fnd_tns_aliases a

1446: l_db_alias_exists := true;
1447:
1448: select a.*
1449: into l_tns_aliases_rec
1450: from fnd_tns_aliases a
1451: where a.tns_alias_guid = f_valid.Tns_Alias_Guid;
1452:
1453: for f_desc in c6(f_valid.Tns_Alias_Guid) loop
1454:

Line 1492: from fnd_tns_aliases a

1488: l_app_alias_exists := true;
1489:
1490: select a.*
1491: into l_tns_aliases_rec
1492: from fnd_tns_aliases a
1493: where a.alias_name = alias
1494: and a.alias_set_guid = alias_set_guid;
1495:
1496: for f_desc in c6(l_tns_aliases_rec.Tns_Alias_Guid) loop

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 1696: fnd_tns_aliases d

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
1700: and b.server_guid in ( select x.server_guid

Line 1920: from fnd_tns_aliases a

1916: begin
1917:
1918: select a.TNS_ALIAS_GUID
1919: into l_fndfs_tns_alias
1920: from fnd_tns_aliases a
1921: where a.Alias_Name = l_fndfs_alias
1922: and a.Alias_set_guid = l_tns_alias_set_guid_pub;
1923:
1924: exception

Line 1933: from fnd_tns_aliases a

1929: begin
1930:
1931: select a.TNS_ALIAS_GUID
1932: into l_fndsm_tns_alias
1933: from fnd_tns_aliases a
1934: where a.Alias_Name = l_fndsm_alias
1935: and a.Alias_set_guid = l_tns_alias_set_guid_pub;
1936:
1937: exception

Line 2110: from fnd_tns_aliases a,fnd_tns_alias_sets b

2106: cursor c1 is select a.alias_name,a.Alias_Type,
2107: a.Failover,a.Load_Balance,
2108: b.tns_alias_set_name,
2109: b.tns_alias_set_type
2110: from fnd_tns_aliases a,fnd_tns_alias_sets b
2111: where a.tns_alias_guid = p_tns_alias_guid
2112: and a.alias_set_guid = b.tns_alias_set_guid;
2113:
2114: cursor c2 is select c.tns_alias_description_guid,

Line 2245: from fnd_tns_aliases a, fnd_tns_alias_set_usage b

2241: l_fndsm_sid varchar2(50);
2242:
2243: cursor c1 is
2244: select a.TNS_ALIAS_GUID
2245: from fnd_tns_aliases a, fnd_tns_alias_set_usage b
2246: where a.Alias_Name like 'FNDFS%'
2247: and a.Alias_Type = fnd_app_system.C_FNDFS_TNS_ALIAS_TYPE
2248: and b.server_guid = p_Server_Guid
2249: and a.alias_set_guid = b.tns_alias_set_guid;

Line 2253: from fnd_tns_aliases a, fnd_tns_alias_set_usage b

2249: and a.alias_set_guid = b.tns_alias_set_guid;
2250:
2251: cursor c2 is
2252: select a.TNS_ALIAS_GUID
2253: from fnd_tns_aliases a, fnd_tns_alias_set_usage b
2254: where a.Alias_Name like 'FNDSM%'
2255: and a.Alias_Type = fnd_app_system.C_FNDSM_TNS_ALIAS_TYPE
2256: and b.server_guid = p_Server_Guid
2257: and a.alias_set_guid = b.tns_alias_set_guid;

Line 2313: from fnd_tns_aliases a, fnd_tns_alias_set_usage b

2309: where db_guid = p_db_guid;
2310:
2311: cursor c6(p_db_name varchar2,p_server_guid raw) is
2312: select a.TNS_ALIAS_GUID
2313: from fnd_tns_aliases a, fnd_tns_alias_set_usage b
2314: where a.Alias_Name = p_db_name
2315: and a.Alias_Type = fnd_app_system.C_DB_INST_TNS_ALIAS_TYPE
2316: and b.Server_Guid = p_server_guid
2317: and b.Tns_Alias_Set_Guid = a.Alias_Set_Guid;

Line 2690: -- Note on delete of : fnd_tns_aliases and fnd_tns_alias_descriptions

2686: from fnd_tns_alias_addresses c
2687: where c.Tns_Alias_Address_List_Guid
2688: = a.Tns_Alias_Address_List_Guid );
2689:
2690: -- Note on delete of : fnd_tns_aliases and fnd_tns_alias_descriptions
2691: -- The deletes remove all dangling references, not just the
2692: -- current db node. Since the only dangling references should be
2693: -- this node this seems ok.
2694:

Line 2709: delete from fnd_tns_aliases a

2705: and a.sequence_number >= 0;
2706:
2707: -- An alias will always have a descriptor, so ok.
2708:
2709: delete from fnd_tns_aliases a
2710: where not exists ( select 1
2711: from fnd_tns_alias_descriptions b
2712: where b.Tns_Alias_Guid = a.Tns_Alias_Guid );
2713:

Line 2853: -- Note on delete of : fnd_tns_aliases and fnd_tns_alias_descriptions

2849: from fnd_tns_alias_addresses c
2850: where c.Tns_Alias_Address_List_Guid
2851: = a.Tns_Alias_Address_List_Guid );
2852:
2853: -- Note on delete of : fnd_tns_aliases and fnd_tns_alias_descriptions
2854: -- The deletes remove all dangling references, not just the
2855: -- current db node. Since the only dangling references should be
2856: -- this node this seems ok.
2857:

Line 2872: delete from fnd_tns_aliases a

2868: and a.sequence_number >= 0;
2869:
2870: -- An alias will always have a descriptor, so ok.
2871:
2872: delete from fnd_tns_aliases a
2873: where not exists ( select 1
2874: from fnd_tns_alias_descriptions b
2875: where b.Tns_Alias_Guid = a.Tns_Alias_Guid );
2876:

Line 2928: from fnd_tns_aliases a,fnd_tns_alias_descriptions b,

2924:
2925: cursor c4(p_Server_GUID raw) is
2926: select a.tns_alias_guid,b.Tns_Alias_Description_Guid,
2927: c.Tns_Alias_Address_List_Guid
2928: from fnd_tns_aliases a,fnd_tns_alias_descriptions b,
2929: fnd_tns_alias_address_lists c,fnd_tns_alias_set_usage d
2930: where d.server_guid = p_server_guid
2931: and d.tns_alias_set_guid = a.alias_set_guid
2932: and a.tns_alias_guid = b.tns_alias_guid

Line 2979: delete from fnd_tns_aliases a

2975: f_alias.Tns_Alias_Address_List_Guid;
2976:
2977: end if;
2978:
2979: delete from fnd_tns_aliases a
2980: where a.tns_alias_guid = f_alias.tns_alias_guid;
2981:
2982: end loop;
2983: