Analytics Catalog/Data dictionary/XLA_CST_DISTRIBUTION_LINES_VL
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

XLA_CST_DISTRIBUTION_LINES_VL

Subledger AccountingUsed in 2 subject areas7 reporting columns

Subledger Accounting (XLA) — view layer — joins the base table with translations for the current language.

Likely primary key: CST_DISTRIBUTION_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions — verify against Tables & Views)

Columns

ColumnKeyIn reportsDescription (inferred)
CST_DISTRIBUTION_HEADER_IDPK?Identifier for the cst distribution header.
GL_BATCH_DESCDescription of the general ledger batch.
GL_BATCH_NAMEName of the general ledger batch.
GL_BATCH_STATUSStatus of the general ledger batch.
GL_TRANSFER_DATEGeneral ledger transfer date.
GL_TRANSFER_STATUS_CODECode identifying the general ledger transfer status.
LINE_NUMBERPK?Line number.
SLA_DR_CR_SIGNSla dr cr sign.
SLA_LEDGER_AMOUNTSla ledger amount.

Used by reports

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for XLA_CST_DISTRIBUTION_LINES_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us