Results for “line_intended_use”

50+ results




Overview
Explore in AI Chat

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

Overview

OKL_CS_TERMQTE_TAX_SUM_UV is an APPS-owned reporting view in the Oracle E-Business Suite (EBS) Leasing and Finance Management module (OKL). Its documented purpose is to display the tax summary for a Termination Quote line. The view consolidates estimated tax data associated with quote lines that flow through Oracle's E-Business Tax engine, exposing tax amounts, assessable values, and the tax classification attributes applied at the line level.

In both release 12.1.1 and 12.2.2, the view is defined with STATUS = VALID and is referenced as a read-only reporting object rather than a transactional table. It is typically consumed by termination quote inquiry screens, tax reconciliation reports, and extract programs that need to present tax detail at the quote line granularity. Because it draws on E-Business Tax denormalized classification views and the leasing taxes source table, it serves as a bridge between the OKL termination quote structure and the ZX (E-Business Tax) classification framework.

Underlying Base Objects

The view is constructed over a mixture of synonyms and views, joined primarily on optional (outer) relationships. The principal source table is OKL_TAX_SOURCES (TAXS), which holds the estimated tax records generated for termination quotes. The filter conditions narrow the view to ENTITY_CODE = 'AM_QUOTES', APPLICATION_ID = 540, EVENT_CLASS_CODE = 'ESTIMATED_BILLING', TRX_LEVEL_TYPE = 'LINE', TAX_CALL_TYPE_CODE = 'INVOICE_TAX', and TAX_LINE_STATUS_CODE = 'ACTIVE'.

Supporting objects include OKC_K_LINES_B and OKC_LINE_STYLES_B for core contract line information, OKL_STRM_TYPE_B for stream type definition, and HZ_CUST_ACCOUNTS for the bill-to customer. FND_LOOKUPS supplies meaning values for line type and stream type purpose. The E-Business Tax side is represented by ZX_FC_CODES_DENORM_B (transaction business category), ZX_FC_PRODUCT_CATEGORIES_V, ZX_FC_USER_DEFINED_V, and ZX_FC_INTENDED_USE_V. The package OKL_LLA_UTIL_PVT is called at runtime to derive the asset location, and FND_GLOBAL provides session context.

Key Columns

Common Use Cases and Queries

The most common requirement is retrieving tax summary information for a specific termination quote, including the asset location where the tax applies. A representative query joining on the quote identifiers:

SELECT bill_to_customer, line_type, asset_location, tax_date, tax_amount, total_tax
FROM apps.okl_cs_termqte_tax_sum_uv
WHERE kle_id = :p_kle_id
ORDER BY trx_line_id;

Analysts frequently filter on ASSET_LOCATION to aggregate termination quote tax across jurisdictions, or to reconcile estimated billing tax against actual invoiced tax for a given lease. Drill-down reports may join TRX_ID and TRX_LINE_ID back to OKL_TAX_SOURCES or to the FND_LOOKUPS values for LINE_TYPE. Because the view restricts results to ACTIVE lines with INVOICE_TAX call type in the AM_QUOTES entity, it is well suited to estimated tax reporting without additional filtering on status.