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 |
what is inbound and outbound interface?
how can we return morethan one parameters in procedure?
what is meant by boilerplates?
What is request group
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
hi all.i am in need of some sample codes for oracle apps manufacturing interfaces.If any of u have,plz send it to me . Thank you.
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
while running a interface if we get 100 records as erors. how to debug it.
what are the prerequisite set ups for inter organization transaction?
I want to print output in portrait style?where i have to change the settings?
When you run he report you have to get only that particular organization po numbers or item number how can do it?
what is trace file? what is the use of that?