which is the table for storing organization information?
- 9 Answers
- 39005 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 |
Can u define exceptions twice in same block?
What is Place holder Columns?
name at least five reports in oracle inventory related to transaction ?
HOW CAN U KNOW THE STAUS OF PO?
What is cursor?
what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .
Can you have two functions with the same name in a pl/sql block?
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.
How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?
How You Will display the key flexifields in your report
in which tables the transaction details stored? at least two.
how can u find the status in po?
Oracle Apps Technical 
