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.XNP_UTILS dependencies on XNP_NUMBER_RANGES

Line 124: FROM xnp_number_ranges nre

120:
121: CURSOR get_geo_area (subscription_tn IN VARCHAR2) IS
122: SELECT geo.code FROM xnp_geo_areas_b geo
123: WHERE geo.geo_area_id IN (SELECT nre.geo_area_id
124: FROM xnp_number_ranges nre
125: WHERE subscription_tn BETWEEN
126: starting_number AND ending_number );
127: CURSOR get_tn is
128: SELECT subscription_tn

Line 1719: FROM xnp_number_ranges

1715: --- 4. <--------------------------->
1716:
1717: CURSOR c_num_range_exists IS
1718: SELECT number_range_id
1719: FROM xnp_number_ranges
1720: WHERE
1721: -- Case 1
1722: ( (to_number(starting_number) >= to_number(p_starting_number))
1723: AND (to_number(starting_number) <= to_number(p_ending_number))