1. Tables and Views for Financials
  2. FUN_BU_PERF_V

FUN_BU_PERF_V

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: VIEW

Columns

Name

BU_ID

BU_NAME

BUSINESS_GROUP_ID

DATE_FROM

DATE_TO

STATUS

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT ORG.ORGANIZATION_ID BU_ID,

ORG.NAME BU_NAME,

ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID,

ORG.EFFECTIVE_START_DATE DATE_FROM,

ORG.EFFECTIVE_END_DATE DATE_TO,

CLS.STATUS STATUS,

ORG.CREATED_BY CREATED_BY,

ORG.CREATION_DATE CREATION_DATE,

ORG.LAST_UPDATED_BY LAST_UPDATED_BY,

ORG.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ORG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM HR_ORGANIZATION_UNITS_F_TL ORG

,HR_ORG_UNIT_CLASSIFICATIONS_F CLS

WHERE ORG.LANGUAGE = USERENV('LANG')

AND TRUNC(SYSDATE) BETWEEN ORG.EFFECTIVE_START_DATE AND

ORG.EFFECTIVE_END_DATE

AND ORG.ORGANIZATION_ID = CLS.ORGANIZATION_ID

AND CLS.CLASSIFICATION_CODE = 'FUN_BUSINESS_UNIT'

AND TRUNC(SYSDATE) BETWEEN CLS.EFFECTIVE_START_DATE AND

CLS.EFFECTIVE_END_DATE