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 247: fnd_tns_aliases c

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
251: and a.sequence_number = 0;

Line 258: fnd_tns_aliases c

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

Line 420: from fnd_tns_aliases a, fnd_tns_alias_sets b

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

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

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

Line 785: fnd_tns_aliases e, fnd_tns_alias_descriptions f

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

Line 1219: fnd_tns_aliases e

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

Line 1237: from fnd_tns_aliases a

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

Line 1282: from fnd_tns_aliases a

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

Line 1327: -- between FND_TNS_ALIASES and FND_TNS_ALIAS_DESCRIPTIONS.

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

Line 1366: l_tns_aliases_rec fnd_tns_aliases%rowtype;

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

Line 1392: from fnd_tns_aliases a

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

Line 1411: fnd_tns_aliases e

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

Line 1452: from fnd_tns_aliases a

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

Line 1494: from fnd_tns_aliases a

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

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

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

Line 1922: from fnd_tns_aliases a

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

Line 1935: from fnd_tns_aliases a

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

Line 2112: from fnd_tns_aliases a,fnd_tns_alias_sets b

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

Line 2247: from fnd_tns_aliases a, fnd_tns_alias_set_usage b

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

Line 2255: from fnd_tns_aliases a, fnd_tns_alias_set_usage b

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

Line 2315: from fnd_tns_aliases a, fnd_tns_alias_set_usage b

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

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

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

Line 2711: delete from fnd_tns_aliases a

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

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

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

Line 2874: delete from fnd_tns_aliases a

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

Line 2930: from fnd_tns_aliases a,fnd_tns_alias_descriptions b,

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

Line 2981: delete from fnd_tns_aliases a

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