Location data present in HR_LOCATIONS_ALL table does not have a reference/corresponding Organization
Summary:
Location data present in HR_LOCATIONS_ALL table does not have a reference/corresponding Organization detail in HR_ALL_ORGANIZATION_UNITS
We need the detail of the table which will hold organization detail for all locations present in HR_LOCATIONS_ALL
SELECT hla.location_code Location,
hla.ADDRESS_LINE_1 ADDRESS_1,
hla.ADDRESS_LINE_2 ADDRESS_2,
hla.ADDRESS_LINE_3 ADDRESS_3,
hla.ADDRESS_LINE_4 ADDRESS_4,
hla.TOWN_OR_CITY City,
hla.REGION_2 STATE,
hla.COUNTRY,
hla.POSTAL_CODE,
NULL country_code,
NULL state_code,
NULL phone,
hla.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID,
NULL COA_LOCATION,
hou.Organization_id ship_to_org_id,
Tagged:
0