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_ADDRESS_LISTS

Line 138: from fnd_tns_alias_address_lists a

134:
135: cursor c1(p_tns_description_guid raw) is
136: select a.Tns_Alias_Address_List_Guid,a.sequence_number,
137: a.failover,a.load_balance
138: from fnd_tns_alias_address_lists a
139: where a.Tns_Alias_Description_Guid = p_tns_description_guid
140: and a.sequence_number >= 0
141: order by a.sequence_number;
142:

Line 211: from fnd_tns_alias_address_lists b

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
213: = l_descRec.Tns_Alias_Description_Guid );
214:
215: delete from fnd_tns_alias_address_lists a

Line 215: delete from fnd_tns_alias_address_lists a

211: from fnd_tns_alias_address_lists b
212: where b.Tns_Alias_Description_Guid
213: = l_descRec.Tns_Alias_Description_Guid );
214:
215: delete from fnd_tns_alias_address_lists a
216: where a.Tns_Alias_Description_Guid
217: = l_descRec.Tns_Alias_Description_Guid ;
218:
219: fnd_app_system.register_tns_description

Line 302: from fnd_tns_alias_address_lists b

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
304: = l_descRec.Tns_Alias_Description_Guid );
305:
306: delete from fnd_tns_alias_address_lists a

Line 306: delete from fnd_tns_alias_address_lists a

302: from fnd_tns_alias_address_lists b
303: where b.Tns_Alias_Description_Guid
304: = l_descRec.Tns_Alias_Description_Guid );
305:
306: delete from fnd_tns_alias_address_lists a
307: where a.Tns_Alias_Description_Guid
308: = l_descRec.Tns_Alias_Description_Guid ;
309:
310: for f_addrlist in c1(l_sourceDesc.Tns_Alias_Description_Guid) loop

Line 364: from fnd_tns_alias_address_lists a

360: l_tns_alias_guid raw(16) := p_tns_alias_guid;
361:
362: cursor c1 (p_desc_guid raw)
363: is select a.Tns_Alias_Address_List_Guid,a.sequence_number
364: from fnd_tns_alias_address_lists a
365: where a.Tns_Alias_Description_Guid = p_desc_guid
366: and a.sequence_number >= 0
367: order by a.sequence_number;
368:

Line 592: from fnd_tns_alias_address_lists b

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
594: = f_unused.Tns_Alias_Description_Guid );
595:
596: delete from fnd_tns_alias_address_lists a

Line 596: delete from fnd_tns_alias_address_lists a

592: from fnd_tns_alias_address_lists b
593: where b.Tns_Alias_Description_Guid
594: = f_unused.Tns_Alias_Description_Guid );
595:
596: delete from fnd_tns_alias_address_lists a
597: where a.Tns_Alias_Description_Guid
598: = f_unused.Tns_Alias_Description_Guid ;
599: end if;
600:

Line 1400: from fnd_tns_alias_descriptions a, fnd_tns_alias_address_lists b,

1396: or a.alias_type = fnd_app_system.C_DB_INST_TNS_ALIAS_TYPE );
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

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 2681: delete from fnd_tns_alias_address_lists a

2677:
2678: if ( f_server.Listener_GUID is not null )
2679: then
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

Line 2704: from fnd_tns_alias_address_lists b

2700: -- server level.
2701:
2702: delete from fnd_tns_alias_descriptions a
2703: where not exists ( select 1
2704: from fnd_tns_alias_address_lists b
2705: where b.Tns_Alias_Description_Guid
2706: = a.Tns_Alias_Description_Guid )
2707: and a.sequence_number >= 0;
2708:

Line 2844: delete from fnd_tns_alias_address_lists a

2840:
2841: if ( f_server.Listener_GUID is not null )
2842: then
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

Line 2867: from fnd_tns_alias_address_lists b

2863: -- server level.
2864:
2865: delete from fnd_tns_alias_descriptions a
2866: where not exists ( select 1
2867: from fnd_tns_alias_address_lists b
2868: where b.Tns_Alias_Description_Guid
2869: = a.Tns_Alias_Description_Guid )
2870: and a.sequence_number >= 0;
2871:

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 2971: delete from fnd_tns_alias_address_lists a

2967:
2968: if ( f_alias.Tns_Alias_Address_List_Guid is not null )
2969: then
2970:
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