Results for “disbursement_amount”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.LNS_LOAN_DETAILS_EXT_V view is a Loans module (LNS) reporting object that exposes the accounting lines generated for loan transactions, formatted for extraction and downstream load into Oracle Subledger Accounting (SLA) or an external accounting system. Its documented description, "Loans Accounting Lines Extract," positions it as the interface between the LNS transaction/distribution layer and the XLA events and ledgers that ultimately produce journal entries.
In Oracle EBS 12.1.1 and 12.2.2 the Loans application accounts for disbursements, approvals, cancellations, repayments, and adjustments. Each accounting-relevant activity produces rows in LNS_DISTRIBUTIONS, each tied to an XLA_EVENTS record. This view consolidates the distribution, its accounting event, the target ledger, the loan header detail, and the account code combination into a single flattened result set suitable for extraction programs and reconciliation reports. Because the view carries an _EXT_V suffix, it is designed to be consumed by external or extension processes rather than by standard form runtime logic.
Underlying Base Objects
According to the documented 12.2.2 metadata, the view is owned by APPS and is defined over the following base objects:
LNS_DISTRIBUTIONS— the core distribution (accounting line) table, supplying distribution ID, line type, account name, account type, code combination, distribution amount and percent, and the DFF attributes.LNS_LOAN_HEADERS_ALL— loan header, supplying loan class code, requested amount, funded amount, and subsidy rate used in amount derivation.XLA_EVENTS— the accounting event driving each line, supplying EVENT_ID and EVENT_TYPE_CODE.XLA_TRANSACTION_ENTITIES— supplies the ledger context for the event.GL_CODE_COMBINATIONS— the account validation for the code combination.LNS_DISB_HEADERS,LNS_LOAN_AMOUNT_ADJS, andFV_FUND_PARAMETERS— supporting loan disbursement, adjustment, and funding parameter data.LNS_DISTRIBUTIONS_PUBandLNS_UTILITY_PUB— public packages invoked by the view logic for distribution and utility processing, including override of distribution amounts for direct-loan approval and cancellation events.
The view is therefore a join of transactional distribution data with the XLA event model, guarded by loan-class and event-type conditional logic.
Key Columns
EVENT_ID,LEDGER_ID— identify the XLA accounting event and destination ledger.DISTRIBUTION_ID,LOAN_ID— link back to the distribution and loan.LINE_TYPE,ACCOUNT_NAME,DISTRIBUTION_TYPE— classify the accounting line (for example SUBSIDY versus non-subsidy).CODE_COMBINATION_ID— the accounting flexfield account for the line.ACCOUNT_TYPE— the derived debit/credit indicator. Note the view actively flips DR/CR forDIRECTloans on theFUTURE_DISBURSEMENT_CANCELLEDevent.ENTERED_AMOUNT— derived via CASE logic: for direct-loan cancellations it is requested minus funded (scaled by subsidy rate for SUBSIDY lines); forDIRECT_LOAN_APPROVEDit is the requested amount (scaled by subsidy rate for SUBSIDY); otherwise the distribution amount.DISTRIBUTION_PERCENT,START_DATE_ACTIVE,END_DATE_ACTIVE— allocation and date-effectivity attributes.- Standard audit columns (
CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_VERSION_NUMBER,LAST_UPDATE_LOGIN) andATTRIBUTE_CATEGORY/ATTRIBUTE1–ATTRIBUTE20DFF columns. USSGL_TRANSACTION— the US Standard General Ledger transaction code.
Common Use Cases and Queries
Typical uses include extracting loan accounting lines for SLA journal creation, reconciling distributions to their accounting events, and reporting subsidy versus principal splits for direct loans. A representative query:
- Extract all lines for a ledger and event type:
SELECT event_id, ledger_id, loan_id, line_type, account_type, entered_amount
FROM apps.lns_loan_details_ext_v
WHERE ledger_id = :p_ledger_id; - Review reversal behaviour on cancelled direct-loan disbursements:
SELECT loan_id, account_type, entered_amount
FROM apps.lns_loan_details_ext_v
WHERE line_type = 'SUBSIDY'; - Join to
GL_CODE_COMBINATIONSfor the account string, and toLNS_LOAN_HEADERS_ALLviaLOAN_IDfor borrower context.
Because amounts and DR/CR indicators are computed, consumers should treat ENTERED_AMOUNT and ACCOUNT_TYPE as the authoritative extract values rather than the raw LNS_DISTRIBUTIONS figures.
-
View: LNS_LOAN_DETAILS_EXT_V 12.1.1
Loans Accounting Lines Extract
APPS.LNS_LOAN_DETAILS_EXT_V·↳ FV_FUND_PARAMETERS·↳ GL_CODE_COMBINATIONS·↳ LNS_DISB_HEADERS·Explore LNS module →
-
View: OKL_CURE_RFND_DTLS_UV 12.1.1
View by Vendor refunds
APPS.OKL_CURE_RFND_DTLS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_ALL_B·Explore OKL module →
-
APPS.OKL_CS_DISBURSEMENTS_UV·↳ AP_CHECKS_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS_ALL·Explore OKL module →
-
List all the cure refunds along with the invoice and the disbursed amount
APPS.OKL_CURE_REFUNDS_SUMRY_UV·↳ OKC_K_HEADERS_ALL_B·↳ OKL_CURE_REFUNDS·↳ OKL_CURE_REFUND_HEADERS_B·Explore OKL module →
-
Full View for the Entity that holds the information about the Application Review Groups
APPS.IGFFV_PELL_DISBURSEMENTS·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_AW_AWARD_ALL·Explore IGF module →
-
List all the cure refunds along with the invoice and the disbursed amount
APPS.OKL_CURE_REFUNDS_HDRS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_CURE_REFUND_HEADERS_V·Explore OKL module →
-
List all the cure refunds along with the invoice and the disbursed amount
APPS.OKL_CURE_REFUNDS_SUMRY_UV·↳ FND_GLOBAL·↳ OKC_K_HEADERS_ALL_B·↳ OKL_CURE_REFUNDS·Explore OKL module →
-
Base View for the Entity that holds the information about the Application Review Groups
APPS.IGFBV_PELL_DISBURSEMENTS·↳ IGF_AP_FA_BASE_REC_ALL·↳ IGF_GR_RFMS_ALL·↳ IGF_GR_RFMS_DISB_ALL·Explore IGF module →
-
Stores refunds made to vendor for cured contracts. Cure refund pool is per contract. The refund will group all the cash recieved by the vendor for one contract ID
-
Stores refunds made to vendor for cured contracts. The table will hold refund requests grouped by currency and vendor /contract.
APPS.OKL_CURE_REFUND_HEADERS_V·↳ OKL_CURE_REFUND_HEADERS_B·↳ OKL_CURE_REFUND_HEADERS_TL·Explore OKL module →
-
Stores refunds made to vendor for cured contracts. The table will hold refund requests grouped by currency and vendor /contract.
-
Stores refunds made to vendor for cured contracts. Cure refund pool is per contract. The refund will group all the cash recieved by the vendor for one contract ID
-
List all the cure refunds along with the invoice and the disbursed amount
APPS.OKL_CURE_REFUNDS_HDRS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_CURE_REFUND_HEADERS_V·Explore OKL module →
-
APPS.OKL_CS_DISBURSEMENTS_UV·↳ AP_CHECKS_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS_ALL·Explore OKL module →
-
View: OKL_CURE_RFND_DTLS_UV 12.2.2
View by Vendor refunds
APPS.OKL_CURE_RFND_DTLS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_ALL_B·Explore OKL module →
-
Table: LNS_AMORT_SCHEDS_GT 12.2.2
-
Stores refunds made to vendor for cured contracts. The table will hold refund requests grouped by currency and vendor /contract.
APPS.OKL_CURE_REFUND_HEADERS_V·↳ OKL_CURE_REFUND_HEADERS_B·↳ OKL_CURE_REFUND_HEADERS_TL·Explore OKL module →
-
Stores refunds made to vendor for cured contracts. The table will hold refund requests grouped by currency and vendor /contract.
-
View: LNS_LOAN_DETAILS_EXT_V 12.2.2
Loans Accounting Lines Extract
APPS.LNS_LOAN_DETAILS_EXT_V·↳ FV_FUND_PARAMETERS·↳ GL_CODE_COMBINATIONS·↳ LNS_DISB_HEADERS·Explore LNS module →
-
Not implemented in this database·Explore OKL module →
-
Not implemented in this database·Explore OKL module →
-
View: OKL_CURE_REFUNDS_V 12.2.2
Stores refunds made to vendor for cured contracts
Not implemented in this database·Explore OKL module →
-
View: OKL_CURE_REFUNDS_V 12.1.1
Stores refunds made to vendor for cured contracts
Not implemented in this database·Explore OKL module →
-
Base View for the Entity that holds the information about the Application Review Groups
Not implemented in this database·Explore IGF module →