which is the table for storing organization information?
- 9 Answers
- 38973 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 ? | 22 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 |
What are different execution methods of executabls?
what is difference between d2k report and oracle apps report
10 Answers Seven Hills, Wipro,
what are the different transaction clauses in AR?
Where I can download D2K software?
do i need to declare bind parameter before using in the query?
How can u call a standard interface program from sql or pl/sql code?
Is it possible calling from one report to another? if possible means tell me ?
3 Answers Intelligroup, Satyam,
Stored procedure?
What multi org tables . example - difference between app table non all table . Po_header and po_headers_all
what is Flex mode and Confine mode?
What r the type Models in the system parameters of the report?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
Oracle Apps Technical 
