Business unit table in oracle fusion

Business unit table in oracle fusion

In this post , We will discuss about Business unit table in oracle fusion. Business unit tables stores all the information about BU's created in the Oracle fusion applications. All the Fusions BU's information's stores in these Business unit table in oracle fusion. Here below I will be list of all the Business unit table in oracle fusion and the sql query using these Business Unit table.

3 Important Business unit table in oracle fusion

1. HR_ALL_ORGANIZATION_UNITS_F

2.HR_ORGANIZATION_UNITS_F_TL

3.HR_ORGANIZATION_INFORMATION_F

4.HR_ORG_UNIT_CLASSIFICATIONS_F

 

 

SQL Query Using Business unit table in oracle fusion

 

 

select hao.organization_id as bu_id,haot.name,hao.business_group_id
FROM
HR_ALL_ORGANIZATION_UNITS_F hao,
HR_ORGANIZATION_UNITS_F_TL haot
WHERE
hao.ORGANIZATION_ID = haot.ORGANIZATION_ID
AND hao.EFFECTIVE_START_DATE = haot.EFFECTIVE_START_DATE
AND hao.EFFECTIVE_END_DATE = haot.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN hao.EFFECTIVE_START_DATE AND hao.EFFECTIVE_END_DATE
AND haot.LANGUAGE='US'
AND haot.name = :P_BU_NAME