Oracle Fusion · Data dictionary
CST_COST_DISTRIBUTION_LINES
CostingUsed in 3 subject areas9 reporting columns
Cost Management (CST), line table, one row per line item under the header.
Likely primary key: COST_DISTRIBUTION_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): AE_HEADER_ID → XLA_AE_HEADERS · CODE_COMBINATION_ID → GL_CODE_COMBINATIONS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTING_LINE_TYPE | ● | Type of accounting line. | |
| AE_HEADER_ID | ● | Identifier for the ae header. | |
| CODE_COMBINATION_ID | ● | Identifier for the code combination. | |
| COST_DISTRIBUTION_HEADER_ID | PK? | ○ | Identifier for the cost distribution header. |
| DISTRIBUTION_LINE_ID | ● | Identifier for the distribution line. | |
| DR_CR_SIGN | ● | Dr cr sign. | |
| ENTERED_CURRENCY_AMOUNT | ● | Entered currency amount. | |
| ENTERED_CURRENCY_CODE | ● | Currency code for the entered. | |
| GL_DATE | ● | General ledger date. | |
| LEDGER_AMOUNT | ● | Ledger amount. | |
| LINE_NUMBER | PK? | ○ | Line number. |
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.
- Costing - COGS and Gross Margin Real Time
- Costing - Cost Accounting Real Time
- Supply Chain Financial Orchestration Real Time
Need the extract + dbt staging for CST_COST_DISTRIBUTION_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table