Search Results po_vendors_active_ap_v

Overview

PO_VENDORS_ACTIVE_AP_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It resides in the Payables (AP) product module and exposes a filtered, consumer-friendly projection of supplier (vendor) records that are currently active. The view is defined over the PO_VENDORS base view and restricts output to vendors whose operational date window includes the current system date and whose ENABLED_FLAG is set to 'Y'. Because it combines date-range filtering with an enabled-status filter in its defining query, the view is intended for reporting, integration, and validation scenarios where only currently usable suppliers should be considered. When a user searches for the column name "awt_group_id" in the context of this object, the result surfaces the withholding tax attributes carried through from the base supplier definition, confirming that PO_VENDORS_ACTIVE_AP_V is a frequently referenced source for withholding tax configuration in vendor-facing queries.

Underlying Base Objects

The ETRM metadata documents a single referenced base object: PO_VENDORS, itself a view in the APPS schema. PO_VENDORS_ACTIVE_AP_V does not own storage; every column it returns is derived from the columns of PO_VENDORS. The relationship is a filtering and renaming projection rather than a join. Specifically, the view applies an effective-dating predicate using NVL on START_DATE_ACTIVE and END_DATE_ACTIVE, evaluated against SYSDATE, and an ENABLED_FLAG = 'Y' predicate. SEGMENT1 from the base object is aliased to VENDOR_NUMBER in the view, and VENDOR_NAME and VENDOR_ID are passed through unchanged. The DECODE on FEDERAL_REPORTABLE_FLAG conditionally exposes TYPE_1099 when the flag is 'Y' and returns a NULL string otherwise. Because both the view and its base are defined in APPS and are marked VALID, no recompilation or dependency concerns are documented.

Key Columns

• VENDOR_NAME — Supplier name as maintained on the vendor record.
• VENDOR_ID — Internal unique identifier for the supplier; the primary join key to AP invoice and payment tables.
• VENDOR_NUMBER — The supplier number, exposed as an alias of SEGMENT1 from PO_VENDORS.
• VENDOR_TYPE_LOOKUP_CODE — Lookup code classifying the supplier type.
• TYPE_1099 — The 1099 reporting type, returned only when FEDERAL_REPORTABLE_FLAG equals 'Y'; otherwise blank.
• EMPLOYEE_ID — Employee identifier where the supplier is also an employee.
• NUM_1099 — The 1099 tax identification number.
• VAT_REGISTRATION_NUM — Value-added tax registration number for the supplier.
• AWT_GROUP_ID — Identifier of the withholding tax group assigned to the supplier; this drives automatic withholding tax calculation on payments.
• ALLOW_AWT_FLAG — Indicates whether withholding tax is permitted for the supplier.
• HOLD_ALL_PAYMENTS_FLAG — Indicates whether all payments to the supplier are placed on hold.
• PARTY_ID — Identifier linking the supplier to the trading community party model.

Common Use Cases and Queries

The view is typically used to validate active suppliers before invoice or payment processing, to drive withholding tax lookups, and to feed supplier master extracts. A representative query retrieving withholding tax attributes is:

SELECT vendor_id, vendor_name, vendor_number, awt_group_id, allow_awt_flag FROM apps.po_vendors_active_ap_v WHERE allow_awt_flag = 'Y';

To list suppliers with federal 1099 reporting obligations:

SELECT vendor_id, vendor_name, num_1099, type_1099 FROM apps.po_vendors_active_ap_v WHERE type_1099 IS NOT NULL;

To identify suppliers whose payments are blocked:

SELECT vendor_id, vendor_name, hold_all_payments_flag FROM apps.po_vendors_active_ap_v WHERE hold_all_payments_flag = 'Y';

These queries return only vendors active as of the current date with ENABLED_FLAG set to 'Y', making the view a reliable foundation for operational reporting and integration in both EBS 12.1.1 and 12.2.2.