Oracle Fusion inventory organization table

Oracle Fusion inventory organization table

In this post , we will discuss about the Oracle Fusion inventory organization table. Inventory Organization table helps to store the Inventory Orgs information in oracle fusion. We do get the different Inventory Organization parameters information and other Accounting related informations for these oracle fusion inventory organization tables. I will try to share some of the most important oracle fusion inventory organization table with some important sql queries to extract the Inventory organization information. 

5 Most Important Oracle Fusion inventory organization table

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 informations using oracle Fusion inventory organization table

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