PJC_ALL_ORGANIZATION_UNITS_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
BU_ID BUSINESS_GROUP_ID ORGANIZATION_CODE

Query

SQL_Statement
SELECT organization_id bu_id, business_group_id business_group_id, organization_code organization_code FROM hr_all_organization_units_f WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE