Results for “invoice_line_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_CS_BILLINGTRX_UV is a read-only database view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the OKL product family — Oracle Lease and Finance Management — and is documented in the ETRM reference as displaying transaction-level billing information. In practice, the view consolidates invoice and payment-schedule detail for leased assets so that billing transactions can be reported without navigating the full underlying contract, asset, and receivables model.
The "UV" suffix indicates a user view intended for reporting, inquiry, and downstream integration rather than for transactional processing. Because the view is defined over sources that include AutoInvoice-related payment schedules and OKL billing detail structures, rows returned reflect the state of billing at the time the query executes. The view is marked VALID, confirming that its dependencies resolve correctly in the documented environment. Its role is largely analytical: it exposes lease billing history at the transaction level, joining lease contracts to fixed assets and to Oracle Receivables payment schedules.
Underlying Base Objects
The documented view text defines OKL_CS_BILLINGTRX_UV over a union of billing detail sources. The principal reporting source is OKL_CS_BPD_INV_DTL_V, itself a view, from which invoice number, invoice amount, line amount, tax, amounts applied and remaining, payment terms, invoice type, and the AR invoice identifiers are drawn. This source is joined to AR_PAYMENT_SCHEDULES_ALL (a synonym to the Receivables table) on AR_INVOICE_ID = CUSTOMER_TRX_ID, supplying exchange rate type, exchange rate, exchange date, and transaction date.
Contract structure comes from OKC_K_ITEMS, OKC_K_LINES_B, OKC_LINE_STYLES_B, and OKC_K_LINES_TL, restricted to lines whose line style code is 'FIXED_ASSET'. Asset identification is resolved through FA_ADDITIONS_B, linked via JTOT_OBJECT1_CODE = 'OKX_ASSET', while OKL_K_HEADERS supplies the contract header and is constrained to exclude deals of type 'LOAN'. Transaction type names are resolved from OKL_STRM_TYPE_TL with LANGUAGE = USERENV('LANG'). The documented base object list also references the packages OKL_BILLING_UTIL_PVT, OKL_CS_LC_CONTRACT_PVT, and FND_GLOBAL, indicating that the view's dependency chain includes PL/SQL logic as well as tables.
Key Columns
- LSM_ID, CONTRACT_NUMBER, KHR_ID — lease/contract identifiers and the contract header reference.
- TRANSACTION_TYPE — stream type name describing the billing transaction.
- INVOICE_NUMBER, INVOICE_ID, INVOICE_LINE_ID, CUSTOMER_TRX_ID — AR invoice and line identifiers.
- INVOICE_AMOUNT, TRANSACTION_AMOUNT, AMOUNT_LINE_ITEMS_ORIGINAL — original billing amounts at invoice and line level.
- AMOUNT_APPLIED, AMOUNT_REMAINING, AMOUNT_LINE_ITEMS_REMAINING, AMOUNT_CREDITED — application and outstanding balances, including credits.
- TAX_ORIGINAL, TAX_REMAINING — tax amounts billed and outstanding.
- INVOICE_DATE, DUE_DATE, AR_TRX_DATE — key billing dates.
- CURRENCY_CODE, AR_EXCHANGE_RATE_TYPE, AR_EXCHANGE_RATE, AR_EXCHANGE_DATE — currency and AR conversion attributes.
- ASSET_ID, ASSET_NUMBER — the fixed asset associated with the billed line.
- CUSTOMER_ACCOUNT_ID, CONTRACT_AUTHORING_ORG_ID — customer and operating unit context.
- KLE_ID, CHR_ID, STY_ID — contract line, header, and stream type keys.
- PAYMENT_TERM, INVOICE_TYPE — Receivables payment terms and invoice classification.
Common Use Cases and Queries
Typical usage includes reconciliation of lease billing to Receivables, reporting outstanding and credited balances by contract or asset, and analysis of tax and exchange rate treatment on billed transactions. Because the view excludes loan-type deals and restricts to fixed-asset lines, it is well suited to equipment lease reporting.
Sample query — outstanding balances by contract:
- SELECT contract_number, invoice_number, transaction_type, currency_code, amount_remaining, due_date FROM okl_cs_billingtrx_uv WHERE amount_remaining > 0 ORDER BY due_date;
Sample query — billing by asset:
- SELECT asset_number, contract_number, SUM(invoice_amount) billed, SUM(amount_remaining) outstanding FROM okl_cs_billingtrx_uv GROUP BY asset_number, contract_number;
Sample query — tax and credits for a period:
- SELECT invoice_number, tax_original, amount_credited, ar_exchange_rate FROM okl_cs_billingtrx_uv WHERE invoice_date BETWEEN :from_date AND :to_date;
Queries should be scoped by contract, customer, or date to limit the cost of the union and its underlying joins.
-
View: OKL_CS_BILLINGTRX_UV 12.1.1
Displays transaction-level billing information
APPS.OKL_CS_BILLINGTRX_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ FA_ADDITIONS_B·↳ FND_GLOBAL·Explore OKL module →
-
Base Summary Table for Receivables Revenue. It is used to support Revenue related portlets.
-
Intermediate FII table to store Sales Credits for AR transactions
-
APPS.OKL_RCPT_ARINV_BALANCES_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKL module →
-
View: OKL_CS_PROPERTY_TAX_UV 12.1.1
UI View for Estimated Property Tax
APPS.OKL_CS_PROPERTY_TAX_UV·↳ OKC_K_HEADERS_ALL_B·↳ OKC_K_LINES_B·↳ OKC_STATUSES_B·Explore OKL module →
-
View: OKL_CS_PROPERTY_TAX_UV 12.2.2
UI View for Estimated Property Tax
APPS.OKL_CS_PROPERTY_TAX_UV·↳ OKC_K_HEADERS_ALL_B·↳ OKC_K_LINES_B·↳ OKC_STATUSES_B·Explore OKL module →
-
View: OKL_CS_BILLINGTRX_UV 12.2.2
Displays transaction-level billing information
APPS.OKL_CS_BILLINGTRX_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ FA_ADDITIONS_B·↳ FND_GLOBAL·Explore OKL module →
-
APPS.OKL_RCPT_ARINV_BALANCES_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKL module →
-
View: OKL_CS_BPD_INV_DTL_V 12.1.1
New CS Billing base view
APPS.OKL_CS_BPD_INV_DTL_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore OKL module →
-
APPS.AP_EXPENSE_FEED_DISTS_OPEN_V·↳ AP_CARDS·↳ AP_CARD_PROFILES·↳ AP_CARD_PROGRAMS·Explore AP module →
-
Accounting information for credit card transactions
-
Stores information used to create invoice distributions
-
View: OKL_XTL_PAY_INVS_V 12.1.1
Stores information used to create invoice distributions
APPS.OKL_XTL_PAY_INVS_V·↳ OKL_XTL_PAY_INVS_B·↳ OKL_XTL_PAY_INVS_TL·Explore OKL module →
-
This view will fetch the open invoices whose freight and charges remaining are greater than zero.
APPS.OKL_RCPT_FREIGHT_LINES_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ RA_CUSTOMER_TRX_ALL·Explore OKL module →
-
This view will fetch the open invoices whose freight and charges remaining are greater than zero.
APPS.OKL_RCPT_FREIGHT_LINES_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ RA_CUSTOMER_TRX_ALL·Explore OKL module →
-
This table stores all the payment items of leases in Oracle Assets
-
View: FII_AR_TRX_DIST_FCV 12.1.1
Internal view used for warehouse data extraction
APPS.FII_AR_TRX_DIST_FCV·↳ EDW_CURRENCY·↳ EDW_UTIL·↳ FIIBV_AR_TRX_DIST_FCV·Explore FII module →
-
This table stores all the payment items of leases in Oracle Assets
-
Accounts Receivable Revenue Fact table
-
Accounting information for credit card transactions
-
Stores information used to create invoice distributions
-
APPS.FA_LEASE_PAYMENT_ITEMS_V·↳ FA_AMORT_SCHEDULES·↳ FA_LEASES·↳ FA_LEASE_PAYMENT_ITEMS·Explore OFA module →
-
APPS.OKL_RCPT_CUST_CONT_BALANCES_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKL module →
-
View: OKL_CS_BPD_INV_DTL_V 12.2.2
New CS Billing base view
APPS.OKL_CS_BPD_INV_DTL_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore OKL module →
-
APPS.FA_LEASE_PAYMENT_ITEMS_V·↳ FA_AMORT_SCHEDULES·↳ FA_LEASES·↳ FA_LEASE_PAYMENT_ITEMS·Explore OFA module →
-
This view is used to fetch the open invoice lines for a contract or investor agreement or termination quote or non OKL invoices.
APPS.OKL_RCPT_INVOICE_LINES_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ OKC_K_HEADERS_ALL_B·↳ OKL_CNSLD_AR_HDRS_ALL_B·Explore OKL module →
-
This view is used to fetch the open invoice lines for a contract or investor agreement or termination quote or non OKL invoices.
APPS.OKL_RCPT_INVOICE_LINES_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ OKC_K_HEADERS_ALL_B·↳ OKL_CNSLD_AR_HDRS_ALL_B·Explore OKL module →
-
Table to store invoice line information
-
APPS.OKL_RCPT_CUST_CONT_BALANCES_UV·↳ AR_PAYMENT_SCHEDULES_ALL·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKL module →
-
View: OKL_CS_TRX_PAYMENTS_UV 12.2.2
APPS.OKL_CS_TRX_PAYMENTS_UV·↳ AR_ACTIVITY_DETAILS·↳ AR_CASH_RECEIPTS_ALL·↳ AR_CASH_RECEIPT_HISTORY_ALL·Explore OKL module →
-
Table to store invoice line information
-
View: OKL_XTL_PAY_INVS_V 12.2.2
Stores information used to create invoice distributions
APPS.OKL_XTL_PAY_INVS_V·↳ OKL_XTL_PAY_INVS_B·↳ OKL_XTL_PAY_INVS_TL·Explore OKL module →
-
View: OKL_CS_TRX_PAYMENTS_UV 12.1.1
APPS.OKL_CS_TRX_PAYMENTS_UV·↳ AR_ACTIVITY_DETAILS·↳ AR_CASH_RECEIPTS_ALL·↳ AR_CASH_RECEIPT_HISTORY_ALL·Explore OKL module →
-
Table used for IPAC disbursement import
-
Table used for IPAC disbursement import
-
Table used for IPAC disbursement import
-
APPS.AP_INVOICE_LINES_INTERFACE_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS·↳ AP_INVOICES_INTERFACE·Explore AP module →
-
APPS.AP_EXPENSE_FEED_DISTS_V·↳ AP_CARDS·↳ AP_CARD_PROFILES·↳ AP_CARD_PROGRAMS·Explore AP module →
-
Table used for IPAC disbursement import
-
View Transaction History in Self-Service Expenses is based on this view
APPS.AP_EXPENSE_FEED_DISTS_V·↳ AP_CARDS·↳ AP_CARD_PROFILES·↳ AP_CARD_PROGRAMS·Explore AP module →
-
APPS.AP_INVOICE_LINES_INTERFACE_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS·↳ AP_INVOICES_INTERFACE·Explore AP module →
-
Verify Open Transactions in Self-Service Expenses is based on this view
APPS.AP_EXPENSE_FEED_DISTS_OPEN_V·↳ AP_CARDS·↳ AP_CARD_PROFILES·↳ AP_CARD_PROGRAMS·Explore AP module →
-
Information used to create one or more invoice distributions
-
Accounts Receivable Revenue Fact table.
-
This is a delete log table for the Accounts Receivable Revenue Fact (FII_AR_TRX_DIST_F). When a record is updated in the Accounts Receivable Revenue Fact, the old record is moved into the DLOG table. Thus, the DLOG table remembers the val
-
Information used to create one or more invoice distributions