Search Results tax_reporting_site_flag




Overview
Explore in AI Chat

Overview

The view APPS.ICX_PO_VENDOR_SITES_V is a reporting and integration layer over the supplier site records maintained in Oracle Purchasing. In Oracle E-Business Suite 12.1.1 and 12.2.2 it exposes the columns of the base table PO_VENDOR_SITES through a simple, single-object projection, allowing Oracle iSupplier Portal (ICX) and related modules to present vendor site information without querying the base table directly. Because the definition is a straight SELECT without joins, filters, or aggregations, the view preserves the full structure and volume of the underlying supplier site data, including the operating unit context carried by ORG_ID.

From a reporting and integration perspective, the view functions as a stable, read-only interface to supplier site attributes such as address, payment, purchasing, tax, and withholding configuration. External systems, concurrent programs, and custom reports commonly reference this view rather than the base table to reduce coupling to internal column ordering.

Underlying Base Objects

The view is defined over a single documented base object, the table PO_VENDOR_SITES. No joins, synonyms, or additional referenced objects are documented in the ETRM metadata. Each row in the view corresponds one-to-one with a row in PO_VENDOR_SITES, and the view inherits the multi-org partitioning of that table: supplier site records are segmented by ORG_ID, so queries typically require an operating unit context to return the correct data set.

Key Columns

Common Use Cases and Queries

The view is frequently queried to identify tax reporting sites, list active payment sites, or feed supplier data into downstream systems. A representative query to locate tax reporting sites is:

  • SELECT vendor_site_id, vendor_id, vendor_site_code, tax_reporting_site_flag FROM apps.icx_po_vendor_sites_v WHERE tax_reporting_site_flag = 'Y' AND inactive_date IS NULL;
  • Listing active payment sites: filter on pay_site_flag = 'Y' and inactive_date IS NULL.
  • Supplier 1099/tax reporting extracts joining vendor_site_id to payables invoice distributions.
  • iSupplier Portal display queries retrieving site address and payment defaults for a given vendor_id.

Because the view applies no filtering, all business restrictions—operating unit, active status, and site usage flags—must be applied explicitly in the query.