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_LOCATIONS_ALL

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 544: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL,

540: WSH.LATITUDE,
541: WSH.LONGITUDE,
542: NVL(HR.TIMEZONE_CODE, WSH.TIMEZONE_CODE),
543: SYSDATE
544: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL,
545: PO_LOCATION_ASSOCIATIONS_ALL PLA
546: WHERE SOURCE_LOCATION_ID between p_from_location and p_to_location
547: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
548: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)

Line 580: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL

576: WSH.LATITUDE,
577: WSH.LONGITUDE,
578: NVL(HR.TIMEZONE_CODE, WSH.TIMEZONE_CODE),
579: SYSDATE
580: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL
581: WHERE SOURCE_LOCATION_ID between p_from_location and p_to_location
582: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
583: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
584: 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 651: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL,

647: 'XXX' NAME,
648: NULL,
649: NULL,
650: HR.TIMEZONE_CODE
651: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL,
652: PO_LOCATION_ASSOCIATIONS_ALL PLA
653: WHERE HR.LOCATION_ID between p_from_location and p_to_location
654: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
655: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)

Line 687: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL

683: 'XXX' NAME,
684: NULL,
685: NULL,
686: HR.TIMEZONE_CODE
687: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL
688: WHERE HR.LOCATION_ID between p_from_location and p_to_location
689: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
690: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
691: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl

Line 723: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL

719: 'XXX' NAME,
720: NULL,
721: NULL,
722: HR.TIMEZONE_CODE
723: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL
724: WHERE HR.LOCATION_ID between p_from_location and p_to_location
725: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
726: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
727: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl