VIEW: APPS.HR_SG_LEG_ENT_V

Source

View Text - Preformatted

SELECT hou.organization_id, hou.business_group_id + 0 business_group_id, hou.name, hou.date_from, hou.date_to, hou.type, hou.internal_address_line, hou.comments, hou.location_id, hoi1.org_information1, hoi1.org_information4, hoi1.org_information15, hlo.address_line_1, hlo.address_line_2, hlo.address_line_3, hlo.town_or_city, hlo.postal_code, hlo.country from hr_all_organization_units hou, hr_organization_information hoi1, hr_organization_information hoi2, hr_locations hlo WHERE hou.organization_id = hoi1.organization_id(+) and hou.organization_id = hoi2.organization_id and hoi1.org_information_context||'' = 'SG_LEGAL_ENTITY' and hoi2.org_information_context||'' = 'CLASS' and hoi2.org_information1 = 'HR_LEGAL' and hoi2.org_information2 = 'Y' and hlo.location_id (+) = hou.location_id

View Text - HTML Formatted

SELECT HOU.ORGANIZATION_ID
, HOU.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, HOU.NAME
, HOU.DATE_FROM
, HOU.DATE_TO
, HOU.TYPE
, HOU.INTERNAL_ADDRESS_LINE
, HOU.COMMENTS
, HOU.LOCATION_ID
, HOI1.ORG_INFORMATION1
, HOI1.ORG_INFORMATION4
, HOI1.ORG_INFORMATION15
, HLO.ADDRESS_LINE_1
, HLO.ADDRESS_LINE_2
, HLO.ADDRESS_LINE_3
, HLO.TOWN_OR_CITY
, HLO.POSTAL_CODE
, HLO.COUNTRY
FROM HR_ALL_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION HOI1
, HR_ORGANIZATION_INFORMATION HOI2
, HR_LOCATIONS HLO
WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID(+)
AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION_CONTEXT||'' = 'SG_LEGAL_ENTITY'
AND HOI2.ORG_INFORMATION_CONTEXT||'' = 'CLASS'
AND HOI2.ORG_INFORMATION1 = 'HR_LEGAL'
AND HOI2.ORG_INFORMATION2 = 'Y'
AND HLO.LOCATION_ID (+) = HOU.LOCATION_ID