FUN_NAMES_BUSINESS_UNITS

Details

Schema: FUSION
Object owner: FUN
Object type: VIEW

Columns

Name
BU_ID BU_NAME LOCATION_ID LOCATION_NAME BUSINESS_GROUP_ID DATE_FROM DATE_TO MANAGER_ID MANAGER_NAME LEGAL_ENTITY_ID LEGAL_ENTITY_NAME PRIMARY_LEDGER_ID PRIMARY_LEDGER_NAME DEFAULT_SET_ID DEFAULT_SET_CODE DEFAULT_SET_NAME SHORT_CODE ENABLED_FOR_HR_FLAG FIN_BUSINESS_UNIT_ID FIN_BUSINESS_UNIT_NAME DEFAULT_CURRENCY_CODE PROFIT_CENTER_FLAG STATUS CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

BU_ID

BU_NAME

LOCATION_ID

LOCATION_NAME

BUSINESS_GROUP_ID

DATE_FROM

DATE_TO

MANAGER_ID

MANAGER_NAME

LEGAL_ENTITY_ID

LEGAL_ENTITY_NAME

PRIMARY_LEDGER_ID

PRIMARY_LEDGER_NAME

DEFAULT_SET_ID

DEFAULT_SET_CODE

DEFAULT_SET_NAME

SHORT_CODE

ENABLED_FOR_HR_FLAG

FIN_BUSINESS_UNIT_ID

FIN_BUSINESS_UNIT_NAME

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, LOC.DESCRIPTION LOCATION_NAME, ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORG.EFFECTIVE_START_DATE DATE_FROM, ORG.EFFECTIVE_END_DATE DATE_TO, INFO.ORG_INFORMATION1 MANAGER_ID, PERSON.LIST_NAME MANAGER_NAME, INFO.ORG_INFORMATION2 LEGAL_ENTITY_ID, XLE.NAME LEGAL_ENTITY_NAME, INFO.ORG_INFORMATION3 PRIMARY_LEDGER_ID, LEDGER.NAME PRIMARY_LEDGER_NAME, INFO.ORG_INFORMATION4 DEFAULT_SET_ID, SETID.SET_CODE DEFAULT_SET_CODE, SETID.SET_NAME DEFAULT_SET_NAME, INFO.ORG_INFORMATION5 SHORT_CODE, INFO.ORG_INFORMATION6 ENABLED_FOR_HR_FLAG, INFO.ORG_INFORMATION7 FIN_BUSINESS_UNIT_ID, FINBUORG.NAME FIN_BUSINESS_UNIT_NAME, 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 , HR_LOCATIONS_ALL_F_VL LOC , XLE_ENTITY_PROFILES XLE , GL_LEDGERS LEDGER , FND_SETID_SETS_VL SETID , PER_PERSON_NAMES_F_V PERSON , HR_ALL_ORGANIZATION_UNITS_F_VL FINBUORG 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 AND (INFO.ORG_INFORMATION2 = XLE.LEGAL_ENTITY_ID(+)) AND (INFO.ORG_INFORMATION3 = LEDGER.LEDGER_ID(+)) AND (INFO.ORG_INFORMATION4 = SETID.SET_ID(+)) AND ((ORG.LOCATION_ID = LOC.LOCATION_ID(+)) AND (TRUNC(SYSDATE) BETWEEN LOC.EFFECTIVE_START_DATE(+) AND LOC.EFFECTIVE_END_DATE(+))) AND (INFO.ORG_INFORMATION1 = PERSON.PERSON_ID(+) AND (TRUNC(SYSDATE) BETWEEN PERSON.EFFECTIVE_START_DATE(+) AND PERSON.EFFECTIVE_END_DATE(+))) AND (INFO.ORG_INFORMATION7 = FINBUORG.ORGANIZATION_ID(+) AND TRUNC(SYSDATE) BETWEEN FINBUORG.EFFECTIVE_START_DATE(+) AND FINBUORG.EFFECTIVE_END_DATE(+))

SQL_Statement

SELECT ORG.ORGANIZATION_ID BU_ID,

ORG.NAME BU_NAME,

ORG.LOCATION_ID LOCATION_ID,

LOC.DESCRIPTION LOCATION_NAME,

ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID,

ORG.EFFECTIVE_START_DATE DATE_FROM,

ORG.EFFECTIVE_END_DATE DATE_TO,

INFO.ORG_INFORMATION1 MANAGER_ID,

PERSON.LIST_NAME MANAGER_NAME,

INFO.ORG_INFORMATION2 LEGAL_ENTITY_ID,

XLE.NAME LEGAL_ENTITY_NAME,

INFO.ORG_INFORMATION3 PRIMARY_LEDGER_ID,

LEDGER.NAME PRIMARY_LEDGER_NAME,

INFO.ORG_INFORMATION4 DEFAULT_SET_ID,

SETID.SET_CODE DEFAULT_SET_CODE,

SETID.SET_NAME DEFAULT_SET_NAME,

INFO.ORG_INFORMATION5 SHORT_CODE,

INFO.ORG_INFORMATION6 ENABLED_FOR_HR_FLAG,

INFO.ORG_INFORMATION7 FIN_BUSINESS_UNIT_ID,

FINBUORG.NAME FIN_BUSINESS_UNIT_NAME,

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

, HR_LOCATIONS_ALL_F_VL LOC

, XLE_ENTITY_PROFILES XLE

, GL_LEDGERS LEDGER

, FND_SETID_SETS_VL SETID

, PER_PERSON_NAMES_F_V PERSON

, HR_ALL_ORGANIZATION_UNITS_F_VL FINBUORG

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

AND (INFO.ORG_INFORMATION2 = XLE.LEGAL_ENTITY_ID(+))

AND (INFO.ORG_INFORMATION3 = LEDGER.LEDGER_ID(+))

AND (INFO.ORG_INFORMATION4 = SETID.SET_ID(+))

AND ((ORG.LOCATION_ID = LOC.LOCATION_ID(+)) AND (TRUNC(SYSDATE) BETWEEN LOC.EFFECTIVE_START_DATE(+) AND LOC.EFFECTIVE_END_DATE(+)))

AND (INFO.ORG_INFORMATION1 = PERSON.PERSON_ID(+) AND (TRUNC(SYSDATE) BETWEEN PERSON.EFFECTIVE_START_DATE(+) AND PERSON.EFFECTIVE_END_DATE(+)))

AND (INFO.ORG_INFORMATION7 = FINBUORG.ORGANIZATION_ID(+) AND TRUNC(SYSDATE) BETWEEN FINBUORG.EFFECTIVE_START_DATE(+) AND FINBUORG.EFFECTIVE_END_DATE(+))