Search Results h_currency_code

Overview

CST_XLA_AWO_HEADERS_V is an APPS-owned view in Oracle E-Business Suite that exposes Work in Process write-off accounting header information in the Subledger Accounting (XLA) event format. It belongs primarily to the BOM – Bills of Material product family and is used within the Cost Management write-off flow, where manufacturing and inventory write-off transactions are accounted through Subledger Accounting and ultimately transferred to General Ledger. The view's central purpose is to present one row per accounting event header, joining the write-off record to its corresponding XLA event so that downstream accounting, transfer-to-GL, and reporting processes can consume consistent event-level data. It surfaces critical monetary and currency attributes — most notably the value exposed as H_CURRENCY_CODE (mapped from CWO.CURRENCY_CODE) — alongside conversion date, rate, and type, enabling multi-currency write-off accounting.

Underlying Base Objects

The view is defined over the following documented base objects in the APPS schema:

• CST_WRITE_OFFS (aliased CWO) — the fact table of write-off transactions, holding amounts, accounts, item, vendor, currency, and date attributes.
• XLA_EVENTS_GT (aliased XEG) — the XLA events global temporary table, filtered to ENTITY_CODE = 'WO_ACCOUNTING_EVENTS'. It supplies the XLA EVENT_ID and LEDGER_ID.
• GL_LEDGERS (aliased GL) — the ledger definition, providing the functional currency code (FUNC_CURRENCY_CODE).
• FND_CURRENCIES (aliased FC) — currency precision and MINIMUM_ACCOUNTABLE_UNIT, used to round entered amounts.

The join logic links CWO.WRITE_OFF_ID to XEG.SOURCE_ID_INT_1, GL.LEDGER_ID to XEG.LEDGER_ID, and FC.CURRENCY_CODE to GL.CURRENCY_CODE. The view therefore sits at the intersection of cost write-off data and the Subledger Accounting event model.

Key Columns

• EVENT_ID — XLA event identifier from XLA_EVENTS_GT.
• WRITE_OFF_ID — primary identifier of the underlying CST_WRITE_OFFS record.
• H_CURRENCY_CODE — the transaction/entered currency code (CWO.CURRENCY_CODE); the "H_" prefix denotes the header-level currency.
• H_CURRENCY_CONVERSION_DATE / _RATE / _TYPE — the conversion attributes used to translate entered amounts into the ledger currency.
• H_ENTERED_AMOUNT / H_ACCOUNTED_AMOUNT — the entered write-off value and its accounted equivalent (CWO.WRITE_OFF_AMOUNT).
• WO_ERV_AMOUNT / TOTAL_ACCRUAL_AMOUNT — computed amounts reconciling the rounded entered value against the accounted write-off, forming the accrual and exchange-rate-variance components.
• H_LEDGER_ID — the accounting ledger for the event.
• FUNC_CURRENCY_CODE — the ledger's functional currency from GL_LEDGERS.
• DISTRIBUTION_TYPE — literal 'CST_WRITE_OFFS'; TRANSFER_TO_GL_INDICATOR — literal 'Y'.
• Identification columns: INVENTORY_ITEM_ID, VENDOR_ID, PO_DISTRIBUTION_ID, INVOICE_DISTRIBUTION_ID, INVENTORY_TRANSACTION_ID, OPERATING_UNIT_ID, and the various account IDs.

Common Use Cases and Queries

Typical uses include auditing write-off accounting entries, reconciling entered versus accounted amounts across currencies, and feeding custom Subledger Accounting reports. A representative query filtering by the currency column follows:

• List write-offs in a given currency with amounts and ledger context.

SELECT event_id,
       write_off_id,
       h_currency_code,
       h_entered_amount,
       h_accounted_amount,
       h_ledger_id,
       transaction_date
FROM   apps.cst_xla_awo_headers_v
WHERE  h_currency_code = 'USD';

• Ideal for currency-conversion reconciliation, using the conversion rate and type columns joined to the functional currency.
• Useful for extracting XLA event headers for a specific item or vendor when reconciling manufacturing write-offs against GL balances.

Because the view depends on XLA_EVENTS_GT, queries should run in a context where the XLA event population is active, ensuring the temporary event data is available for the join.