Search Results gl_sl_link_id

Overview

CST_PAC_AE_LINES_V is a reporting view owned by the APPS schema in Oracle EBS 12.1.1 and 12.2.2. It belongs to the BOM (Bills of Material) product family and is part of the Cost Management accounting/encumbrance extraction layer. The view presents a consolidated, uniform projection of accounting entry lines and encumbrance entry lines used by the Cost Management subledger for transfer to General Ledger (GL). Its core purpose is to present both actual accounting lines and encumbrance lines through a single, consistent column structure so that downstream reporting, reconciliation, and subledger-to-GL transfer processes do not need to query two separate sources.

The view carries an AE_LINE_ID attribute as its first projected column, which is the identifier most commonly referenced by users and interfaces searching on this object. This makes the view a convenient access point when an application or report needs to resolve an accounting entry line regardless of whether it originated as a standard accounting line or an encumbrance line.

Underlying Base Objects

The view is defined over two documented base objects, both exposed in the APPS schema as synonyms:

• CST_AE_LINES — stores standard Cost Management accounting entry lines.
• CST_ENCUMBRANCE_LINES — stores encumbrance accounting entry lines.

CST_PAC_AE_LINES_V is implemented as a UNION ALL of these two sources. In the first branch, AE_LINE_ID is selected from CST_AE_LINES and a literal constant 'A' is appended as a discriminator column at the end of the select list, denoting an accounting line. In the second branch, ENCUMBRANCE_LINE_ID is selected into the same AE_LINE_ID position, drawn from CST_ENCUMBRANCE_LINES, with a literal 'E' discriminator appended, denoting an encumbrance line. Because the view is a union of two physically distinct tables, the AE_LINE_ID values are only unique within their originating source; the discriminator is therefore essential to disambiguate rows. The remaining columns are positionally aligned across both branches so that the union remains structurally valid.

Key Columns

The view exposes the full accounting entry line structure shared by both sources. Principal columns include:

• AE_LINE_ID — the line identifier (sourced from AE_LINE_ID or ENCUMBRANCE_LINE_ID). Serialized by the trailing discriminator column.
• AE_HEADER_ID, AE_LINE_NUMBER, AE_LINE_TYPE_CODE — header linkage, line sequencing, and line classification.
• CODE_COMBINATION_ID — the GL account code combination to which the line is posted.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE — currency and conversion attributes.
• ENTERED_DR / ENTERED_CR / ACCOUNTED_DR / ACCOUNTED_CR — entered and accounted debit and credit amounts.
• SOURCE_TABLE, SOURCE_ID, RATE_OR_AMOUNT, BASIS_TYPE — originating transaction reference and costing basis information.
• RESOURCE_ID, COST_ELEMENT_ID, ACTIVITY_ID, REPETITIVE_SCHEDULE_ID — costing detail identifiers.
• OVERHEAD_BASIS_FACTOR, BASIS_RESOURCE_ID — overhead absorption attributes.
• GL_SL_LINK_ID, GL_TRANSFER_ERROR_CODE, ACCOUNTING_ERROR_CODE — GL transfer linkage and error status.
• SUBLEDGER_DOC_SEQUENCE_ID / SUBLEDGER_DOC_SEQUENCE_VALUE — subledger document sequencing.
• REFERENCE1 … REFERENCE10, DESCRIPTION, STAT_AMOUNT, USSGL_TRANSACTION_CODE — descriptive and reference attributes.
• Audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, REQUEST_ID, PO_DISTRIBUTION_ID) — standard WHO and concurrent program audit fields.

Common Use Cases and Queries

Typical uses include reconciling Cost Management accounting lines against GL balances, reporting pending or errored subledger lines, and resolving a specific AE_LINE_ID to its account combination and amounts. A representative query filtering by line identifier and filtering only standard accounting lines is:

• SELECT ae_line_id, ae_header_id, code_combination_id, entered_dr, entered_cr FROM cst_pac_ae_lines_v WHERE ae_line_id = :p_line_id;
• SELECT ae_line_id, ae_header_id, accounted_dr, accounted_cred FROM cst_pac_ae_lines_v WHERE gl_transfer_error_code IS NOT NULL;

Because the trailing discriminator is not aliased in the documented text, consumers relying on the union must filter via SOURCE_TABLE or join back to the base tables to distinguish accounting rows from encumbrance rows. As with all APPS views, access is governed by the standard EBS responsibility and menu security model.