Oracle Fusion · Data dictionary
CST_WHERE_USED_ROLLUP_DTLS_V
CostingUsed in 1 subject areas37 reporting columns
Cost Management (CST) — denormalized view.
Primary key: not yet catalogued for CST_WHERE_USED_ROLLUP_DTLS_V — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOCATED_EXTENDED_COST | ● | Allocated extended cost. | |
| ALLOCATED_UNIT_COST | ● | Allocated unit cost. | |
| BASIS_TYPE | ● | Type of basis. | |
| BATCH_PRIMARY_UOM_CODE | ● | Code identifying the batch primary unit of measure. | |
| BATCH_QUANTITY | ● | Batch quantity. | |
| BATCH_UOM_CODE | ● | Code identifying the batch unit of measure. | |
| BOM_LEVEL | ● | Bom level. | |
| COSTING_BATCH_OUTPUT_SIZE | ● | Costing batch output size. | |
| COSTING_PRIORITY | ● | Costing priority. | |
| COST_ALLOCATION_PERCENTAGE | ● | Cost allocation percentage. | |
| COST_EFFECTIVE_END_DATE | ● | Cost effective end date. | |
| COST_EFFECTIVE_START_DATE | ● | Cost effective start date. | |
| COST_UOM_CODE | ● | Code identifying the cost unit of measure. | |
| CUMULATIVE_EXTENDED_COST | ● | Cumulative extended cost. | |
| CUMULATIVE_UNIT_COST | ● | Cumulative unit cost. | |
| DETAIL_SOURCE_TYPE | ● | Type of detail source. | |
| EXTENDED_COST | ● | Extended cost. | |
| ORIG_OUTPUT_TYPE | ● | Type of orig output. | |
| OUTPUT_TYPE | ● | Type of output. | |
| POSTED_FLAG | ● | Indicator (Y/N) for the posted. | |
| PRIMARY_FLAG | ● | Indicator (Y/N) for the primary. | |
| PRIMARY_UOM_CODE | ● | Code identifying the primary unit of measure. | |
| PRODUCTION_PRIORITY | ● | Production priority. | |
| PUBLISHED_FLAG | ● | Indicator (Y/N) for the published. | |
| QTY_UOM_CODE | ● | Code identifying the quantity unit of measure. | |
| QUANTITY_USAGE | ● | Quantity usage. | |
| RESOURCE_SEQ_NUMBER | ● | Resource seq number. | |
| ROLLUPKEY | ● | Rollupkey. | |
| STATUS_CODE | ● | Code identifying the status. | |
| UNALLOCATED_EXTENDED_COST | ● | Unallocated extended cost. | |
| UNIT_COST | ● | Unit cost. | |
| VERSION_NUMBER | ● | Version number. | |
| WORK_DEFINITION_TYPE | ● | Type of work definition. | |
| WORK_METHOD_CODE | ● | Code identifying the work method. | |
| WORK_METHOD_ID | ● | Identifier for the work method. | |
| WORK_METHOD_NAME | ● | Name of the work method. | |
| YIELD_FACTOR | ● | Yield factor. |
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 CST_WHERE_USED_ROLLUP_DTLS_V?
We ship parameterized SQL, BICC config, and dbt models you own.