Search Results returnable_flag

Overview

GMF_XLA_ITEMS_V is a PL/SQL view owned by the APPS schema within the Process Manufacturing Financials (GMF) product family. It is categorized as a Subledger Accounting (SLA) Accounting Data Repository (ADR) source view, specifically designed to extract item definition attributes from Oracle Inventory for use by the SLA engine. Because Process Manufacturing relies on item attributes to classify transactions, resolve accounting rules, and derive cost accounting entries, this view provides the ADR framework with a flattened, single-source projection of the item master organization and inventory organization relationships.

The view is relevant in both Oracle E-Business Suite 12.1.1 and 12.2.2. In 12.2.2, Subledger Accounting is the mandatory accounting engine, so ADR source views such as this are invoked during the Create Accounting process for GMF transactions. The view exposes a consistent set of item flags and control attributes that SLA can use in account derivation rules (ADRs) to determine which accounts, journals, or mapping sets apply to a given item or transaction.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through APPS synonyms:

• MTL_SYSTEM_ITEMS_B — The item master base table, which supplies the vast majority of columns in the view. All item attribute flags, status flags, source attributes, and item/organization keys (INVENTORY_ITEM_ID, ORGANIZATION_ID) originate from this table.
• MTL_PARAMETERS — The inventory organization parameters table. In many GMF and SLA item views, MTL_PARAMETERS is joined to derive organization-level defaults or validation context alongside the item attributes.

The view text operates primarily on MTL_SYSTEM_ITEMS_B, aliased as MSI, selecting item identifiers and enabled/attribute flags. Notably, ITEM_CONCATENATED_SEGMENTS is returned as NULL, because in typical MTL_SYSTEM_ITEMS_B definitions this concatenated value is supported by the _TL and _VL views rather than the base table; the view deliberately returns NULL to preserve the expected ADR column signature.

Key Columns

The view exposes a broad set of item control flags that SLA account derivation rules can reference:

• INVENTORY_ITEM_ID, ORGANIZATION_ID — Primary keys identifying the item and the inventory organization context.
• ITEM_CONCATENATED_SEGMENTS — Returned as NULL; retained for ADR column compatibility.
• PURCHASING_ITEM_FLAG, SHIPPABLE_ITEM_FLAG, CUSTOMER_ORDER_FLAG, INTERNAL_ORDER_FLAG, SERVICE_ITEM_FLAG, INVENTORY_ITEM_FLAG, ENG_ITEM_FLAG, INVENTORY_ASSET_FLAG — Core item usage and asset classification flags.
• PURCHASING_ENABLED_FLAG, CUSTOMER_ORDER_ENABLED_FLAG, INTERNAL_ORDER_ENABLED_FLAG, SO_TRANSACTIONS_FLAG, MTL_TRANSACTIONS_ENABLED_FLAG, STOCK_ENABLED_FLAG, BOM_ENABLED_FLAG, BUILD_IN_WIP_FLAG — Transaction enablement flags controlling whether the item participates in purchasing, sales order, inventory, BOM, or WIP activity.
• Additional flags such as CATALOG_STATUS_FLAG, RETURNABLE_FLAG, TAXABLE_FLAG, INSPECTION_REQUIRED_FLAG, RECEIPT_REQUIRED_FLAG, RFQ_REQUIRED_FLAG, ALLOW_SUBSTITUTE_RECEIPTS_FLAG, ALLOW_UNORDERED_RECEIPTS_FLAG, ALLOW_EXPRESS_DELIVERY_FLAG, MRP_CALCULATE_ATP_FLAG, REPETITIVE_PLANNING_FLAG, PICK_COMPONENTS_FLAG — these are wrapped in NVL(...,'N') or NVL(...,1) to normalize NULLs for ADR evaluation.
• SOURCE_TYPE, SOURCE_ORGANIZATION_ID, SOURCE_SUBINVENTORY — Sourcing attributes, with SOURCE_TYPE defaulting to 1 when NULL. The presence of SOURCE_SUBINVENTORY is directly relevant to searches involving the supply subinventory concept: it identifies the default supply subinventory configured on the item.
• BOM_ITEM_TYPE, ATP_COMPONENTS_FLAG — Bill of material item type classification and ATP component designation.

Common Use Cases and Queries

The view is most frequently consumed by SLA account derivation rules and by diagnostic queries that need an item-attribute projection aligned with the ADR column contract. Because the original user search referenced "wip_supply_subinventory," a common scenario is inspecting the supply subinventory configured for buildable or WIP-relevant items.

Example: retrieve WIP-enabled items and their sourcing information for an organization.

• SELECT inventory_item_id, organization_id, build_in_wip_flag, bom_enabled_flag, source_type, source_organization_id, source_subinventory
• FROM apps.gmf_xla_items_v
• WHERE organization_id = :org_id
• AND build_in_wip_flag = 'Y';

Example: identify items whose attributes feed a specific SLA account derivation rule, filtering on transaction enablement flags.

• SELECT inventory_item_id, stock_enabled_flag, mtl_transactions_enabled_flag, so_transactions_flag
• FROM apps.gmf_xla_items_v
• WHERE organization_id = :org_id
• AND inventory_item_flag = 'Y';

In 12.1.1 and 12.2.2, these queries assist in validating that the item definition data consumed by SLA is complete and consistent, particularly when accounting is failing to generate or when supply source attributes must be confirmed prior to WIP or process manufacturing transaction accounting.