Results for “gl_item_dtl”

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

Overview

GL_ITEM_DTL is a Process Manufacturing Financials (GMF) table that stores cost component detail information for an item. It functions as the granular breakdown layer behind the accounting cost held in GL_ITEM_CST: whereas GL_ITEM_CST carries the summarized accounting cost for an item, GL_ITEM_DTL decomposes that cost into its individual cost components, cross-referenced to the cost component class and cost analysis definitions maintained in the CM_CMPT_MST / CM_CMPT_MST_B and CM_ALYS_MST tables. The object resides in the GMF schema and is marked VALID in the ETRM 12.2.2 repository, with 15 documented columns.

Under the heuristic Data Vault classification mined from its foreign key structure, GL_ITEM_DTL is best modeled as a link table. Its primary key is a composite of business identifiers rather than a single surrogate, and it connects an item cost record (GL_ITEM_CST) to cost component and cost analysis master entities. This classification is a modeling suggestion only; the physical table is a standard Oracle EBS transactional detail table carrying the usual WHO/audit columns.

Key Information Stored

The composite primary key GL_ITEM_DTL_PK is defined on ITEMCOST_ID, COST_CMPNTCLS_ID, and COST_ANALYSIS_CODE. The unique index documented for 12.2.2, GL_ITEM_DTL_PK, further qualifies the business key with COST_LEVEL, making the full unique combination ITEMCOST_ID, COST_CMPNTCLS_ID, COST_ANALYSIS_CODE#1, and COST_LEVEL. The most important columns are:

• ITEMCOST_ID — foreign key to GL_ITEM_CST; identifies the parent item cost record to which this component detail belongs.
• COST_CMPNTCLS_ID — foreign key to CM_CMPT_MST and CM_CMPT_MST_B; identifies the cost component class (for example, material, resource, or overhead) that the detail amount represents.
• COST_ANALYSIS_CODE — foreign key to CM_ALYS_MST; identifies the cost analysis definition governing how the component is analyzed.
• CMPTCOST_AMT — the cost amount attributed to the component, populated for each row of the component breakdown.
• COST_LEVEL — the cost level at which the component is recorded; participates in the unique key.
• COST_ANALYSIS_CODE#1 — the alternate/qualified form of COST_ANALYSIS_CODE that appears in the documented 12.2.2 column list and unique index.
• DELETE_MARK — the standard Oracle EBS soft-delete flag; rows must be filtered on DELETE_MARK = 0 in queries.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the WHO audit columns tracking row creation and last modification.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — the standard concurrent program context columns identifying the request and program that inserted or last updated the row.

Common Use Cases and Queries

The most frequent access pattern is to retrieve the component-level cost build-up for a given item cost record. A representative query joins the detail to its parent and to the component master:

SELECT d.ITEMCOST_ID, d.COST_CMPNTCLS_ID, d.COST_ANALYSIS_CODE, d.CMPTCOST_AMT, d.COST_LEVEL
FROM GMF.GL_ITEM_DTL d
WHERE d.ITEMCOST_ID = :itemcost_id
AND d.DELETE_MARK = 0
ORDER BY d.COST_LEVEL, d.COST_CMPNTCLS_ID;

Reporting use cases include cost component variance analysis (comparing CMPTCOST_AMT by component class across cost levels), process manufacturing cost roll-up reconciliation (summing GL_ITEM_DTL amounts and tying them back to the accounting cost in GL_ITEM_CST), and audit tracing of the concurrent program that produced or modified the component rows using PROGRAM_ID and REQUEST_ID. Because the table is a detail layer, aggregations should always be grouped by the full business key to avoid double counting when multiple cost analysis codes or cost levels coexist for the same item cost.

Related Objects

• GL_ITEM_CST — parent cost table; GL_ITEM_DTL.ITEMCOST_ID references GL_ITEM_CST. This is the primary join for obtaining the parent item cost and reconciling detail to accounting cost.
• CM_CMPT_MST — cost component class master; GL_ITEM_DTL.COST_CMPNTCLS_ID references CM_CMPT_MST for component class definitions.
• CM_CMPT_MST_B — the base/translation variant of the cost component class master; the same COST_CMPNTCLS_ID column also references this table.
• CM_ALYS_MST — cost analysis master; GL_ITEM_DTL.COST_ANALYSIS_CODE references this table to resolve the analysis definition.
• GL_ITEM_DTL_PK — the composite primary key and unique index (ITEMCOST_ID, COST_CMPNTCLS_ID, COST_ANALYSIS_CODE#1, COST_LEVEL) enforcing uniqueness of the component detail rows.

Together these objects form the cost component chain: item cost (GL_ITEM_CST) to component detail (GL_ITEM_DTL), resolved through the cost component class and cost analysis masters.