APPS.FND_NET_SERVICES dependencies on FND_TNS_ALIAS_SET_USAGE

Line 782: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,

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

Line 1216: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,

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

Line 1407: from fnd_system_server_map a,fnd_tns_alias_set_usage b,

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

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

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

Line 2989: from fnd_tns_alias_set_usage b

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

Line 2992: delete from fnd_tns_alias_set_usage a

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