Search Results default_line_set




Overview
Explore in AI Chat

Overview

The OE_AK_INVOICE_TO_ORGS_V view is a public APPS-schema database object belonging to the Oracle Order Management (ONT) product family. It is a thin projection view defined over the base object OE_INVOICE_TO_ORGS_V and is registered in the E-Business Suite schema with a VALID status. Its primary role is to expose the invoice-to organization attributes that Order Management maintains for a given ship-to/invoice-to destination, including commercial terms, pricing defaults, shipment tolerances, and the sales representative and order type assignments associated with that organization.

In Oracle EBS 12.1.1 and 12.2.2, this view functions as a read-oriented interface for reporting, integration, and inquiry purposes. Because it is a view rather than a table, it carries no storage of its own and inherits all data from the underlying OE_INVOICE_TO_ORGS_V. Report developers and integration engineers query it to resolve the default commercial parameters that Order Management applies when orders are entered against a particular invoice-to organization. The column named in the user's search, DEFAULT_LINE_SET, is exposed here and is significant because it identifies the default line set (grouping of related order lines) that the Order Management application applies for the invoice-to organization, which directly influences line numbering and grouping behavior during order entry.

Underlying Base Objects

The ETRM metadata for this object documents a single referenced base object: OE_INVOICE_TO_ORGS_V, itself a view. Accordingly, OE_AK_INVOICE_TO_ORGS_V does not select directly from base tables; it selects from OE_INVOICE_TO_ORGS_V, which in turn resolves to the underlying Order Management invoice-to organization tables. This layered design is typical of Order Management public views, where a "base" view encapsulates joins and business logic, and a companion "AK" (Attribute Knowledge / descriptive flexfield-related) view presents the same rows in a flatter, select-list-friendly form.

The view text is a straightforward column list, with no filtering WHERE clause, no joins, and no aggregation. Consequently, it returns one row per row available in OE_INVOICE_TO_ORGS_V, with the organization identifier acting as the effective key. Because no predicates are applied, the view is suitable for use in outer joins and lookup queries without unexpected row elimination.

Key Columns

Common Use Cases and Queries

Typical usage includes validating default commercial setup for an invoice-to organization, troubleshooting incorrect defaulting during order entry, and populating integration extracts. A representative query follows:

SELECT organization_id, price_list_id, freight_terms_code,
  payment_term_id, salesrep_id, order_type_id, default_line_set
FROM apps.oe_ak_invoice_to_orgs_v
WHERE organization_id = :p_org_id;

The view is also commonly joined to organization and customer master views on ORGANIZATION_ID to enrich reporting on default pricing, tolerances, and line set assignment. As with all APPS public views, it should be queried through the APPS schema, and callers should rely on it as a read-only interface rather than attempting DML.