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.INV_COPY_ORGANIZATION_REPORT dependencies on HR_LOCATIONS

Line 521: FROM hr_locations loc

517: IF (l_status = 'PRE_EXIST') THEN
518: BEGIN
519: SELECT loc.location_code, hou1.name, loc.location_id
520: INTO l_location_code, l_business_group_name, l_location_id
521: FROM hr_locations loc
522: , hr_all_organization_units hou
523: , hr_all_organization_units hou1
524: WHERE loc.location_id = hou.location_id
525: AND hou1.organization_id = hou.business_group_id

Line 543: FROM hr_locations loc

539: --
540: BEGIN
541: SELECT loc.location_code, hou1.name, loc.location_id
542: INTO l_location_code, l_business_group_name, l_location_id
543: FROM hr_locations loc
544: , hr_all_organization_units hou
545: , hr_all_organization_units hou1
546: WHERE loc.location_id = hou.location_id
547: AND hou1.organization_id = hou.business_group_id

Line 575: FROM hr_locations locs

571: IF (l_status = 'PRE_EXIST' AND l_model_loc_exists) THEN
572: BEGIN
573: SELECT creation_date
574: INTO l_creation_date
575: FROM hr_locations locs
576: WHERE locs.location_id = l_location_id;
577: EXCEPTION
578: WHEN OTHERS THEN
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;