Search Results amount_discounted

Overview

APPS.PSA_MF_BALANCES_VIEW is a public Oracle E-Business Suite view owned by the APPS schema and registered under the FND Design Data namespace PSA.PSA_MF_BALANCES_VIEW. Its status is documented as VALID in ETRM 12.1.1 and 12.2.2. The view presents transaction distribution balances at the level of each customer transaction line GL distribution, consolidating monetary movements such as amounts due, applied, adjusted, credited, discounted, and remaining. Because the view is exposed as public, Oracle classifies it as suitable for custom reporting and other downstream data requirements, even though it is primarily consumed internally by Receivables-related PL/SQL packages.

Within the Oracle EBS architecture, PSA_MF_BALANCES_VIEW functions as a reporting and integration surface for multi-fund and public-sector style receivables analysis. It provides a denormalized read model that joins distribution-level accounting data with receipt and adjustment distributions, allowing balances to be analyzed without navigating the full underlying transactional schema.

Underlying Base Objects

The view is defined over five documented base objects, all accessed through APPS synonyms:

• AR_RECEIVABLE_APPLICATIONS_ALL — receipt application data linking cash receipts to transactions and lines.
• PSA_MF_ADJ_DIST_ALL — adjustment distribution data specific to the PSA multi-fund model.
• PSA_MF_RCT_DIST_ALL — receipt distribution data specific to the PSA multi-fund model.
• RA_CUSTOMER_TRX_LINES_ALL — the transaction line header information, including line numbers.
• RA_CUST_TRX_LINE_GL_DIST_ALL — the line-level GL distribution records that anchor the balance amounts.

These are referenced as synonyms in the APPS schema, consistent with standard EBS dictionary object deployment. The view depends on the RA_CUST_TRX_LINE_GL_DIST_ALL record as its driving distribution entity, then enriches it with applications, receipts, and adjustments.

Key Columns

• CUSTOMER_TRX_ID — the customer transaction identifier.
• CUST_TRX_LINE_GL_DIST_ID — the line GL distribution identifier, the finest grain in the view.
• CUSTOMER_TRX_LINE_ID — the customer transaction line identifier.
• LINE_NUMBER — the transaction line number.
• AMOUNT_DUE_ORIGINAL — the original amount due at the distribution level.
• AMOUNT_APPLIED — the amount applied against the transaction.
• AMOUNT_ADJUSTED — the amount adjusted.
• AMOUNT_CREDITED — the amount credited.
• AMOUNT_DISCOUNTED — the amount discounted, frequently searched because it exposes early-payment and earned discount amounts tied to the distribution.
• AMOUNT_DUE_REMAINING — the residual amount due after all applications, adjustments, credits, and discounts.

Common Use Cases and Queries

The view is referenced by APPS packages ARP_DET_DIST_PKG, PSA_MFAR_ADJUSTMENTS, and PSA_MFAR_RECEIPTS, and by the view PSA_MF_PAYMENT_SCHEDULES_V, which confirms its role in distributing receipt, adjustment, and payment schedule logic. Custom reporting frequently uses it for balance reconciliation and discount analysis.

Example: retrieve discount activity by transaction.

SELECT CUSTOMER_TRX_ID, LINE_NUMBER, AMOUNT_DISCOUNTED, AMOUNT_DUE_REMAINING FROM APPS.PSA_MF_BALANCES_VIEW WHERE AMOUNT_DISCOUNTED <> 0 ORDER BY CUSTOMER_TRX_ID, LINE_NUMBER;

Example: summarize balances per GL distribution.

SELECT CUST_TRX_LINE_GL_DIST_ID, AMOUNT_DUE_ORIGINAL, AMOUNT_APPLIED, AMOUNT_ADJUSTED, AMOUNT_CREDITED, AMOUNT_DISCOUNTED, AMOUNT_DUE_REMAINING FROM APPS.PSA_MF_BALANCES_VIEW WHERE CUSTOMER_TRX_ID = :p_trx_id;