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.WSH_OTM_RIQ_XML dependencies on FND_TERRITORIES

Line 1777: FROM WSH_LOCATIONS wl, FND_TERRITORIES ft

1773: /*
1774: CURSOR c_get_loc_info(p_location_id IN NUMBER)
1775: IS
1776: SELECT wl.postal_code,wl.city,wl.state, ft.iso_territory_code
1777: FROM WSH_LOCATIONS wl, FND_TERRITORIES ft
1778: WHERE
1779: wl.wsh_location_id=p_location_id
1780: AND wl.country=ft.territory_code;
1781: */

Line 1785: FROM HZ_LOCATIONS hz,FND_TERRITORIES ft

1781: */
1782: CURSOR c_get_cus_loc_info(p_location_id IN NUMBER)
1783: IS
1784: SELECT hz.postal_code, hz.city,hz.state,ft.iso_territory_code
1785: FROM HZ_LOCATIONS hz,FND_TERRITORIES ft
1786: WHERE
1787: hz.location_id=p_location_id
1788: AND hz.country=ft.territory_code;
1789:

Line 1794: FROM HR_LOCATIONS_ALL hr,FND_TERRITORIES ft

1790:
1791: CURSOR c_get_org_loc_info(p_location_id IN NUMBER)
1792: IS
1793: SELECT hr.postal_code, hr.town_or_city,hr.region_2,ft.iso_territory_code
1794: FROM HR_LOCATIONS_ALL hr,FND_TERRITORIES ft
1795: WHERE
1796: hr.location_id=p_location_id
1797: AND hr.country=ft.territory_code;
1798: