Which table to use to get Employee Supplier Addresses in R12 (12.2.9, with Shared HR)
Hello All,
We recently realized there is a piece of custom code originally written for 11i version, that has not been retrofitted to the newer version for R12 (12.2.9 version with Shared HR). The code basically generates an extract listing all the active suppliers, supplier sites along with their addresses. To retrieve the addresses, the existing code looks at the addresses from supplier sites for both EMPLOYEE type suppliers and also for NON-EMPLOYEE type suppliers.
To achieve the same functionality, what R12 tables should be referred? Now that the Vendor sites doesn't store the addresses, what are the current R12 tables to get addresses. Both for EMPLOYEE type suppliers and for NON-EMPLOYEE type suppliers.