Results for “maximum_financed_amount”

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

Overview

OKL_SUBSIDY_CRITERIA is a transaction-table object owned by the OKL schema within the Oracle Lease and Finance Management (OKL/ETRM) module of Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store the applicability criteria that determine when a given subsidy may be applied to a lease or finance contract. A subsidy in ETRM represents a vendor-funded or internally funded discount, rate buydown, or incentive that reduces the cost of a financed asset to the lessee. Because subsidies rarely apply universally, this table acts as the qualifying rule set: each subsidy may be associated with multiple criterion rows, and each row constrains the subsidy using dimensions such as product, item, organization, territory, credit classification, and industry.

In data-vault modeling terms, the heuristic classification derived from the foreign-key structure is link. This table therefore functions as an association (junction) entity that resolves many-to-many relationships between a subsidy definition and the business entities it applies to. It is not a pure reference satellite; it carries multiple independent foreign keys and its own surrogate identity, which is consistent with link semantics.

Key Information Stored

The table contains 34 documented columns. The most significant include:

• ID — the surrogate primary key, enforced by OKL_SUBSIDY_CRITERIA_PK and by the unique index OKL_SUBSIDY_CRITERIA_U1. It is a business-key candidate only in the technical sense of uniqueness; the true business identity is the combination of criteria values.
• SUBSIDY_ID — foreign key to OKL_SUBSIDIES_ALL_B, identifying the parent subsidy to which the criterion belongs.
• INVENTORY_ITEM_ID and ORGANIZATION_ID — foreign keys to MTL_SYSTEM_ITEMS_B, defining item and inventory-organization applicability.
• PRODUCT_ID — foreign key to OKL_PRODUCTS, tying the criterion to an ETRM product definition.
• SALES_TERRITORY_CODE and SALES_TERRITORY_ID — territory qualification, with SALES_TERRITORY_CODE referencing FND_TERRITORIES.
• CREDIT_CLASSIFICATION_CODE — restricts the subsidy to a borrower or lessee credit tier.
• INDUSTRY_CODE_TYPE and INDUSTRY_CODE — industry-sector qualification.
• MAXIMUM_FINANCED_AMOUNT — a monetary threshold limiting subsidy eligibility by financed amount.
• DISPLAY_SEQUENCE — ordering value used when rendering criteria in the subsidy setup UI.
• OBJECT_VERSION_NUMBER — optimistic-locking column standard to EBS tables.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle descriptive-flexfield columns for extensibility without schema change.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit (WHO) columns populated by the EBS framework.

Common Use Cases and Queries

The principal use case is subsidy qualification during lease origination, quotation, or booking. A common reporting query lists all criteria for a subsidy:

• SELECT c.id, c.subsidy_id, c.inventory_item_id, c.organization_id, c.product_id, c.sales_territory_code, c.credit_classification_code, c.maximum_financed_amount FROM okl.okl_subsidy_criteria c WHERE c.subsidy_id = :p_subsidy_id ORDER BY c.display_sequence;
• Join to OKL_SUBSIDIES_ALL_B to retrieve the subsidy name and status alongside each criterion: ... FROM okl_subsidy_criteria c, okl_subsidies_all_b s WHERE c.subsidy_id = s.id.
• Eligibility diagnostics for a specific contract context, filtering on item, organization, product, and territory to determine which subsidies qualify.
• Setup validation and reconciliation reports that identify subsidies with no criteria (unrestricted) versus heavily restricted subsidies.

Related Objects

The following objects are principal participants in the relationships documented for OKL_SUBSIDY_CRITERIA:

• OKL_SUBSIDIES_ALL_B — parent subsidy definition; joined on SUBSIDY_ID = ID.
• MTL_SYSTEM_ITEMS_B — item master; joined on INVENTORY_ITEM_ID and ORGANIZATION_ID.
• OKL_PRODUCTS — ETRM product definition; joined on PRODUCT_ID.
• FND_TERRITORIES — territory reference; joined on SALES_TERRITORY_CODE.
• OKL_SUBSIDY_CRITERIA_PK / OKL_SUBSIDY_CRITERIA_U1 — the primary key constraint and unique index on ID.
• OKL_SUBSIDIES_ALL_TL and related subsidy API or setup forms — logical consumers that read criteria rows to validate subsidy application during lease authoring.