Results for “okl_am_inv_org_uv”

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

Overview

OKL_AM_INV_ORG_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 — Lease and Finance Management, commonly referred to as Oracle Leasing (OLFM). Within the ETRM (Enterprise Transaction and Remarketing Management) functional area, the view serves a narrowly scoped purpose: it supplies the list of valid inventory organizations presented by the remarketing setup screen. Rather than querying the underlying organization definitions directly, the remarketing configuration UI consumes this view to populate the inventory organization list of values, ensuring that only currently active organizations are displayed. Because the object is a view and not a table, it stores no data of its own; it is a filtered, sorted projection of the standard organization definition view and therefore inherits the security and validation behavior of that source.

Underlying Base Objects

The documented base objects referenced by OKL_AM_INV_ORG_UV are:

• ORG_ORGANIZATION_DEFINITIONS (VIEW) — the primary data source. This is the standard Fusion-style organization definition view that joins HR organization, location, and business group information, exposing attributes such as organization code, name, classification, and disable date.
• HR_SECURITY (PACKAGE) — applied through ORG_ORGANIZATION_DEFINITIONS to enforce organization-level access. Only organizations the querying user is authorized to see are returned.
• HR_GENERAL (PACKAGE) — a supporting HR utility package invoked by the organization definition view to resolve business group and session context.

Consequently, visibility of inventory organizations through this view is governed by both the disable-date filter defined in the view text and the security profile assigned to the connecting user. Rows are restricted to organizations whose DISABLE_DATE is null or in the future at the time of the query.

Key Columns

The view exposes three columns, all drawn from ORG_ORGANIZATION_DEFINITIONS:

• ORGANIZATION_ID — the internal primary key of the inventory organization. This is the value typically stored in remarketing setup records and passed to APIs as the organization identifier.
• ORGANIZATION_CODE — the short, user-defined code for the organization (for example, a warehouse or plant code). Often used for concise display or cross-reference in interfaces.
• ORGANIZATION_NAME — the descriptive name of the organization. This is the value displayed to users in the remarketing setup list of values, and it is also the sort key: the view text orders results by ORGANIZATION_NAME.

No additional attributes, such as organization classification or location, are projected by this view, so consumers requiring those details must join back to ORG_ORGANIZATION_DEFINITIONS or related tables.

Common Use Cases and Queries

The principal use case is populating the inventory organization list of values on the remarketing setup screen, where users select the organization against which remarketing transactions are configured. A secondary use is ad-hoc or custom reporting in the leasing module that requires a security-filtered list of active inventory organizations. A typical query is:

• SELECT organization_id, organization_code, organization_name FROM okl_am_inv_org_uv ORDER BY organization_name;
• SELECT organization_name FROM okl_am_inv_org_uv WHERE organization_id = :p_org_id;
• SELECT organization_code, organization_name FROM okl_am_inv_org_uv WHERE organization_name LIKE :p_name || '%';

Because the view filters on SYSDATE, organizations disabled after the query date are excluded automatically; no additional disable-date predicate is required in consuming queries. Extensions typically reference it in SQL*Plus, concurrent program definitions, or custom Oracle Application Framework (OAF) pages that mirror the standard remarketing setup behavior.