Search Results ap_view_prepays_v




Overview
Explore in AI Chat

Overview

The APPS.AP_VIEW_PREPAYS_V view is a Payables module reporting object that consolidates prepayment application activity across invoices, invoice lines, purchase orders, and receiving records. Prepayments in Oracle Payables are advances issued to a supplier that are later applied against standard invoices; this view presents both sides of that relationship, exposing the prepayment invoice line, the applied amount, remaining unapplied balances, and the associated purchasing and receipt context. Its status is VALID in both 12.1.1 and 12.2.2, and it is owned by the APPS schema.

The view is not part of the core transactional table set; it is a read-only reporting and integration construct intended for inquiry, extract, and reconciliation purposes. Because it joins AP, PO, and RCV data in a single result set, it is particularly useful for buyers, Payables analysts, and technical teams building supplier advance reports or data warehouse feeds.

Underlying Base Objects

AP_VIEW_PREPAYS_V is defined over the following documented objects:

The view text shows a UNION of at least two branches: the first selects prepay invoice lines directly, and the second correlates an invoice line to its originating prepay line. Outer joins to PO and RCV objects mean PO and receipt columns can be null when a prepayment is not tied to purchasing activity.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling prepayment applications per supplier, identifying prepayments with remaining balances, and tracing prepayments to PO or receipt transactions. A representative query for open prepayment balances is:

SELECT prepay_number, vendor_name, prepay_amount_applied, prepay_amount_remaining, invoice_currency_code FROM ap_view_prepays_v WHERE prepay_amount_remaining > 0 ORDER BY vendor_name, prepay_number;

A second common query groups activity by supplier and period:

SELECT vendor_name, period_name, SUM(prepay_amount_applied) applied, SUM(prepay_amount_remaining) remaining FROM ap_view_prepays_v GROUP BY vendor_name, period_name;

Because the view enforces the PREPAY line type and non-discarded filter internally, consumers do not need to re-apply those predicates, though adding ORG_ID and SET_OF_BOOKS_ID filters is recommended for multi-org and multi-ledger environments.