Results for “subinv_locator_type”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GMF_XLA_SUBINV_V is a public APPS view in Oracle E-Business Suite that exposes subinventory definition attributes for consumption by the Subledger Accounting (SLA) Accounting Derivation Rules (ADR) and Journal Line Definition framework. It is owned by the APPS schema and registered in ETRM as a VALID object belonging to the GMF – Process Manufacturing Financials product family. The view derives its data from the Oracle Inventory subinventory master, which is why the user search term "subinventory_type" resolves here: SUBINVENTORY_TYPE is one of the driveable attributes surfaced by this view for accounting rule evaluation.
In Oracle EBS 12.1.1 and 12.2.2, the SLA ADR engine maps transactional context to accounting attributes through source views. GMF_XLA_SUBINV_V provides the subinventory-level context — subtype, locator type, asset flag, and the full set of default accounts — so that accounting rules can conditionally derive expense, material, overhead, resource, OSP, and encumbrance accounts without joining directly to MTL_SECONDARY_INVENTORIES in custom rule logic. This encapsulation makes it easier to extend or override default account derivation while remaining upgrade-safe.
Underlying Base Objects
Per the documented ETRM metadata, the only referenced base object is MTL_SECONDARY_INVENTORIES (accessed via a SYNONYM in the APPS schema). The view text is a single flat SELECT with no joins, UNIONs, or aggregates, aliasing the source table as SUBINV. This simplicity is intentional: the view is a projection/filter shim that renames columns into SLA-friendly source names. Because MTL_SECONDARY_INVENTORIES is the authoritative subinventory definition table in Oracle Inventory, any change made to the subinventory (subtype, locator control, asset flag, or default account assignments) is immediately visible through this view — there is no materialization or caching.
Key Columns
- ORGANIZATION_ID / SUBINV_ORGANIZATION_ID – Both map to the same ORGANIZATION_ID column; the duplicate name supports SLA source definition aliasing.
- SUBINVENTORY_CODE – Originates from SECONDARY_INVENTORY_NAME, identifying the subinventory.
- SUBINV_ASSET_FLAG – DECODE of ASSET_INVENTORY: 'Y' when the asset flag equals 1, otherwise 'N'.
- SUBINVENTORY_TYPE – The raw SUBINVENTORY_TYPE value from the source table (e.g., STORAGE, RECEIVING).
- SUBINV_LOCATOR_TYPE – The LOCATOR_TYPE controlling locator validation.
- SUBINV_EXPENSE_ACCOUNT, SUBINV_MATERIAL_ACCOUNT, SUBINV_MATERIAL_OVH_ACCOUNT, SUBINV_RESOURCE_ACCOUNT, SUBINV_OVERHEAD_ACCOUNT, SUBINV_OSP_ACCOUNT, SUBINV_ENCUMBRANCE_ACCOUNT – Default account segments for expense, material, material overhead, resource, overhead, outside processing, and encumbrance, respectively.
Common Use Cases and Queries
The primary use case is authoring or debugging SLA accounting derivation rules that branch on subinventory attributes. Analysts frequently query this view to enumerate subinventory types and account assignments before writing an ADR.
- List subinventories by type and asset status.
- Return default accounts for a specific subinventory to compare against SLA-derived postings.
- Filter by SUBINV_ASSET_FLAG to separate asset (storable) from non-asset (expense) subinventories.
Sample SQL:
SELECT organization_id, subinventory_code, subinventory_type, subinv_asset_flag, subinv_locator_type, subinv_material_account, subinv_expense_account
FROM apps.gmf_xla_subinventory_v
WHERE organization_id = :org_id
AND subinventory_type = 'STORAGE';
Because the view already exposes SLA-oriented naming, it can be referenced in custom ADR source queries or diagnostic reports without additional joins. Confirm grants to the calling schema when using it outside the APPS or GMF application users, and note that no row-level security (MOAC) is applied here — organization filtering must be supplied explicitly.
-
View: GMF_XLA_SUBINV_V 12.2.2
View for SLA ADR sources from Subinventory definition
APPS.GMF_XLA_SUBINV_V·↳ MTL_SECONDARY_INVENTORIES·Explore GMF module →
-
View: GMF_XLA_SUBINV_V 12.1.1
View for SLA ADR sources from Subinventory definition
APPS.GMF_XLA_SUBINV_V·↳ MTL_SECONDARY_INVENTORIES·Explore GMF module →
-
View: WIP_PARAMETERS_V 12.2.2
Foreign-key data for WIP_PARAMETERS
APPS.WIP_PARAMETERS_V·↳ CST_COST_TYPES·↳ MFG_LOOKUPS·↳ MTL_ATP_RULES·Explore WIP module →
-
View: WIP_PARAMETERS_V 12.1.1
Foreign-key data for WIP_PARAMETERS
APPS.WIP_PARAMETERS_V·↳ CST_COST_TYPES·↳ MFG_LOOKUPS·↳ MTL_ATP_RULES·Explore WIP module →
-
VIEW: APPS.GMF_XLA_SUBINV_V 12.2.2
-
VIEW: APPS.GMF_XLA_SUBINV_V 12.1.1
-
VIEW: APPS.GMF_XLA_SUBINV_V 12.1.1
-
VIEW: APPS.GMF_XLA_SUBINV_V 12.2.2
-
VIEW: APPS.WIP_PARAMETERS_V 12.1.1
-
VIEW: APPS.WIP_PARAMETERS_V 12.2.2
-
VIEW: APPS.WIP_PARAMETERS_V 12.1.1
-
VIEW: APPS.WIP_PARAMETERS_V 12.2.2
-
eTRM - GMF Tables and Views 12.2.2
Defines Third-Party software which has a supported interface to OPM.
-
eTRM - GMF Tables and Views 12.1.1
Defines Third-Party software which has a supported interface to OPM.
-
eTRM - WIP Tables and Views 12.1.1
-
eTRM - WIP Tables and Views 12.2.2