DBA Data[Home] [Help]

APPS.RCV_DISTRIBUTIONS_S dependencies on HR_LOCATIONS_ALL_TL

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 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