PER_ORGANIZATION_UNITS

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
ORGANIZATION_ID BUSINESS_GROUP_ID NAME DATE_FROM DATE_TO INTERNAL_ADDRESS_LINE ORG_INFORMATION1 ORG_INFORMATION2 ORG_INFORMATION3 ORG_INFORMATION4 INTERNAL_EXTERNAL_FLAG TYPE LOCATION_ID COST_ALLOCATION_KEYFLEX_ID

Query

SQL_Statement

SELECT O.ORGANIZATION_ID , O.BUSINESS_GROUP_ID , O.NAME , O.DATE_FROM , O.DATE_TO , O.INTERNAL_ADDRESS_LINE , O2.ORG_INFORMATION1 , O2.ORG_INFORMATION2 , O2.ORG_INFORMATION3 , O2.ORG_INFORMATION4 , O.INTERNAL_EXTERNAL_FLAG , O.TYPE , O.LOCATION_ID , O.COST_ALLOCATION_KEYFLEX_ID FROM HR_ORGANIZATION_UNITS O , HR_ORGANIZATION_INFORMATION O2 , HR_ORG_UNIT_CLASSIFICATIONS_F O3 WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID AND O2.ORG_INFORMATION_CONTEXT (+) || '' = 'PER_WORK_DAY_INFO' AND O3.CLASSIFICATION_CODE = 'DEPARTMENT' AND O3.STATUS = 'A'