How to get Organization Name for an Invoice
Can someone please explain how the following tables can be related ?
AP_INVOICES_ALL
HR_ORGANIZATION_UNITS
HR_OPERATION_UNITS
AP_INVOICES_ALL -- This table has columns legal_entity_id, ORG_ID and EXPENDITURE_ORGANIZATION_ID.
Do any of these columns relate to tables HR_ORGANIZATION_UNITS and HR_OPERATION_UNITS ?
I am trying to get the organization name for a particular invoice. So, which would be the right column and which would be the related table.
Thanks
Leonard