Results for “cst_pac_ael_sl_inv_v”

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

Overview

CST_PAC_AEL_SL_INV_V is a subledger accounting view owned by the APPS schema in Oracle E-Business Suite, delivered under the BOM (Bills of Material) product family. It exposes the inventory transaction accounting activity generated by the Process Costing / Periodic Average Costing (PAC) accounting engine and presents it in the column layout expected by the Oracle Subledger Accounting (SLA) architecture for the Inventory application. Specifically, this view is a Subledger (SL) view that joins costed inventory material transactions to their corresponding accounting event lines, allowing the Create Accounting program and related reporting utilities to transfer inventory accounting entries into General Ledger via SLA.

In 12.1.1 and 12.2.2 the view is registered as VALID and is referenced during the SLA accounting creation cycle for inventory transactions. It is not a transactional base table view; rather, it is a reporting and integration view that consolidates header-level accounting events, accounting lines, cost group definitions, cost types, and material transaction details into a single denormalized result set.

Underlying Base Objects

The view is defined over a substantial set of synonyms and views, documented in the ETRM metadata as follows:

• Accounting event and line sources: CST_AE_HEADERS, CST_PAC_AE_LINES_V (the PAC accounting lines view), and CST_COST_ELEMENTS.
• Costing configuration: CST_COST_GROUPS, CST_COST_GROUP_ASSIGNMENTS, CST_COST_TYPES, CST_LE_COST_TYPES.
• Inventory transaction data: MTL_MATERIAL_TRANSACTIONS, MTL_TRANSACTION_TYPES, MTL_TXN_SOURCE_TYPES, MTL_TRANSACTION_REASONS, MTL_ITEM_LOCATIONS.
• Reference and lookup data: MFG_LOOKUPS, GL_DAILY_CONVERSION_TYPES, ORG_ORGANIZATION_DEFINITIONS, HR_GENERAL, HR_SECURITY.

The join path anchors on the accounting header (CST_AE_HEADERS) linked to the accounting lines view (CST_PAC_AE_LINES_V) via the AE header ID, which is then joined to MTL_MATERIAL_TRANSACTIONS on transaction ID. Cost group and cost type assignments are resolved through CST_COST_GROUP_ASSIGNMENTS and CST_COST_TYPES respectively. HR_GENERAL and HR_SECURITY packages supply organization-level security enforcement and descriptive context.

Key Columns

• LEGAL_ENTITY, SET_OF_BOOKS_ID: the ledger and legal entity context for the accounting entry.
• COST_GROUP_ID, COST_GROUP, COST_TYPE_ID, COST_TYPE, PRIMARY_COST_METHOD: identify the costing structure under which the inventory movement was costed.
• ORGANIZATION_ID, ORGANIZATION_CODE: the inventory organization that owns the transaction.
• TRANSACTION_ID, TRANSACTION_TYPE_ID, TRANSACTION_TYPE_NAME, TRANSACTION_DATE, TRANSACTION_REFERENCE, TRANSACTION_QUANTITY, TRANSACTION_UOM, SUBINVENTORY_CODE, LOCATOR_ID: the material transaction attributes.
• AE_LINE_TYPE_CODE, CODE_COMBINATION_ID, CURRENCY_CODE, ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR: the accounting line amounts in both entered and functional currency.
• CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE: foreign currency conversion details.
• GL_SL_LINK_ID, GL_TRANSFER_RUN_ID: indicators of whether the line has been transferred to GL and identification of the transfer run.
• INVENTORY_ITEM_ID, REVISION, COST_ELEMENT, REASON_NAME, TRANSACTION_SOURCE_TYPE_NAME: item, cost element, and transaction reason context.

Common Use Cases and Queries

The view is commonly queried for inventory accounting reconciliation, SLA transfer auditing, and cost element analysis. Because the definition carries the hint /*+ PUSH_PRED(CAL)*/, performance-conscious queries should filter on accounting line columns such as TRANSACTION_DATE, ORGANIZATION_ID, or SET_OF_BOOKS_ID so that the predicate can be pushed into the underlying CST_PAC_AE_LINES_V access path.

Typical query patterns include:

• Listing untransferred accounting lines: SELECT TRANSACTION_ID, ACCOUNTED_DR, ACCOUNTED_CR FROM CST_PAC_AEL_SL_INV_V WHERE GL_SL_LINK_ID = -1;
• Summarizing accounting by cost element and organization for a period.
• Reconciling MTL_MATERIAL_TRANSACTIONS against GL entries using GL_TRANSFER_RUN_ID.

Because the view joins large transaction and accounting line sets, queries should always include organization, ledger, or date range predicates to avoid full scans across the underlying SLA and inventory transaction tables.