FUN_ALL_BUSINESS_UNITS_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
BU_ID BU_NAME LOCATION_ID BUSINESS_GROUP_ID DATE_FROM DATE_TO MANAGER_ID LEGAL_ENTITY_ID PRIMARY_LEDGER_ID DEFAULT_SET_ID SHORT_CODE ENABLED_FOR_HR_FLAG FIN_BUSINESS_UNIT_ID DEFAULT_CURRENCY_CODE PROFIT_CENTER_FLAG 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.LOCATION_ID LOCATION_ID, ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORG.EFFECTIVE_START_DATE DATE_FROM, ORG.EFFECTIVE_END_DATE DATE_TO, INFO.ORG_INFORMATION1 MANAGER_ID, INFO.ORG_INFORMATION2 LEGAL_ENTITY_ID, INFO.ORG_INFORMATION3 PRIMARY_LEDGER_ID, INFO.ORG_INFORMATION4 DEFAULT_SET_ID, ORG.NAME SHORT_CODE, INFO.ORG_INFORMATION6 ENABLED_FOR_HR_FLAG, INFO.ORG_INFORMATION7 FIN_BUSINESS_UNIT_ID, INFO.ORG_INFORMATION8 DEFAULT_CURRENCY_CODE, INFO.ORG_INFORMATION9 PROFIT_CENTER_FLAG, 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_ALL_ORGANIZATION_UNITS_F_VL ORG , HR_ORG_UNIT_CLASSIFICATIONS_X CLS , HR_ORGANIZATION_INFORMATION_X INFO WHERE CLS.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND CLS.CLASSIFICATION_CODE = 'FUN_BUSINESS_UNIT' AND INFO.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND INFO.ORG_INFORMATION_CONTEXT = CLS.CLASSIFICATION_CODE AND TRUNC(SYSDATE) BETWEEN ORG.EFFECTIVE_START_DATE AND ORG.EFFECTIVE_END_DATE