APPS.RCV_DISTRIBUTIONS_S dependencies on HR_LOCATIONS_ALL

Line 148: hr_locations_all_tl and the condition hl.language(+) = USERENV('LANG')

144:
145: X_progress := '020';
146:
147: /* Bug# 1808822 - HR_LOCATIONS view is non-mergable so it is replaced by
148: hr_locations_all_tl and the condition hl.language(+) = USERENV('LANG')
149: is added. Since only location_code is selected, there is no need of
150: joining with the tables hr_locations_all and hz_locations. */
151:
152: SELECT pod.po_distribution_id,

Line 150: joining with the tables hr_locations_all and hz_locations. */

146:
147: /* Bug# 1808822 - HR_LOCATIONS view is non-mergable so it is replaced by
148: hr_locations_all_tl and the condition hl.language(+) = USERENV('LANG')
149: is added. Since only location_code is selected, there is no need of
150: joining with the tables hr_locations_all and hz_locations. */
151:
152: SELECT pod.po_distribution_id,
153: pod.destination_type_code,
154: pod.deliver_to_location_id,

Line 191: hr_locations_all_tl hl,

187: x_project_id, -- Bug 4684017 The variable should be x_project_id and not x_project_number
188: x_task_id, -- Bug 4684017 The variable should be x_project_id and not x_project_number
189: l_code_combination_id --
190: FROM po_distributions pod,
191: hr_locations_all_tl hl,
192: mtl_kanban_cards mkc --
193: WHERE pod.line_location_id = X_line_location_id
194: AND pod.po_distribution_id = Nvl(X_PO_DISTRIBUTIONS_ID,pod.po_distribution_id) -- bug 9742420
195: AND hl.location_id(+) = pod.deliver_to_location_id

Line 409: X_deliver_to_location hr_locations_all.location_code%TYPE;

405:
406: /** PO UTF8 Column Expansion Project 9/23/2002 tpoon **/
407: /** Changed X_deliver_to_location to use %TYPE **/
408: -- X_deliver_to_location VARCHAR2(30);
409: X_deliver_to_location hr_locations_all.location_code%TYPE;
410:
411: X_deliver_to_person_id NUMBER;
412: X_deliver_to_person VARCHAR2(30);
413: X_deliver_to_sub VARCHAR2(30);