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 |
in ap_terms table what data will be stored
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
Give a brief overview on OrderManagement.
Can u define operating units inplace of inventory?
What are the Import Programs We need to run after creating Interface table for all modules
What is menu.
What is OM Cycle and What do u mean by Alternate Item
Registering parametric report?
How to create user and how u attach with responsibility.
what are the different transaction clauses in AR?
what are the functions you are used in utl_file at the time of transferring the data?
Explain oracle apps architecture.