I recently had to stage the details that is displayed when you update an Supplier Address’s detail, and had a hard time finding the table structure that is used to store the information of the “Address Purpose” check boxes.
Since they don’t use Java Forms anymore in r12, we cannot use the diagnostic menu to get this information. So I had to run a lot of time consuming scripts to detect the tables that store this information. So to spare anyone else’s time that is tasked with this requirement here is the answer…
Address Purpose for Supplier Sites
You can also configure this same 3 checkbox options under each site of the supplier. I had no hard time in finding them.
They were simple “_FLAG” fields in the AP_SUPPLIER_SITES_ALL table, named:
- RFQ_ONLY_SITE_FLAG and
This is logical and easy enough. But the same cannot be said for the Address Level values…
Address Purpose for Supplier Addresses
For each Address entry in the “Address Book” you can set the “Address Purpose”. I don’t know exactly what they are used for, but you can override all the current sites under this address with this detail.
Oracle thought it would be nice to make this simple 3 flags a lot more complicated. So they saved the 3 values in side the HZ_PARTY_SITE_USES table. Each checkbox has it’s own entry in this table. You differentiate between each checkbox entry by filtering on the SITE_USE_TYPE field with the 3 values:
- ‘PURCHASING’ for “Purchasing”,
- ‘PAY’ for “Payment” and
- ‘RFQ’ for “RFQ Only”.
And the table has a field called: STATUS that depict a “A” for active (checked) and a “I” for inactive (unchecked).
I hope this information can help someone out!