which is the table for storing organization information?
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 |
While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?
what is pick selection list generation report.
what is the difference between procedure and function
What is FORWARD DECLARATION in Packages?
6 Answers British Telecom BT, HCL, Tech Mahindra,
What is the difference between buyer&employee in PO module?
what is the use of placeholer column?
What is SET-OF-BOOKS?
what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions
how can u link a org-id with a responsibility in reports?
in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?
Which is the best website to learn Oracle Apps?
why r u transer the data base tables to flat file and what is use