Search Results mp_mst

Overview

APPS.GMF_XLA_ORG_PARAMETERS_V is an Oracle E-Business Suite view that exposes organization-level inventory and costing parameters used by the Subledger Accounting (XLA) and Process Manufacturing (GMF/OPM) engines. The view is defined in the APPS schema and presents a consolidated, filter-ready list of inventory organizations that are enabled for process manufacturing, together with their primary financial accounting references and descriptive flexfield attributes. Its role is to support Subledger Accounting event processing, cost accounting, and reporting by providing a single source for the accounting accounts and organization characteristics that XLA derivations require when generating journal entries for process manufacturing transactions.

The view is particularly relevant to integration and reporting workstreams because it normalizes several frequently referenced organization attributes—most notably the consigned inventory indicator—into a predictable form, and because it restricts its output to organizations where the process-enabled flag is set to 'Y'.

Underlying Base Objects

The view is defined exclusively over MTL_PARAMETERS (referenced through a SYNONYM in the APPS schema). The defining query joins MTL_PARAMETERS to itself using two aliases:

• mp1 — the primary organization row, supplying the organization identifier, code, accounts, and descriptive flexfield attributes.
• mp_mst — an inline subquery that returns the organization_id and organization_code of the master organization for each organization, resolved where organization_id equals master_organization_id.

The join between mp1 and mp_mst is performed on mp1.master_organization_id = mp_mst.organization_id. The final WHERE clause restricts the result set to rows where mp1.process_enabled_flag = 'Y', meaning only process-manufacturing-enabled inventory organizations appear.

Key Columns

• organization_id / organization_code — Identifier and code of the process-enabled inventory organization.
• master_organization_code — Code of the organization's master organization, resolved from the self-join.
• consigned_flag — Consigned inventory indicator, wrapped in NVL(...,'N') so that a null underlying value is reported as 'N'. This is the column matched by the search term "consigned_flag" and is central to identifying organizations handling consigned inventory.
• wms_enabled_flag — Warehouse Management System enablement indicator, similarly defaulted to 'N'.
• Accounting account columns — org_param_ppv_account, org_param_ap_accrual_account, org_param_itr_account, org_param_ior_account, org_param_iop_account, org_param_cogs_account, org_param_xfer_credit_account, org_param_ipv_account, org_param_expense_account, org_param_distr_account_id, and org_param_dcogs_account, each mapped from the corresponding MTL_PARAMETERS account columns.
• inventory organization descriptive flexfield — inv_org_attribute_category plus inv_org_attribute1 through inv_org_attribute15, exposing the organization-level DFF segments for reporting and derivation use.

Common Use Cases and Queries

Typical uses include validating which process organizations are configured for consigned inventory, retrieving the accounting account set for a given organization before XLA event processing, and joining organization attributes to inventory or costing transactions.

SELECT organization_id,
       organization_code,
       master_organization_code,
       consigned_flag,
       wms_enabled_flag
  FROM apps.gmf_xla_org_parameters_v
 WHERE consigned_flag = 'Y';

To obtain the full accounting parameter set for a specific organization:

SELECT organization_code,
       org_param_cogs_account,
       org_param_ppv_account,
       org_param_ipv_account,
       org_param_expense_account
  FROM apps.gmf_xla_org_parameters_v
 WHERE organization_id = :p_org_id;

The view also serves as a convenient lookup for the master organization relationship and for surfacing descriptive flexfield context values when building custom subledger or reporting logic.