Results for “okl_txl_rcpt_apps_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_TXL_RCPT_APPS_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, belonging to the OKL (Lease and Finance Management) product family. Its documented purpose is to support the application of cash to various OKL objects, a function that is central to lease receipt and reconciliation processing. The view presents a language-agnostic, denormalized projection of receipt application records, joining the transactional base table to its translation table so that descriptive text is returned in the session's current language. Because it exposes internal identifiers such as ILE_ID alongside lease-oriented foreign keys, the view serves as a bridging layer between the OKL receipt application model and downstream reporting, integration, or cash application logic. It is a read-only construct; all maintenance is performed against the underlying base and translation tables, with the view supplying a stable, consumable surface for queries and concurrent programs. In 12.1.1 and 12.2.2 the view is reported as VALID, indicating it is free of compilation errors in the ETRM repository.

Underlying Base Objects

The view is defined over two documented base objects, both reached through APPS synonyms. OKL_TXL_RCPT_APPS_B is the transactional base table holding the receipt application lines, and OKL_TXL_RCPT_APPS_TL is its corresponding translation table. The join condition links the two on the ID column and restricts the translation row to the language returned by USERENV('LANG'), so a single row per application is produced in the runtime session language. The view text also selects RCAB.ROWID as ROW_ID, providing a physical row identifier for the base table row. Base table columns are prefixed RCAB and translation columns RCAT; the only translated attribute exposed is DESCRIPTION. Both dependencies are documented in the ETRM metadata for this object.

Key Columns

• ROW_ID — ROWID of the underlying base row.
• ID — Primary identifier of the receipt application record; the join key between base and translation tables.
• ILE_ID — Identifier of the associated OKL ILE (lease/interest) object; a principal search target for users seeking "ile_id".
• CNR_ID, LLN_ID, LSM_ID, KHR_ID, STY_ID — Foreign keys to other OKL objects (contract, line, stream, and related entities) to which cash may be applied.
• RCT_ID_DETAILS, LINE_NUMBER, AMOUNT — Receipt detail reference, application line number, and applied cash amount.
• SFWT_FLAG — Flag carried from the translation table.
• DESCRIPTION — Translated descriptive text from OKL_TXL_RCPT_APPS_TL.
• AR_INVOICE_ID — Link to a related Oracle Receivables invoice.
• ORG_ID — Operating unit identifier supporting multi-org security.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — Descriptive flexfield columns.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

The view is typically queried to report applied cash against lease objects, to enforce operating unit security through ORG_ID, and to trace the relationship between a receipt application and an AR invoice. A frequent pattern is searching by ILE_ID to enumerate all cash applications associated with a given lease object. The following examples reflect documented columns.

• Retrieve applications for a specific lease object:
  SELECT id, ile_id, amount, description, org_id FROM okl_txl_rcpt_apps_v WHERE ile_id = :ile_id;
• List applications tied to an AR invoice:
  SELECT id, ar_invoice_id, amount, line_number FROM okl_txl_rcpt_apps_v WHERE ar_invoice_id = :invoice_id;
• Report applied amounts by operating unit:
  SELECT org_id, SUM(amount) FROM okl_txl_rcpt_apps_v GROUP BY org_id;

Because translation is resolved at query time, results reflect the language of the executing session; no language predicate is required by the caller.