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

Line 129: hr_locations_all_tl hrtl,

125:
126: select decode(hrtl.description,null,'',hrtl.description)
127: into value
128: from
129: hr_locations_all_tl hrtl,
130: po_requisition_lines_all prl
131: where
132: hrtl.location_id = prl.deliver_to_location_id AND
133: prl.requisition_header_id = req_header_id AND

Line 142: hr_locations hrl,

138:
139: select hrl.location_id
140: into l_location_id
141: from
142: hr_locations hrl,
143: po_requisition_lines_all prl
144: where
145: hrl.location_id = prl.deliver_to_location_id AND
146: prl.requisition_header_id = req_header_id AND

Line 179: HR_LOCATIONS HLC,

175: l_region_2,
176: l_postal_code,
177: l_territory_short_name
178: FROM
179: HR_LOCATIONS HLC,
180: FND_TERRITORIES_TL FTE,
181: FND_LOOKUP_VALUES FCL1,
182: FND_LOOKUP_VALUES FCL2,
183: FND_LOOKUP_VALUES FCL3