Search Results oe_ak_ship_partial_v




Overview
Explore in AI Chat

Overview

OE_AK_SHIP_PARTIAL_V is a lightweight Oracle E-Business Suite view owned by the APPS schema in the Order Management (ONT) module. It is documented as VALID in ETRM for releases 12.1.1 and 12.2.2. The view is a static list-of-values (LOV) helper rather than a transactional data source; its sole purpose is to expose the set of valid values for the Yes/No lookup type so that Oracle Application Framework (OAF) and AK-based regions in Order Management can present a "Ship Partial Allowed" choice consistently. The view text is a single-column projection over FND_LOOKUPS filtered by LOOKUP_TYPE = 'YES_NO', aliasing the LOOKUP_CODE column as SHIP_PARTIAL_ALLOWED. When a user searches for oe_ak_ship_partial_v, they are typically looking for the definition behind the "Ship Partial" indicator on the shipping or order line, the SQL that populates that LOV, or confirmation that the object can be queried safely for reporting.

Underlying Base Objects

The ETRM metadata lists two referenced base objects: FND_LOOKUPS (VIEW) and FND_GLOBAL (PACKAGE). The primary dependency is FND_LOOKUPS, the Oracle Application Object Library view over the underlying FND_LOOKUPS table that stores seeded and user-defined lookup codes by lookup type. OE_AK_SHIP_PARTIAL_V does not join to OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, or any shipping table; the actual flag denoting whether partial shipment is permitted is stored elsewhere (for example on the order or line attributes), while this view only enumerates the permissible answers — Yes and No. Because AK views frequently call FND_GLOBAL to resolve the current application, user, or session context at runtime, FND_GLOBAL appears as a referenced object even though it does not appear literally in the SELECT text. In practical terms, the view behaves as a read-only, unfiltered lookup list; it carries no organization, operating unit, or security predicate, so its rows are identical for every session.

Key Columns

  • SHIP_PARTIAL_ALLOWED — the only documented column. It is the lookup code from FND_LOOKUPS for the 'YES_NO' type, so the values returned are the enabled Yes/No codes (typically 'Y' and 'N' when enabled). The column name reflects its business meaning: the value a user selects to indicate whether partial shipment of the order or line is allowed.

Although the view is defined with SELECT LOOKUP_CODE, the column is exposed as SHIP_PARTIAL_ALLOWED, which means consumers should reference the alias, not LOOKUP_CODE, when querying the view directly.

Common Use Cases and Queries

Typical scenarios include validating shipped or backordered lines against the allowed partial-shipment indicator, driving concurrent programs or BI Publisher reports that must respect the same Yes/No domain used by the Order Management LOV, and confirming during a 12.1.1 to 12.2.2 upgrade that the lookup type has not been disabled or altered. A simple query to enumerate the allowed values is:

SELECT ship_partial_allowed FROM apps.oe_ak_ship_partial_v;

To list only the descriptive text alongside the code — joining back to the lookup view for meaning — use:

SELECT v.ship_partial_allowed, l.meaning FROM apps.oe_ak_ship_partial_v v, apps.fnd_lookups l WHERE l.lookup_type = 'YES_NO' AND l.lookup_code = v.ship_partial_allowed AND l.enabled_flag = 'Y';

A common reporting pattern is to join the view to order line data to flag lines that were partially shipped despite the indicator being 'N':

SELECT ooh.order_number, ool.line_number, ool.shipped_quantity, ool.ordered_quantity, v.ship_partial_allowed FROM apps.oe_order_headers_all ooh, apps.oe_order_lines_all ool, apps.oe_ak_ship_partial_v v WHERE ooh.header_id = ool.header_id AND v.ship_partial_allowed = 'N' AND ool.shipped_quantity > 0 AND ool.shipped_quantity < ool.ordered_quantity;

Because the view is small and unfiltered, it is inexpensive to query and safe to use in PL/SQL validation logic or as a lookup source in custom concurrent programs. It must not be treated as a substitute for the actual order-level partial-shipment attribute; it only supplies the domain of valid values.