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 770: from fnd_tns_listener_ports a

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

Line 1094: from fnd_tns_listener_ports a

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

Line 1712: from fnd_tns_listener_ports a

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

Line 1896: from fnd_tns_listener_ports a

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

Line 2019: fnd_tns_listener_ports c, fnd_tns_listeners d

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
2023: and b.listener_port_guid = c.listener_port_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 2719: from fnd_tns_listener_ports c

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 );
2721:
2722: delete from fnd_tns_listener_ports a
2723: where a.Listener_GUID = f_server.Listener_GUID;

Line 2722: delete from fnd_tns_listener_ports a

2718: in ( select c.listener_port_guid
2719: from fnd_tns_listener_ports c
2720: where c.Listener_GUID = f_server.Listener_GUID );
2721:
2722: delete from fnd_tns_listener_ports a
2723: where a.Listener_GUID = f_server.Listener_GUID;
2724:
2725: delete from fnd_tns_listeners a
2726: where a.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 2882: from fnd_tns_listener_ports c

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 );
2884:
2885: delete from fnd_tns_listener_ports a
2886: where a.Listener_GUID = f_server.Listener_GUID;

Line 2885: delete from fnd_tns_listener_ports a

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