Friday, October 02, 2015

Payables Table: AP_SUPPLIER_SITES_ALL


This is a simple table. I saved this query to remind myself that phone, fax and email entered on Supplier Address region are stored in hz_contact_points table but phone, fax, telex entered on Site communication region are stored in site table itself. since vendor site is associated with a party site and there is no way to differenciate phone attached to party site and vendor site, Oracle saves Vendor site level phone, fax in site record itself and does not use TCA architecture. May be Oracle should use "AP_SUPPLIER_SITES_ALL" too for hz_contact_points.owner_table_name

No comments:

Post a Comment