DBA Data[Home] [Help]

APPS.RCV_ROI_RETURN dependencies on HR_LOCATIONS

Line 225: FROM hr_locations hl,

221:
222: IF (x_cascaded_table(n).ship_to_location_code IS NOT NULL) THEN
223: SELECT max(mp.organization_code)
224: INTO x_to_organization_code
225: FROM hr_locations hl,
226: mtl_parameters mp
227: WHERE x_cascaded_table(n).ship_to_location_code = hl.location_code
228: AND hl.inventory_organization_id = mp.organization_id;
229: