Search Results num_active_pay_sites

Overview

APPS.PO_VENDORS_AP_V is an Oracle E-Business Suite reporting and integration view that consolidates supplier (vendor) header information alongside pay-site level attributes, party details, and operating-unit context. It is documented in ETRM for both release 12.1.1 and 12.2.2 and is owned by the APPS schema. The view is primarily consumed by Oracle Purchasing and Oracle Payables flows that require a supplier-centric, multi-organization presentation of vendor data — most notably the supplier list, supplier query, and payables workbench screens where active and inactive pay-site counts drive user-facing behavior.

The view unifies two distinct data populations via a UNION: the first branch draws from AP_SUPPLIERS joined to HR_OPERATING_UNITS, IBY_EXTERNAL_PAYEES_ALL, and HZ_PARTIES, providing full supplier header, payee, and party information per operating unit. The second branch, visible in the excerpt, appears to source alternate party records (for example, supplier entities not yet staged as AP suppliers) with a reduced column set. This dual nature makes the view a canonical source for supplier identity resolution in multi-org deployments.

Underlying Base Objects

ETRM documents the following referenced base objects for PO_VENDORS_AP_V:

• AP_SUPPLIERS (SYNONYM) — supplier/vendor header, supplying VENDOR_ID, SEGMENT1, NUM_1099, VAT_REGISTRATION_NUM, ENABLED_FLAG, HOLD_ALL_PAYMENTS_FLAG, VENDOR_TYPE_LOOKUP_CODE, FEDERAL_REPORTABLE_FLAG, EMPLOYEE_ID, AWT_GROUP_ID, ALLOW_AWT_FLAG, AUTO_CALCULATE_INTEREST_FLAG, START_DATE_ACTIVE, and END_DATE_ACTIVE.
• HR_OPERATING_UNITS (VIEW) — provides ORGANIZATION_ID, joined via MO_GLOBAL.CHECK_ACCESS for operating-unit security.
• HZ_PARTIES (SYNONYM) — supplies PARTY_NAME (aliased TRADING_PARTNER) and PARTY_ID.
• IBY_EXTERNAL_PAYEES_ALL (SYNONYM) — contributes PAYMENT_FUNCTION, EXCLUSIVE_PAYMENT_FLAG, SETTLEMENT_PRIORITY, and BANK_CHARGE_BEARER.
• AP_INVOICES_PKG (PACKAGE) — supplies GET_TOTAL_PREPAYS and GET_AVAILABLE_PREPAYS.
• PO_VENDORS_AP_PKG (PACKAGE) — supplies GET_NUM_ACTIVE_PAY_SITES and GET_NUM_INACTIVE_PAY_SITES.
• MO_GLOBAL (PACKAGE) — enforces multi-org access control via CHECK_ACCESS.

Key Columns

• ACTIVE_FLAG — derived comparison of START_DATE_ACTIVE and END_DATE_ACTIVE against SYSDATE; returns 'Y' only when today falls within the active window.
• NUM_ACTIVE_PAY_SITES — returned by PO_VENDORS_AP_PKG.GET_NUM_ACTIVE_PAY_SITES for the vendor/organization pair. This is the column most commonly searched by users investigating pay-site counts.
• NUM_INACTIVE_PAY_SITES — counterpart function result for inactive pay sites.
• TOTAL_PREPAYS / AVAILABLE_PREPAYS — prepayment balances retrieved by AP_INVOICES_PKG for the vendor in the given operating unit.
• ORG_ID — operating unit key returned from HR_OPERATING_UNITS.
• VENDOR_ID, VENDOR_NUMBER, TRADING_PARTNER, NUM_1099, TYPE_1099 — identifier and tax-reporting attributes.
• PAYMENT_FUNCTION, EXCLUSIVE_PAYMENT_FLAG, SETTLEMENT_PRIORITY, BANK_CHARGE_BEARER — payee-level payment behavior attributes.

Common Use Cases and Queries

The view is typically queried to display supplier status in a specific operating unit, and to surface pay-site counts without joining to AP_SUPPLIER_SITES_ALL directly. A representative query is:

SELECT VENDOR_ID, VENDOR_NUMBER, TRADING_PARTNER, ORG_ID, ACTIVE_FLAG, NUM_ACTIVE_PAY_SITES, NUM_INACTIVE_PAY_SITES FROM APPS.PO_VENDORS_AP_V WHERE ORG_ID = :P_ORG_ID AND ACTIVE_FLAG = 'Y';

To locate vendors with multiple active pay sites, filter on the function-backed column:

SELECT VENDOR_ID, VENDOR_NUMBER, ORG_ID, NUM_ACTIVE_PAY_SITES FROM APPS.PO_VENDORS_AP_V WHERE NUM_ACTIVE_PAY_SITES > 1;

Because NUM_ACTIVE_PAY_SITES and NUM_INACTIVE_PAY_SITES are invoked through PL/SQL functions, queries that filter on them can incur per-row execution cost; restricting by ORG_ID or VENDOR_ID first, as above, keeps result sets manageable. MO_GLOBAL.CHECK_ACCESS ensures only operating units the responsibility can access are returned, so callers do not need to re-apply org security.