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_ALIAS_ADDRESSES

Line 145: from fnd_tns_alias_addresses a

141: order by a.sequence_number;
142:
143: cursor c2(p_tns_address_list_guid raw) is
144: select a.Listener_Port_Guid
145: from fnd_tns_alias_addresses a
146: where a.Tns_Alias_Address_List_Guid = p_tns_address_list_guid
147: order by a.Listener_Port_Guid;
148:
149: begin

Line 208: delete from fnd_tns_alias_addresses a

204: l_descRec.Db_Instance_Guid:= null;
205: l_descRec.Service_Name := p_Service_Name;
206: l_descRec.Instance_Name := p_Instance_name;
207:
208: delete from fnd_tns_alias_addresses a
209: where a.Tns_Alias_Address_List_Guid
210: in ( select b.Tns_Alias_Address_List_Guid
211: from fnd_tns_alias_address_lists b
212: where b.Tns_Alias_Description_Guid

Line 299: delete from fnd_tns_alias_addresses a

295: );
296:
297: -- Delete current addresses/list and clone from source.
298:
299: delete from fnd_tns_alias_addresses a
300: where a.Tns_Alias_Address_List_Guid
301: in ( select b.Tns_Alias_Address_List_Guid
302: from fnd_tns_alias_address_lists b
303: where b.Tns_Alias_Description_Guid

Line 589: delete from fnd_tns_alias_addresses a

585: then
586:
587: -- Need to delete Address_Lists, and addresses.
588:
589: delete from fnd_tns_alias_addresses a
590: where a.Tns_Alias_Address_List_Guid
591: in ( select b.Tns_Alias_Address_List_Guid
592: from fnd_tns_alias_address_lists b
593: where b.Tns_Alias_Description_Guid

Line 1401: fnd_tns_alias_addresses c

1397:
1398: cursor c4(p_tns_alias_guid raw) is
1399: select c.listener_port_guid
1400: from fnd_tns_alias_descriptions a, fnd_tns_alias_address_lists b,
1401: fnd_tns_alias_addresses c
1402: where a.tns_alias_guid = p_tns_alias_guid
1403: and a.sequence_number= 0
1404: and b.Tns_Alias_Description_Guid = a.Tns_Alias_Description_Guid
1405: and c.Tns_Alias_Address_List_Guid = b.Tns_Alias_Address_List_Guid;

Line 2018: from fnd_tns_alias_address_lists a, fnd_tns_alias_addresses b,

2014: procedure show_tns_addresses(p_Tns_Alias_Description_Guid raw)
2015: as
2016: cursor c1 is select d.listener_name,c.port,
2017: a.sequence_number,a.failover,a.load_balance
2018: from fnd_tns_alias_address_lists a, fnd_tns_alias_addresses b,
2019: fnd_tns_listener_ports c, fnd_tns_listeners d
2020: where a.Tns_Alias_Description_Guid = p_Tns_Alias_Description_Guid
2021: and a.Tns_Alias_Address_List_Guid =
2022: b.Tns_Alias_Address_List_Guid

Line 2684: from fnd_tns_alias_addresses b,fnd_tns_listener_ports c

2680:
2681: delete from fnd_tns_alias_address_lists a
2682: where a.Tns_Alias_Address_List_Guid
2683: in ( select b.Tns_Alias_Address_List_Guid
2684: from fnd_tns_alias_addresses b,fnd_tns_listener_ports c
2685: where b.listener_port_guid = c.listener_port_guid
2686: and c.Listener_GUID = f_server.Listener_GUID )
2687: and 1 = ( select count(*)
2688: from fnd_tns_alias_addresses c

Line 2688: from fnd_tns_alias_addresses c

2684: from fnd_tns_alias_addresses b,fnd_tns_listener_ports c
2685: where b.listener_port_guid = c.listener_port_guid
2686: and c.Listener_GUID = f_server.Listener_GUID )
2687: and 1 = ( select count(*)
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

Line 2716: delete from fnd_tns_alias_addresses b

2712: where not exists ( select 1
2713: from fnd_tns_alias_descriptions b
2714: where b.Tns_Alias_Guid = a.Tns_Alias_Guid );
2715:
2716: delete from fnd_tns_alias_addresses b
2717: where b.Listener_port_GUID
2718: in ( select c.listener_port_guid
2719: from fnd_tns_listener_ports c
2720: where c.Listener_GUID = f_server.Listener_GUID );

Line 2847: from fnd_tns_alias_addresses b,fnd_tns_listener_ports c

2843:
2844: delete from fnd_tns_alias_address_lists a
2845: where a.Tns_Alias_Address_List_Guid
2846: in ( select b.Tns_Alias_Address_List_Guid
2847: from fnd_tns_alias_addresses b,fnd_tns_listener_ports c
2848: where b.listener_port_guid = c.listener_port_guid
2849: and c.Listener_GUID = f_server.Listener_GUID )
2850: and 1 = ( select count(*)
2851: from fnd_tns_alias_addresses c

Line 2851: from fnd_tns_alias_addresses c

2847: from fnd_tns_alias_addresses b,fnd_tns_listener_ports c
2848: where b.listener_port_guid = c.listener_port_guid
2849: and c.Listener_GUID = f_server.Listener_GUID )
2850: and 1 = ( select count(*)
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

Line 2879: delete from fnd_tns_alias_addresses b

2875: where not exists ( select 1
2876: from fnd_tns_alias_descriptions b
2877: where b.Tns_Alias_Guid = a.Tns_Alias_Guid );
2878:
2879: delete from fnd_tns_alias_addresses b
2880: where b.Listener_port_GUID
2881: in ( select c.listener_port_guid
2882: from fnd_tns_listener_ports c
2883: where c.Listener_GUID = f_server.Listener_GUID );

Line 2975: delete from fnd_tns_alias_addresses a

2971: delete from fnd_tns_alias_address_lists a
2972: where a.Tns_Alias_Address_List_Guid =
2973: f_alias.Tns_Alias_Address_List_Guid;
2974:
2975: delete from fnd_tns_alias_addresses a
2976: where a.Tns_Alias_Address_List_Guid =
2977: f_alias.Tns_Alias_Address_List_Guid;
2978:
2979: end if;