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_LISTENER_PORTS

Line 768: from fnd_tns_listener_ports a

764: and a.remote_listener_alias is not null;
765:
766: cursor c3(p_listener_guid raw)
767: is select a.listener_port_guid,a.port
768: from fnd_tns_listener_ports a
769: where a.listener_guid = p_listener_guid;
770:
771: -- Cursor c4 was originally designed just to fetch unresolved descriptors
772: -- (seq_no < 0 ). But because we clone alt descriptors we need to rebuild

Line 1092: from fnd_tns_listener_ports a

1088: );
1089:
1090: select a.listener_port_guid
1091: into l_listener_port_guid
1092: from fnd_tns_listener_ports a
1093: where a.listener_guid= l_Listener_GUID
1094: and a.port = ListenerPort;
1095:
1096: -- Register local listener TNS alias

Line 1710: from fnd_tns_listener_ports a

1706: ) ;
1707:
1708: cursor c3(p_listener_guid raw)
1709: is select a.listener_port_guid,a.port
1710: from fnd_tns_listener_ports a
1711: where a.listener_guid = p_listener_guid;
1712:
1713: begin
1714:

Line 1894: from fnd_tns_listener_ports a

1890: );
1891:
1892: select a.listener_port_guid
1893: into l_listener_port_guid
1894: from fnd_tns_listener_ports a
1895: where a.listener_guid= l_Listener_GUID
1896: and a.port = to_number(RPCPort);
1897:
1898: -- Create FNDFS/SM aliases

Line 2017: fnd_tns_listener_ports c, fnd_tns_listeners d

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

Line 2682: from fnd_tns_alias_addresses b,fnd_tns_listener_ports c

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

Line 2717: from fnd_tns_listener_ports c

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

Line 2720: delete from fnd_tns_listener_ports a

2716: in ( select c.listener_port_guid
2717: from fnd_tns_listener_ports c
2718: where c.Listener_GUID = f_server.Listener_GUID );
2719:
2720: delete from fnd_tns_listener_ports a
2721: where a.Listener_GUID = f_server.Listener_GUID;
2722:
2723: delete from fnd_tns_listeners a
2724: where a.Listener_GUID = f_server.Listener_GUID;

Line 2845: from fnd_tns_alias_addresses b,fnd_tns_listener_ports c

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

Line 2880: from fnd_tns_listener_ports c

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

Line 2883: delete from fnd_tns_listener_ports a

2879: in ( select c.listener_port_guid
2880: from fnd_tns_listener_ports c
2881: where c.Listener_GUID = f_server.Listener_GUID );
2882:
2883: delete from fnd_tns_listener_ports a
2884: where a.Listener_GUID = f_server.Listener_GUID;
2885:
2886: delete from fnd_tns_listeners a
2887: where a.Listener_GUID = f_server.Listener_GUID;