APPS.RCV_DISTRIBUTIONS_S dependencies on HR_LOCATIONS_ALL

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

94:
95: X_progress := '020';
96:
97: /* Bug# 1808822 - HR_LOCATIONS view is non-mergable so it is replaced by
98: hr_locations_all_tl and the condition hl.language(+) = USERENV('LANG')
99: is added. Since only location_code is selected, there is no need of
100: joining with the tables hr_locations_all and hz_locations. */
101:
102: SELECT pod.po_distribution_id,

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

96:
97: /* Bug# 1808822 - HR_LOCATIONS view is non-mergable so it is replaced by
98: hr_locations_all_tl and the condition hl.language(+) = USERENV('LANG')
99: is added. Since only location_code is selected, there is no need of
100: joining with the tables hr_locations_all and hz_locations. */
101:
102: SELECT pod.po_distribution_id,
103: pod.destination_type_code,
104: pod.deliver_to_location_id,

Line 141: hr_locations_all_tl hl,

137: x_project_id, -- Bug 4684017 The variable should be x_project_id and not x_project_number
138: x_task_id, -- Bug 4684017 The variable should be x_project_id and not x_project_number
139: l_code_combination_id --
140: FROM po_distributions pod,
141: hr_locations_all_tl hl,
142: mtl_kanban_cards mkc --
143: WHERE pod.line_location_id = X_line_location_id
144: AND hl.location_id(+) = pod.deliver_to_location_id
145: AND hl.language(+) = USERENV('LANG')

Line 358: X_deliver_to_location hr_locations_all.location_code%TYPE;

354:
355: /** PO UTF8 Column Expansion Project 9/23/2002 tpoon **/
356: /** Changed X_deliver_to_location to use %TYPE **/
357: -- X_deliver_to_location VARCHAR2(30);
358: X_deliver_to_location hr_locations_all.location_code%TYPE;
359:
360: X_deliver_to_person_id NUMBER;
361: X_deliver_to_person VARCHAR2(30);
362: X_deliver_to_sub VARCHAR2(30);