Results for “cost_mthd_code”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMF_LOT_COST_BURDENS_V is an APPS-owned database view in Oracle E-Business Suite (validated in 12.1.1 and 12.2.2) belonging to the Process Manufacturing Financials (GMF) product family. It is the queryable data source behind the Lot Cost Burdens form, presenting lot-level cost burden records enriched with item, cost method, and fiscal policy context. Rather than exposing raw transaction rows, the view joins lot burden detail to the organizational and legal-entity configuration needed to determine the reporting currency, so that cost burden amounts can be presented in the correct base currency for each organization.

Because it is a view rather than a table, it carries no storage of its own and reflects the current state of its underlying tables at query time. It is used primarily for inquiry, reporting, and integration extracts rather than for transactional data entry, which occurs against the underlying GMF_LOT_COST_BURDENS table.

Underlying Base Objects

The view is defined over five principal sources, all referenced through APPS synonyms:

  • GMF_LOT_COST_BURDENS (DTL) — the transaction-level lot cost burden detail, supplying organization, item, cost type, and lot number.
  • CM_MTHD_MST (MTHD) — the cost method master, joined on COST_TYPE_ID to supply the cost method code and description.
  • GMF_FISCAL_POLICIES (GFP) — the fiscal policy definition that supplies the BASE_CURRENCY_CODE for the legal entity.
  • MTL_ITEM_FLEXFIELDS / MTL_SYSTEM_ITEMS (ITEM) — item master attributes such as item number, description, and primary unit of measure.
  • ORG_ORGANIZATION_DEFINITIONS (OOD) — organization and legal-entity mapping, which links the operating organization to its fiscal policy and therefore its base currency.

The documented dependency list also records HR_GENERAL and HR_SECURITY packages, reflecting the standard Oracle security model used by the underlying organization definitions. The join path from ORG_ORGANIZATION_DEFINITIONS to GMF_FISCAL_POLICIES (via LEGAL_ENTITY to LEGAL_ENTITY_ID) is what establishes the base currency for each row. The query uses SELECT DISTINCT, so duplicate combinations across the joined sources are collapsed.

Key Columns

Common Use Cases and Queries

Typical uses include lot cost burden inquiry, currency-aware cost reporting, and feeding downstream analysis in the organization's base currency. A representative query filters by organization and item:

SELECT organization_id, inventory_item_id, item_number,
       cost_mthd_code, base_currency, lot_number
FROM   apps.gmf_lot_cost_burdens_v
WHERE  organization_id = :org_id
AND    inventory_item_id = :item_id;

To review burdens by currency, group on BASE_CURRENCY. Always qualify the view with APPS and apply organization security consistent with the HR security model referenced by the object.