PER_BUSINESS_GROUPS_PERF

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
BUSINESS_GROUP_ID NAME EFFECTIVE_START_DATE EFFECTIVE_END_DATE INTERNAL_ADDRESS_LINE LOCATION_ID ORG_INFORMATION1 ORG_INFORMATION2 ORG_INFORMATION3 ORG_INFORMATION16 ORG_INFORMATION4 ORG_INFORMATION5 ORG_INFORMATION6 ORG_INFORMATION7 ORG_INFORMATION8 ORG_INFORMATION9 ORG_INFORMATION10 STATUS ORG_INFORMATION15 ORG_INFORMATION14

Query

SQL_Statement

SELECT o.ORGANIZATION_ID BUSINESS_GROUP_ID, otl.NAME, o.EFFECTIVE_START_DATE, o.EFFECTIVE_END_DATE, o.INTERNAL_ADDRESS_LINE, o.LOCATION_ID, o2.ORG_INFORMATION1, o2.ORG_INFORMATION2, o2.ORG_INFORMATION3, o2.ORG_INFORMATION16, o2.ORG_INFORMATION4, o2.ORG_INFORMATION5, o2.ORG_INFORMATION6, o2.ORG_INFORMATION7, o2.ORG_INFORMATION8, o2.ORG_INFORMATION9, o2.ORG_INFORMATION10, o4.STATUS STATUS, o2.ORG_INFORMATION15, o2.ORG_INFORMATION14 FROM HR_ALL_ORGANIZATION_UNITS_F o, HR_ORGANIZATION_UNITS_F_TL otl, HR_ORGANIZATION_INFORMATION_F o2, HR_ORG_UNIT_CLASSIFICATIONS_F o4 WHERE o.ORGANIZATION_ID = otl.ORGANIZATION_ID AND o.ORGANIZATION_ID = o2.ORGANIZATION_ID AND o.ORGANIZATION_ID = o4.ORGANIZATION_ID AND o2.ORG_INFORMATION_CONTEXT = 'Enterprise Information' AND o4.CLASSIFICATION_CODE = 'ENTERPRISE' AND o4.STATUS = 'A' AND o.EFFECTIVE_START_DATE = o4.EFFECTIVE_START_DATE AND o.EFFECTIVE_END_DATE = o4.EFFECTIVE_END_DATE AND otl.LANGUAGE = USERENV('lang')