Oracle Apps Business Structure Tables Flow. Oracle Apps Organization Information's Tables

Oracle Apps Business Structure Tables Flow. Oracle Apps Organization Information's Tables

 

HR_ORGANIZATION_INFORMATION  -- IT STORE OUR BUSINESS GROUP INFO, OPERATIN UNIT INFO ACCOUNTING INFO.

 

LIKE IF ANY COMPANY HAS 4 O.U THEN IT HAS 4 ROWS WHERE ORG_INFORMATION_CONTEXT='Operating Unit Information'

 

SAME APPLY TO BUSINESS GROUP.   

 

WE MOSTLY USE "Operating Unit Information"  ROWS IN THIS THERE IS A COLOUMN NAME "ORG_INFORMATION2"

 WHICH IS BASICALLY NULL FOR OTHER ROWS BUT IN "Operating Unit Information"  ROWS 

 IT HAS A PARICULAR ID WHICH AMDE HIS RELATIONSHIP WITH  "XLE_ENTITY_PROFILES" 

 WHERE THE O.U LEGA LINFO STORE  SO BASICALLY WE GO TO ANY OU LEGAL INFO BY HR_ORGANIZATION_INFORMATION

 

RELATION BETWEEN HR_ORGANIZATION_INFORMATION==XLE_ENTITY_PROFILES  IS  ORG_INFORMATION2  IN HR_ORGANIZATION_INFORMATION

AND LEGAL_ENTITY_ID IN  XLE_ENTITY_PROFILES

 

---------------------------------------------------------------------------------------------------------------------------

 

XLE_ENTITY_PROFILES  

 

THIS TABLE STORE OU LEGAL INFORMATION PLUS IT HAS A COLOUMN PARTY_ID WHICH RELATES WITH THE HZ_PARTIES

 

where we find the name of our Operating Unit

-----------------------------------------------------------------------------------------------------------------------------

hr_operating_units

 

This Table Store  all Operating Units Information.

 

if any company has 3 ou. Then it has 3 rows and 2nd thing   it has legal entity info

 

 

Each campany has one lagal entity 

 

campany menas Operating Unit  

 

and when we create legal entity thne system automatically creates the party_type with the name of this company in hz_aparties with type =''organization"

 

-----------------------------------------------------------------------------------------------------------------------------

ORG_ORGANIZATION_DEFINITIONS this table store my inventory org informaTION. LIKE IF ACOMPANY HAS 3 INV ORG IT HAS THREE ROWS AND ALSE IT DETERMINES THAT THIS INV ORG UNDER WHICH OPERTING UNIT (OU).IT ALSO STOEE  LEGAL ENTITY ID ,INVENTORY ORG_CODE.OK

 

----------------------------------------------------------------------------------------------------------------------------

 

 

HR_ALL_ORGANIZATION_UNITS 

 THIS TABLES STORES ALL ORGANIZATIONS INCLUDING OPERATING UNITS,BUISNESS GROUP,INV ORG,

 

WE CAN LINK WITH HR LOCAATION WITH THIS TABLE.

--------------------------------------------------------------------------------------------------------------------------------

 

HR_LOCATIONS        

This Table Store LOCATION informations , addreseses

 

 

 

---------------------------------------------------------------------------------------------

 

JAI_CMN_INVENTORY_ORGS 

This Table store inventory org with their locations  if any org has three locations then it has three rows for this Invnetory Org.

 

 

-----------------------------------------------------------------------------------------------------------------------------

 

 XLE_REGISTRATIONS

This Table stores operating unit legal informations  means  registration no  , tan no ,pan NO   

IT HAS COLOUMN SOURCE ID WHICH RELATES WIHT HR_OPERATING_UNIS  WITH LEGAL ID

 

 

 

 

 

 Oracle Apps Business Structure Tables Flow. Oracle Apps Organization Information's Tables