Search Results date_gl

Overview

The view OKL_CNSLD_AP_INVS_V is owned by the APPS schema within Oracle E-Business Suite and belongs to the OKL – Leasing and Finance Management product family. It functions as the reporting and integration layer for the Payables consolidated invoice header, presenting one row per consolidated Payables invoice generated through the Oracle Lease Management to Payables interface. In ETRM 12.2.2 the object is registered as a VALID view, and in 12.1.1 it is documented under the same name and schema.

Because consolidated invoice headers originate from the complex internal structures of the leasing sub-ledger, direct queries against the underlying entity are unsuitable for reporting and downstream integration. This view normalises the consolidated invoice header into a stable, denormalised shape that exposes the identifiers, currency attributes, status codes, and descriptive flexfield columns needed to reconcile lease-related charges against the corresponding Payables invoices. Users who search for date_invoiced are typically attempting to date-stamp the creation or posting of these consolidated invoices, and this view is the correct access point for that attribute.

Underlying Base Objects

The view is defined over a single base object: the synonym OKL_CNSLD_AP_INVS, which resolves in the APPS schema to the underlying OKL consolidated invoice header entity. The view text selects the enumerated column list directly, adding only the pseudo-column ROWID to the projection. No joins, aggregations, or filters are applied, so row cardinality and column semantics are identical to the base entity. Consequently, all DML against the base table is immediately visible through the view, and no materialisation or refresh mechanism is involved.

Key Columns

• CNSLD_AP_INV_ID — primary identifier of the consolidated Payables invoice header.
• TRX_STATUS_CODE — lifecycle status of the consolidated invoice.
• VENDOR_INVOICE_NUMBER, INVOICE_NUMBER, SELF_BILL_INV_NUM — vendor-side and internal invoice numbering.
• DATE_INVOICED, DATE_GL — the invoiced date and the GL accounting date; DATE_INVOICED is the column most frequently queried.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE — currency and conversion context.
• AMOUNT — consolidated invoice amount.
• VENDOR_ID, ORG_ID, LEGAL_ENTITY_ID, SET_OF_BOOKS_ID — multi-org and ledger context.
• TRY_ID, IPVS_ID, IPPT_ID, VPA_ID, ACCTS_PAY_CC_ID — linking identifiers to lease transactions, vendor payment sources, and payables code combinations.
• PAYMENT_METHOD_CODE, PAY_GROUP_LOOKUP_CODE, INVOICE_TYPE — payment and classification attributes.
• FEE_CHARGED_YN, SELF_BILL_YN, MATCH_REQUIRED_YN — Yes/No processing flags.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield storage.
• Audit and concurrency columns: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, plus request metadata (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE).

Common Use Cases and Queries

Typical usages include reconciling lease-billed invoices to Payables, auditing invoicing cycles by date, and feeding downstream reporting or extracts. A representative query that responds directly to a search on date_invoiced is:

• SELECT cnsld_ap_inv_id, invoice_number, vendor_invoice_number, date_invoiced, date_gl, amount, currency_code, trx_status_code FROM okl_cnsld_ap_invs_v WHERE date_invoiced BETWEEN :p_from AND :p_to ORDER BY date_invoiced;
• SELECT org_id, currency_code, SUM(amount) FROM okl_cnsld_ap_invs_v WHERE date_invoiced >= TRUNC(SYSDATE,'MM') GROUP BY org_id, currency_code;
• SELECT v.cnsld_ap_inv_id, v.invoice_number, v.date_invoiced, v.amount FROM okl_cnsld_ap_invs_v v WHERE v.vendor_id = :p_vendor_id AND v.match_required_yn = 'Y';

These patterns support both point lookups and period-based reconciliation, and because the view mirrors the base entity exactly, it can also be used in BI Publisher data models and interface extracts without additional transformation.