Search Results purchasing_site_flag




Overview
Explore in AI Chat

Overview

PO_VENDOR_SITES_ALL is a view in the APPS schema within Oracle E-Business Suite, belonging to the Payables (AP) product family. It presents supplier site information sourced primarily from AP_SUPPLIER_SITES_ALL, joined to supporting objects that resolve address, party, and lookup details. Functionally, the view exposes a supplier-site-centric record set that spans procurement and payables attributes, including purchasing controls, pay site eligibility, invoice and payment defaults, and address formatting data. Because it consolidates columns used by both Purchasing and Payables, it is heavily referenced in reporting, interfaces, and integration code that needs a single queryable source for vendor site data. The view remains VALID and documented across 12.1.1 and 12.2.2, with referenced base objects confirmed under the 12.2.2 ETRM metadata.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects: AP_LOOKUP_CODES (VIEW), AP_SUPPLIER_SITES_ALL (SYNONYM), FND_GLOBAL (PACKAGE), HZ_LOCATIONS (SYNONYM), and HZ_PARTY_SITES (SYNONYM). The principal data source is AP_SUPPLIER_SITES_ALL, which supplies the site-level columns such as VENDOR_SITE_ID, VENDOR_ID, VENDOR_SITE_CODE, PAY_SITE_FLAG, PURCHASING_SITE_FLAG, and the payment and invoice defaults. HZ_PARTY_SITES and HZ_LOCATIONS provide the Trading Community Architecture (TCA) address and party-site details that the modern data model uses in place of legacy address storage. AP_LOOKUP_CODES resolves lookup meanings for coded columns. FND_GLOBAL supplies runtime session context used within the view definition. The view effectively acts as a denormalized projection over the TCA supplier site model.

Key Columns

The view exposes a broad column set. Identifying columns include VENDOR_SITE_ID, VENDOR_ID, VENDOR_SITE_CODE, and VENDOR_SITE_CODE_ALT. Operational flags include PURCHASING_SITE_FLAG, RFQ_ONLY_SITE_FLAG, PAY_SITE_FLAG, HOLD_ALL_PAYMENTS_FLAG, and ATTENTION_AR_FLAG. Payment and invoice defaults include TERMS_ID, PAY_GROUP_LOOKUP_CODE, PAYMENT_PRIORITY, INVOICE_AMOUNT_LIMIT, INVOICE_CURRENCY_CODE, PAYMENT_CURRENCY_CODE, ACCTS_PAY_CODE_COMBINATION_ID, and PREPAY_CODE_COMBINATION_ID. Address and contact columns include ADDRESS_LINE1 through ADDRESS_LINE3, ADDRESS_LINES_ALT, CITY, STATE, ZIP, COUNTY, PROVINCE, COUNTRY, PHONE, FAX, and TELEX, along with SHIP_TO_LOCATION_ID and BILL_TO_LOCATION_ID. Standard audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN are also present.

Common Use Cases and Queries

Typical uses include supplier site validation during invoice import, identifying pay sites for payment processing, and reporting on active purchasing sites. A common query filters on the pay site flag. When searching for pcard_site_flag, note that this column is not enumerated in the documented view text or metadata excerpt provided; PCard site eligibility is generally held on the supplier site record, so the corresponding attribute should be verified against AP_SUPPLIER_SITES_ALL if it is not exposed by this view in a given release.

  • List active pay sites: SELECT vendor_site_id, vendor_site_code FROM po_vendor_sites_all WHERE pay_site_flag = 'Y' AND inactive_date IS NULL;
  • Retrieve site address: SELECT vendor_site_code, address_line1, city, state, zip FROM po_vendor_sites_all WHERE vendor_id = :p_vendor_id;
  • Report payment defaults: SELECT vendor_site_code, terms_id, pay_group_lookup_code, payment_priority FROM po_vendor_sites_all WHERE pay_site_flag = 'Y';