Interested to Buy Any Domain ? << Click Here >> for more details...
which is the table for storing organization information?
- 9 Answers
- 42550 Views
- Infosys, Scan Steel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vamsi
All the below tables give you the organization information.
Its upto you to decide on which one to use... :)
1.mtl_parameters
2.oe_order_headers_all
3.HR_ALL_ORGANIZATION_UNITS
4.HR_ORGANIZATION_UNITS
5.HR_OPERATING_UNITS
6.org_organization_definitions
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / dilipkumar
oe_order_headers_all - Contains Sales order header information.
mtl_parameters - Contains inventory organization details and it's accounting information.
org_organization_definitions - View which derives translated organization name and organization structure details.
hr_organization_units - View which combines values of hr_all_organization_units table and he_all_organization_units_tl table.
hr_all_organization_units - Table that contains all the organization name and it's period details ( start date and end date ) and more details.
hr_operating_units - View which derives operating unit information from hr_all_organization_units tables and hr_organization_information table
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / gaurav kumar
add one more table in answer 6
I.e. hr_organization_information
| Is This Answer Correct ? | 1 Yes | 1 No |
can we get profile values in report without using user exists is it possible how?
What is multoorg and what is it's level or structure
HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?
what are the receipt types in Po?
what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference
in one report using two layout models.if yes how to do
What are the requests groups?
What is GLOBAL TEMPORARY TABLE and It's significance ?
Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen
Can we run a package with out specification?If yes how?
What are the different components you should consider while defining a responsibility in oracle apps?
Give a overview on Aol
Oracle Apps Technical 
