VIEW: APPS.HR_USORG_BASE_V

Source

View Text - Preformatted

SELECT distinct hou.organization_id, hou.name org_name, hlc.meaning type, hl.description location, hl.town_or_city, hl.region_2 state, hl.country, hou.business_group_id, hou.date_from, hou.date_to from hr_organization_units hou, hr_locations hl, hr_organization_information hoi, hr_lookups hlc WHERE hou.organization_id=hoi.organization_id and hoi.org_information_context||''='CLASS' and hoi.org_information1 ='HR_ORG' and hoi.org_information2='Y' and hou.internal_external_flag = 'INT' and hou.location_id=hl.location_id(+) and hou.type =hlc.lookup_code (+) and hlc.lookup_type (+) ='ORG_TYPE' and hlc.enabled_flag(+)='Y'

View Text - HTML Formatted

SELECT DISTINCT HOU.ORGANIZATION_ID
, HOU.NAME ORG_NAME
, HLC.MEANING TYPE
, HL.DESCRIPTION LOCATION
, HL.TOWN_OR_CITY
, HL.REGION_2 STATE
, HL.COUNTRY
, HOU.BUSINESS_GROUP_ID
, HOU.DATE_FROM
, HOU.DATE_TO
FROM HR_ORGANIZATION_UNITS HOU
, HR_LOCATIONS HL
, HR_ORGANIZATION_INFORMATION HOI
, HR_LOOKUPS HLC
WHERE HOU.ORGANIZATION_ID=HOI.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT||''='CLASS'
AND HOI.ORG_INFORMATION1 ='HR_ORG'
AND HOI.ORG_INFORMATION2='Y'
AND HOU.INTERNAL_EXTERNAL_FLAG = 'INT'
AND HOU.LOCATION_ID=HL.LOCATION_ID(+)
AND HOU.TYPE =HLC.LOOKUP_CODE (+)
AND HLC.LOOKUP_TYPE (+) ='ORG_TYPE'
AND HLC.ENABLED_FLAG(+)='Y'