1275: IS
1276: SELECT
1277: hrl.country
1278: FROM
1279: HR_ALL_ORGANIZATION_UNITS hr
1280: , HR_LOCATIONS_ALL hrl
1281: WHERE hr.location_id = hrl.location_id
1282: AND hr.organization_id = p_warehouse_id;
1283:
1807: , p_customer_id => l_sold_to_org_id
1808: , p_operating_unit_id => l_so_ou_id);*/
1809: SELECT To_Number(NVL(O3.ORG_INFORMATION2,-1))
1810: INTO l_so_le_id
1811: FROM HR_ALL_ORGANIZATION_UNITS O
1812: , HR_ORGANIZATION_INFORMATION O2
1813: , HR_ORGANIZATION_INFORMATION O3
1814: WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
1815: AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID