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.
Problems that run through this table