Search Results aqui_cost_code

Overview

The PO_COST_MST table is a core master data table within the Process Manufacturing Logistics (GML) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the system of record for acquisition cost codes, which are fundamental to capturing and classifying the various costs associated with procuring materials and services. These predefined cost codes are essential for detailed cost distribution and analysis during the purchase order lifecycle, enabling granular financial tracking and accounting within a process manufacturing environment. The table's integrity is maintained through primary and unique key constraints, and it acts as a central reference point for numerous transactional tables via foreign key relationships.

Key Information Stored

While the full column list is not detailed in the provided metadata, the key identifiers and relationships are clearly defined. The primary key for the table is the AQUI_COST_ID, a unique internal identifier for each cost code record. A separate unique key constraint exists on the AQUI_COST_CODE, which is the user-defined, business-facing code or short name for the acquisition cost type (e.g., FREIGHT, DUTY, INSURANCE). Critical foreign key columns link this master data to other configuration entities, including ANALYSIS_CODE for cost analysis setups, CMPNTCLS_ID for component class definitions, and TEXT_CODE for associated descriptive text.

Common Use Cases and Queries

The primary use case for PO_COST_MST is to provide a validated list of allowable cost types for assignment to purchase order distributions. This ensures consistency in cost accounting and reporting. A common operational query involves fetching the active list of cost codes for a user interface LOV or for validating an inbound transaction. For reporting and analysis, the table is frequently joined to transactional details to summarize procurement costs by type.

• Basic Lookup: SELECT AQUI_COST_CODE, AQUI_COST_ID FROM GML.PO_COST_MST WHERE ... ORDER BY AQUI_COST_CODE;
• Cost Analysis Join: Queries often join PO_COST_MST to PO_COST_DTL or PO_DIST_DTL to aggregate costs from purchase orders, and further to CM_ALYS_MST for analytical reporting.

Related Objects

As indicated by the foreign key metadata, PO_COST_MST has significant integration across financial and procurement schemas. The table is directly referenced by key transactional tables, including PO_COST_DTL (detailed cost transactions) and PO_DIST_DTL (purchase order distributions). It is also linked to master data tables in the Cost Management (CM) module, specifically CM_ALYS_MST (analysis codes) and CM_CMPT_MST (component classes). The relationship with GL_ACCT_MAP is crucial, as it facilitates the mapping of a specific acquisition cost code to its corresponding General Ledger accounting flexfield, driving automated account generation. The PO_TEXT_HDR relationship allows descriptive text to be attached to a cost code definition.