Search Results rec_psa

Overview

APPS.LNS_REC_ACT_CASH_CM_V is a view belonging to the Oracle E-Business Suite (EBS) Loan and Lease Management / Financial Services module (LNS schema objects exposed under the APPS synonym). It presents a consolidated, loan-centric picture of receivable activity — specifically the cash receipts and credit memos (CM) that have been applied against loan amortization schedule lines. The view joins loan amortization data with Oracle Receivables (AR) transaction, payment schedule, and receivable application data, producing a line-level record of how each amortization payment was settled.

The naming convention reflects its role: "LNS_REC_ACT" denotes loan receivable activity, "CASH_CM" indicates that only cash receipt and credit memo application types are relevant, and the "_V" suffix confirms it is a read-only database view. In ETRM 12.1.1 and 12.2.2, this view is a critical bridge between the loan accounting subledger and AR, allowing reporting on application history without traversing the many underlying foreign key relationships manually. The search term "rec_psa" corresponds directly to the aliased column rec_psa.trx_number, which exposes the transaction number of the payment schedule associated with the receivable application.

Underlying Base Objects

The view is defined over a set of documented base tables, synonyms, and views:

• LNS_LOAN_HEADERS_ALL (synonym) — the master loan header, supplying LOAN_ID, ORG_ID, and LEGAL_ENTITY_ID.
• LNS_AMORTIZATION_SCHEDS (synonym) — amortization schedule headers, providing AMORTIZATION_SCHEDULE_ID, PAYMENT_NUMBER, DUE_DATE, and PHASE.
• LNS_AMORTIZATION_LINES (synonym) — line-level amortization detail, linking to customer transaction and transaction line IDs, and carrying LINE_TYPE.
• RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL (synonyms) — AR transaction headers and lines, supplying TRX_NUMBER, reason codes, and line descriptions.
• AR_PAYMENT_SCHEDULES_ALL (synonym) — referenced twice (trx_psa for the applied transaction, rec_psa for the receipt transaction), supplying transaction numbers, classes, and currency codes.
• AR_RECEIVABLE_APPLICATIONS_ALL (synonym) — the application records that link cash/credit memos to invoices, including AMOUNT_APPLIED, APPLY_DATE, APPLICATION_TYPE, and rate information.
• AR_LOOKUPS (view) and LNS_LOOKUPS (view) — decode lookup meanings for INV/CM classes, reason codes, and payment application types.
• FND_GLOBAL (package) — referenced for session context.

Key Columns

• LOAN_ID / AMORTIZATION_SCHEDULE_ID / PAYMENT_NUMBER — identify the loan and the specific scheduled payment.
• trx_psa.customer_trx_id / payment_schedule_id / trx_number — the invoice transaction against which the amortization line was created.
• rec_psa.trx_number — the transaction number of the cash receipt or credit memo applied (the "rec_psa" reference).
• LINE_TYPE / LOK2.meaning — lookup-driven classification of the amortization line (e.g., principal, interest).
• -rec.amount_applied — the negative of the applied amount, normalized for reporting sign conventions.
• APPLY_DATE / RECEIVABLE_APPLICATION_ID / CASH_RECEIPT_ID — application date and identifiers for the receipt.
• TRX_PSA.INVOICE_CURRENCY_CODE and the decode()-derived currency/rate columns — populated only when APPLICATION_TYPE = 'CASH', providing the receipt currency and TRANS_TO_RECEIPT_RATE.
• DECODE(rec.applied_customer_trx_line_id, null, 'Entire Transaction', lines.DESCRIPTION) — indicates whether the application was at transaction or line level.
• ORG_ID / LEGAL_ENTITY_ID — multi-org security and legal entity attribution.
• NVL(am.PHASE, 'TERM') — normalizes null phases to 'TERM'.

Common Use Cases and Queries

This view supports loan-to-AR application reconciliation, cash application reporting, and credit memo analysis for loan schedules. Because the view already resolves the many lookup and join relationships, it is commonly queried directly.

SELECT loan_id,
       amortization_schedule_id,
       payment_number,
       trx_number,
       rec_psa_trx_number,
       apply_date,
       amount_applied
FROM   apps.lns_rec_act_cash_cm_v
WHERE  loan_id = :p_loan_id;

Typical scenarios include: tracing which cash receipts settled each amortization payment; identifying credit memos applied to loan invoices; verifying receipt currency and conversion rates on cash applications; and reconciling receivable activity by ORG_ID and LEGAL_ENTITY_ID for subledger accounting. Filtering by APPLY_DATE and CASH_RECEIPT_ID enables period-based cash application reporting, while grouping by LOAN_ID and PAYMENT_NUMBER supports aging and schedule-versus-actual variance analysis.