APPS.FND_NET_SERVICES dependencies on FND_TNS_ALIAS_SET_USAGE

Line 784: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,

780: cursor c4(p_system_guid raw)
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

Line 1218: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,

1214:
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

Line 1409: from fnd_system_server_map a,fnd_tns_alias_set_usage b,

1405: and c.Tns_Alias_Address_List_Guid = b.Tns_Alias_Address_List_Guid;
1406:
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

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 2931: fnd_tns_alias_address_lists c,fnd_tns_alias_set_usage d

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
2935: and b.Tns_Alias_Description_Guid = c.Tns_Alias_Description_Guid(+);

Line 2991: from fnd_tns_alias_set_usage b

2987:
2988: delete from fnd_tns_alias_sets a
2989: where a.tns_alias_set_guid
2990: in ( select b.tns_alias_set_guid
2991: from fnd_tns_alias_set_usage b
2992: where b.server_guid = f_server.server_guid );
2993:
2994: delete from fnd_tns_alias_set_usage a
2995: where a.server_guid = f_server.server_guid;

Line 2994: delete from fnd_tns_alias_set_usage a

2990: in ( select b.tns_alias_set_guid
2991: from fnd_tns_alias_set_usage b
2992: where b.server_guid = f_server.server_guid );
2993:
2994: delete from fnd_tns_alias_set_usage a
2995: where a.server_guid = f_server.server_guid;
2996:
2997: delete from fnd_system_server_map a
2998: where a.System_GUID = f_system.System_Guid