Results for “ship_model_complete_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OE_AK_INVENTORY_ITEMS_V is a read-only view owned by the APPS schema and classified under the ONT (Order Management) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is an Oracle ETRM (E-Business Suite Technical Reference Manual) documented object with status VALID. The view presents a denormalized, reporting-oriented projection of inventory item attributes that are relevant to order capture, order fulfillment, and order management processing. Because the view resolves the master organization context internally, it allows downstream reports, concurrent programs, and integrations to retrieve order-management-relevant item attributes without manually joining item master tables or resolving the master organization identifier.
Underlying Base Objects
The view is defined over two referenced base objects as documented in the 12.2.2 ETRM metadata: MTL_SYSTEM_ITEMS (exposed through a synonym) and the OE_SYS_PARAMETERS package. In the view text, MTL_SYSTEM_ITEMS is aliased twice — once as A and once as B — and the two aliases are joined on INVENTORY_ITEM_ID. Alias A supplies the master-level (organization-independent) item attributes, while alias B supplies organization-level attributes such as DEFAULT_SO_SOURCE_TYPE and CHARGE_PERIODICITY_CODE. The join is constrained so that A.ORGANIZATION_ID equals the master organization identifier returned by OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'). Consequently, the view returns one row per inventory item, fixed to the master organization, with the second alias providing organization-specific defaults for the same item.
Key Columns
The view exposes twenty columns. The most significant include:
- INVENTORY_ITEM_ID — primary identifier of the inventory item, used to join to other item-related objects.
- ORGANIZATION_ID — the organization context (from alias B) associated with the returned item attributes.
- DEFAULT_SHIPPING_ORG — the default shipping organization used when the item is placed on an order; this is the column most commonly targeted by users searching for default shipping organization behavior.
- INVOICING_RULE_ID / ACCOUNTING_RULE_ID — default invoicing and accounting rules applied to the item during order and billing processing.
- SHIP_MODEL_COMPLETE_FLAG, BUILD_IN_WIP_FLAG, BOM_ITEM_TYPE, REPLENISH_TO_ORDER_FLAG, PICK_COMPONENTS_FLAG — order fulfillment and manufacturing-related flags governing configuration, WIP build, bills of material, and pick behavior.
- PRIMARY_UOM_CODE — the primary unit of measure of the item.
- OVER_SHIPMENT_TOLERANCE, UNDER_SHIPMENT_TOLERANCE, OVER_RETURN_TOLERANCE, UNDER_RETURN_TOLERANCE — quantity tolerance percentages applied to shipment and return transactions.
- PAYMENT_TERMS_ID — default payment terms associated with the item.
- DEFAULT_SO_SOURCE_TYPE, CHARGE_PERIODICITY_CODE — organization-level default sales order source type and service charge periodicity.
- SERVICE_DURATION_PERIOD_CODE, SERVICE_DURATION — service duration attributes for service-enabled items.
Common Use Cases and Queries
OE_AK_INVENTORY_ITEMS_V is typically used in reports and integrations that require item-level order management defaults without repeating the master organization lookup. Common scenarios include extracting default shipping organization assignments, auditing shipment and return tolerances, and validating invoicing or accounting rule defaults.
A representative query retrieving the default shipping organization for an item is:
SELECT inventory_item_id, organization_id, default_shipping_org FROM apps.oe_ak_inventory_items_v WHERE inventory_item_id = :p_item_id;
To review tolerance settings for order management validation:
SELECT inventory_item_id, over_shipment_tolerance, under_shipment_tolerance, over_return_tolerance, under_return_tolerance FROM apps.oe_ak_inventory_items_v;
Because the underlying filter hard-codes the master organization through OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'), the view cannot be used to retrieve attributes for arbitrary organizations; it is intended specifically for master-level item lookups used by Order Management functionality. Note that the ETRM column listing shows PAYMENT_TERM_ID and SOURCE_TYPE_CODE, while the view text uses PAYMENT_TERMS_ID and DEFAULT_SO_SOURCE_TYPE respectively; consumers should reference the view definition or ALL_TAB_COLUMNS to confirm exact column names for their patch level.
-
APPS.OE_AK_INVENTORY_ITEMS_V·↳ MTL_SYSTEM_ITEMS·↳ OE_SYS_PARAMETERS·Explore ONT module →
-
View: WSH_SS_SHIPITEMS_V 12.2.2
APPS.WSH_SS_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
APPS.OE_AK_INVENTORY_ITEMS_V·↳ MTL_SYSTEM_ITEMS·↳ OE_SYS_PARAMETERS·Explore ONT module →
-
View: WSH_ITM_SHIPITEMS_V 12.2.2
Temporary Table to return WSH_SS_SHIPITEMS_V along with Dummy Records to avoid problems in Retreiving Data while using XSU.
APPS.WSH_ITM_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
APPS.WSH_DELIVERY_DETAILS_OB_GRP_V·↳ WSH_DELIVERY_DETAILS·Explore WSH module →
-
View: MTL_ITEM_FLEXFIELDS 12.1.1
This view is based on the key flexfield view MTL_SYSTEM_ITEMS_B_KFV. It contains columns with padded and unpadded concatenated segments of an item number.
APPS.MTL_ITEM_FLEXFIELDS·↳ MTL_SYSTEM_ITEMS_B_KFV·Explore INV module →
-
View: PJM_UEFF_SO_LINES_V 12.2.2
APPS.PJM_UEFF_SO_LINES_V·↳ SO_LINES_ALL·Explore PJM module →
-
APPS.CST_XLA_INV_SYSTEM_ITEMS_REF_V·↳ CST_ITEM_COSTS·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS·Explore BOM module →
-
View: OE_LINE_ACKS_V 12.1.1
Information about the acknowledgements for Order Lines
-
View: MTL_SYSTEM_ITEMS_B_KFV 12.1.1
System Items Key Flexfield View
APPS.MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_B·Explore INV module →
-
View: OE_LINE_ACKS_V 12.2.2
Information about the acknowledgements for Order Lines
-
APPS.ASO_PVT_QUOTE_LINES_BALI_V·↳ ASO_LINE_NUM_INT·↳ ASO_PVT_QUOTE_LINES_NUM_V·↳ FND_PROFILE·Explore ASO module →
-
View: WSH_DSNO_ITEMS_COMM_V 12.2.2
APPS.WSH_DSNO_ITEMS_COMM_V·↳ MTL_COMMODITY_CODES·↳ MTL_CUSTOMER_ITEMS·↳ MTL_ITEM_FLEXFIELDS·Explore WSH module →
-
APPS.WSH_OPSM_ASN_ITEMS_COMM_V·↳ MTL_COMMODITY_CODES·↳ MTL_CROSS_REFERENCES_VL·↳ MTL_CUSTOMER_ITEMS·Explore WSH module →
-
View: MTL_CLIENT_ITEMS_VL 12.2.2
APPS.MTL_CLIENT_ITEMS_VL·↳ MTL_CLIENT_PARAMETERS_V·↳ MTL_SYSTEM_ITEMS_VL·Explore INV module →
-
APPS.WSH_DLVY_DELIVERABLES_V·↳ WSH_DELIVERY_ASSIGNMENTS·↳ WSH_DELIVERY_DETAILS·↳ WSH_LOOKUPS·Explore WSH module →
-
View: OE_MTL_SYSTEM_ITEMS_V 12.1.1
No longer used
APPS.OE_MTL_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS·Explore ONT module →
-
APPS.ASO_PVT_QUOTE_LINES_BALI_V·↳ ASO_LINE_NUM_INT·↳ ASO_PVT_QUOTE_LINES_NUM_V·↳ FND_PROFILE·Explore ASO module →
-
View: WSH_DELIVERABLES_V 12.1.1
APPS.WSH_DELIVERABLES_V·↳ FND_LOOKUP_VALUES·↳ WMS_LICENSE_PLATE_NUMBERS·↳ WSH_DELIVERY_ASSIGNMENTS·Explore WSH module →
-
View: OE_CRM_ORDER_LINES_V 12.1.1
Compatible view provoded for CRM usage only. The view is based on oe_order_lines_all table.
APPS.OE_CRM_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ONT module →
-
View: WSH_DSNO_ITEMS_COMM_V 12.1.1
APPS.WSH_DSNO_ITEMS_COMM_V·↳ MTL_COMMODITY_CODES·↳ MTL_CUSTOMER_ITEMS·↳ MTL_ITEM_FLEXFIELDS·Explore WSH module →
-
View: CLN_WSH_SS_SHIPITEMS_V 12.1.1
View of delivery line details
APPS.CLN_WSH_SS_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore CLN module →
-
View: OE_CRM_ORDER_LINES_V 12.2.2
Compatible view provoded for CRM usage only. The view is based on oe_order_lines_all table.
APPS.OE_CRM_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ONT module →
-
View: CLN_WSH_SS_SHIPITEMS_V 12.2.2
View of delivery line details
APPS.CLN_WSH_SS_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore CLN module →
-
View: ASO_I_OE_ORDER_LINES_V 12.1.1
This view includes all columns from the Oracle Order Management order lines tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ASO module →
-
APPS.WSH_DELIVERY_DETAILS_OB_GRP_V·↳ WSH_DELIVERY_DETAILS·Explore WSH module →
-
View: BOM_LINES_VIEW 12.1.1
Order lines - used by delete constraints
-
View: MTL_SYSTEM_ITEMS_VL 12.2.2
System Items multilingual view with concatenated segments column
APPS.MTL_SYSTEM_ITEMS_VL·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →
-
View: OKX_ORDER_LINES_V 12.1.1
Order line information
APPS.OKX_ORDER_LINES_V·↳ ASO_ORDER_INT·↳ OE_ORDER_LINES_ALL·Explore OKX module →
-
View: OE_MRP_OPEN_DEMANDS_V 12.1.1
This vew is used by MRP for their Scheduler's Workbench.
APPS.OE_MRP_OPEN_DEMANDS_V·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_ALL·↳ OE_SETS·Explore ONT module →
-
View: OE_MRP_OPEN_DEMANDS_V 12.2.2
This vew is used by MRP for their Scheduler's Workbench.
APPS.OE_MRP_OPEN_DEMANDS_V·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_ALL·↳ OE_SETS·Explore ONT module →
-
View: GMF_XLA_ITEMS_V 12.1.1
View for SLA ADR sources from Item Definition
APPS.GMF_XLA_ITEMS_V·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS_B·Explore GMF module →
-
View: OE_ORDER_LINES_HIST_V 12.1.1
APPS.OE_ORDER_LINES_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
APPS.CST_XLA_INV_SYSTEM_ITEMS_REF_V·↳ CST_ITEM_COSTS·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS·Explore BOM module →
-
View: PJM_UEFF_SO_LINES_V 12.1.1
APPS.PJM_UEFF_SO_LINES_V·↳ SO_LINES_ALL·Explore PJM module →
-
View: WSH_SS_SHIPITEMS_V 12.1.1
APPS.WSH_SS_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
View: WSH_ITM_SHIPITEMS_V 12.1.1
Temporary Table to return WSH_SS_SHIPITEMS_V along with Dummy Records to avoid problems in Retreiving Data while using XSU.
APPS.WSH_ITM_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
Table to store picking line details information during upgrade from 11 to 11i
-
Table to store picking line details information during upgrade from 11 to 11i
-
View: OE_MTL_SYSTEM_ITEMS_V 12.2.2
No longer used
APPS.OE_MTL_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS·Explore ONT module →
-
View: OE_ORDER_LINES_AUDIT_V 12.1.1
APPS.OE_ORDER_LINES_AUDIT_V·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_HISTORY·↳ OE_REASONS·Explore ONT module →
-
View: OE_ORDER_LINES_AUDIT_V 12.2.2
APPS.OE_ORDER_LINES_AUDIT_V·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_HISTORY·↳ OE_REASONS·Explore ONT module →
-
View: MTL_SYSTEM_ITEMS_B_KFV 12.2.2
System Items Key Flexfield View
APPS.MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_B·Explore INV module →
-
View: OE_DELIVERY_LINES_V 12.2.2
This view is for interfacing the lines to shipping, for departure planning.
APPS.OE_DELIVERY_LINES_V·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS·↳ OE_ORDER_HEADERS_ALL·Explore ONT module →
-
View: ASO_I_OE_ORDER_LINES_V 12.2.2
This view includes all columns from the Oracle Order Management order lines tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ASO module →
-
View: OKX_ORDER_LINES_V 12.2.2
Order line information
APPS.OKX_ORDER_LINES_V·↳ ASO_ORDER_INT·↳ OE_ORDER_LINES_ALL·Explore OKX module →
-
View: BOM_LINES_VIEW 12.2.2
Order lines - used by delete constraints
-
ASO_QUOTE_LINES_ALL stores information for a typical quote or an order line
-
View: GMF_XLA_ITEMS_V 12.2.2
View for SLA ADR sources from Item Definition
APPS.GMF_XLA_ITEMS_V·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS_B·Explore GMF module →