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_LOCATIONS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 511: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL, hr_organization_units ou, mtl_parameters mp

507: WSH.LATITUDE,
508: WSH.LONGITUDE,
509: NVL(HR.TIMEZONE_CODE, WSH.TIMEZONE_CODE),
510: SYSDATE
511: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL, hr_organization_units ou, mtl_parameters mp
512: WHERE SOURCE_LOCATION_ID between p_from_location and p_to_location
513: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
514: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
515: AND hr.location_id = wsh.source_location_id

Line 618: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL, hr_organization_units ou, mtl_parameters mp

614: OU.NAME,
615: NULL,
616: NULL,
617: HR.TIMEZONE_CODE
618: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL, hr_organization_units ou, mtl_parameters mp
619: WHERE HR.LOCATION_ID between p_from_location and p_to_location
620: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
621: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
622: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl

Line 1971: FROM hr_organization_units ou, mtl_parameters mp

1967: -- TODO
1968: -- might not be tied to internal org
1969: CURSOR get_org_info(c_location_id IN NUMBER) IS
1970: SELECT ou.organization_id
1971: FROM hr_organization_units ou, mtl_parameters mp
1972: WHERE ou.organization_id = mp.organization_id
1973: AND ou.location_id = c_location_id;
1974:
1975: CURSOR check_party_carrier_supplier(l_party_id IN NUMBER) IS