Organization name table in oracle Fusion

Organization name table in oracle Fusion

In this post , We will be discuss about the Organization name table in oracle Fusion. I will try to share some of the important tables , which do store the Organization name information in oracle fusion. I will share the Business Organization table and Inventory Organization table in this post. Please find below the detail description about Organization name table in oracle Fusion.

Inventory Organization Name Table in oracle Fusion

1.HR_ALL_ORGANIZATION_UNITS_X

2.HR_ORG_UNIT_CLASSIFICATIONS_X

3. INV_ORG_PARAMETERS

4.FUN_ALL_BUSINESS_UNITS_V

5. GL_LEDGERS 

SQL Query to Extract Inventory Organization name table in oracle Fusion

SELECT HOU.ORGANIZATION_ID ORGANIZATION_ID,

HOU.NAME ORGANIZATION_NAME,

MP.ORGANIZATION_CODE ORGANIZATION_CODE,

LGR.LEDGER_ID SET_OF_BOOKS_ID,

LGR.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID,

LGR.CURRENCY_CODE,

LGR.PERIOD_SET_NAME,

DECODE(HOI1.STATUS, 'A', 'Y', 'N') INVENTORY_ENABLED_FLAG,

BU.BU_NAME BUSINESS_UNIT_NAME,

MP.BUSINESS_UNIT_ID BUSINESS_UNIT_ID,

MP.LEGAL_ENTITY_ID LEGAL_ENTITY,

HOU.TYPE ORGANIZATION_TYPE

FROM HR_ALL_ORGANIZATION_UNITS_X HOU,

HR_ORG_UNIT_CLASSIFICATIONS_X HOI1,

INV_ORG_PARAMETERS MP,

GL_LEDGERS LGR,

FUN_ALL_BUSINESS_UNITS_V BU

WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID

AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID

AND HOI1.CLASSIFICATION_CODE = 'INV'

AND BU.PRIMARY_LEDGER_ID = LGR.LEDGER_ID(+)

AND LGR.OBJECT_TYPE_CODE(+) = 'L'

AND NVL(LGR.COMPLETE_FLAG, 'Y') = 'Y'

AND BU.BU_ID(+) = MP.BUSINESS_UNIT_ID

Business Organization name 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 to extract Organization name 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