Multi Org Structure Table

Multi Org Structure Table

Name :Business Group

Table :HRFV_BUSINESS_GROUPS

Profile:HR:Business Group ID

Column: BUSINESS_GROUP_ID

Name :Set Of Books

Table :GL_SET_OF_BOOKS

Profile:GL: Set of books name

Column: Set_of_book_id

Name :Legal Entity

Table :HR_LEGAL_ENTITIES

Profile:

Column:

Name :Operating Unit

Table :HR_OPERATING_UNITS

Profile:MO:Operating Unit

Column:ORG_ID

Name:Inventroy Organization

Table:ORG_ORGANIZATION_DEFINITIONS

Profile:

Column:ORGANIZATION_ID

Name:Sub Inventory

Table:MTL_SECONDARY_INVENTORIES

Profile:

Column:

Name:Stock Locations

Table:MTL_ITEM_LOCATIONSQ

Profile:

Column:

Name:MTL_SYSTEM_ITEMS

Table:

Profile:

Column:Requisition,RFQ,Quotations,PO,PO Receipts

Business Group ID Tables

• PER_ALL_PEOPLE_F
• PER_JOBS
• PER_GRADES
• PER_POSITIONS

ORG ID Tables

• PO_REQUESITION_HEADERS_ALL
• PO_HEADERS_ALL
• PO_DISTRIBUTION_ALL

ORGANIZATION ID Tables

• MTL_SYSTEM_ITES_B
• WIP_ENTITITES
• BOM_RESOURCES
• BOM_DEPARTMENT

Note : PO_Vendors not having _ALL Table

But PO_vendor_sites_all having _ALL table