Results for “po_cost_mst”

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

Overview

PO_COST_MST is the acquisition costs master table owned by the GML schema within the Oracle EBS Process Manufacturing Logistics (GML) product family. It stores the definition and header-level configuration of acquisition cost records used to capture landed, procurement-related cost components associated with purchased items and receipts. Each row represents a distinct acquisition cost entity, identified internally by a surrogate key and externally by a user-defined acquisition cost code. The table acts as the master reference for downstream cost distribution, accounting, and valuation processing.

In modeling terms, the metadata's heuristic Data Vault classification suggests PO_COST_MST leans toward a satellite role. This interpretation is consistent with the presence of descriptive attributes, foreign key lookups to reference masters, and audit columns, while the surrounding transactional tables (PO_COST_DTL, PO_DIST_DTL) and the accounting map (GL_ACCT_MAP) reference back to it as the anchor for acquisition cost identity.

Key Information Stored

• AQUI_COST_ID — surrogate primary key (PO_COST_MST_PK) uniquely identifying each acquisition cost record.
• AQUI_COST_CODE — business-key candidate enforced by unique index PO_COST_MST_U1; the human-readable acquisition cost code.
• AQUI_COST_DESC — descriptive text for the acquisition cost.
• CMPNTCLS_ID — component class identifier referencing CM_CMPT_MST_B and CM_CMPT_MST, linking the cost to a component classification.
• ANALYSIS_CODE — analysis code referencing CM_ALYS_MST, used for analytical or cost categorization (this is the column associated with the user's "cm_alys_mst" search).
• TEXT_CODE — reference to PO_TEXT_HDR, associating descriptive text blocks with the cost record.
• PRICE_ELEMENT_TYPE_ID — reference to PON_PRICE_ELEMENT_TYPES, categorizing the pricing element.
• INCL_IND — indicator controlling inclusion of the cost in applicable processing.
• TRANS_CNT — transaction counter associated with the record.
• DELETE_MARK — soft-delete flag used across EBS for logical deletion.
• MIGRATED_IND — indicator that the record originated from a migration routine.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns tracking who created and changed the record and when.

Common Use Cases and Queries

Typical usage centers on resolving acquisition cost definitions and joining them to their analytical, component, and accounting context. A common pattern joins the master to its detail and distribution tables:

SELECT m.aqui_cost_code, m.aqui_cost_desc, m.analysis_code, d.aqui_cost_id
FROM gml.po_cost_mst m, gml.po_cost_dtl d
WHERE m.aqui_cost_id = d.aqui_cost_id
AND m.delete_mark = 0;

Analysts frequently look up the analytical classification by joining to CM_ALYS_MST via ANALYSIS_CODE, and reconcile acquisition costs to accounting via GL_ACCT_MAP on AQUI_COST_ID. Reporting scenarios include listing all active acquisition costs, validating that each cost has a corresponding component class, and auditing which costs have been migrated (MIGRATED_IND) versus created natively. Suppliers and receipts reconciliation reports leverage PO_DIST_DTL joined on AQUI_COST_ID to verify cost distribution. Interface monitoring uses CM_APCM_INT and CM_APCM_MST_EFC to confirm acquisition cost records flow correctly into process manufacturing costing.

Related Objects

• PO_COST_DTL — detail lines; joins on AQUI_COST_ID.
• PO_DIST_DTL — cost distribution detail; joins on AQUI_COST_ID.
• GL_ACCT_MAP — accounting flexfield mapping; joins on AQUI_COST_ID.
• CM_ALYS_MST — analysis master referenced by ANALYSIS_CODE.
• CM_CMPT_MST_B / CM_CMPT_MST — component class masters referenced by CMPNTCLS_ID.
• PO_TEXT_HDR — text header referenced by TEXT_CODE.
• PON_PRICE_ELEMENT_TYPES — price element types referenced by PRICE_ELEMENT_TYPE_ID.
• GMF_XLA_EXTRACT_LINES / GMF_XLA_EXTRACT_LINES_GT — SLA extract tables referencing AQUI_COST_ID.
• CM_APCM_MST_EFC / CM_APCM_INT — process manufacturing acquisition cost masters and interfaces.
• GML_PO_MIG_ERRORS, CPG_COST_DTL — migration error and cost detail tables referencing AQUI_COST_ID.