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

CST_INDENTED_ROLLUP_DETAILS_V

CostingUsed in 2 subject areas43 reporting columns

Cost Management (CST), denormalized view.

Primary key: not yet catalogued for CST_INDENTED_ROLLUP_DETAILS_V, reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
ALLOCATED_EXTENDED_COSTAllocated extended cost.
ALLOCATED_UNIT_COSTAllocated unit cost.
BASIS_TYPEType of basis.
BATCH_PRIMARY_UOM_CODECode identifying the batch primary unit of measure.
BATCH_QUANTITYBatch quantity.
BATCH_UOM_CODECode identifying the batch unit of measure.
BOM_LEVELBom level.
COSTING_BATCH_OUTPUT_SIZECosting batch output size.
COSTING_PRIORITYCosting priority.
COST_ALLOCATION_PERCENTAGECost allocation percentage.
COST_EFFECTIVE_END_DATECost effective end date.
COST_EFFECTIVE_START_DATECost effective start date.
COST_UOM_CODECode identifying the cost unit of measure.
CUMULATIVE_EXTENDED_COSTCumulative extended cost.
CUMULATIVE_UNIT_COSTCumulative unit cost.
DETAIL_SOURCE_TYPEType of detail source.
EXTENDED_COSTExtended cost.
OPERATION_SEQ_NUMBEROperation seq number.
OP_REV_YIELD_FACTOROp rev yield factor.
OP_YIELD_FACTOROp yield factor.
ORIG_OUTPUT_TYPEType of orig output.
OUTPUT_SEQ_NUMBEROutput seq number.
OUTPUT_TYPEType of output.
OVERHEAD_FLAGIndicator (Y/N) for the overhead.
POSTED_FLAGIndicator (Y/N) for the posted.
PRIMARY_FLAGIndicator (Y/N) for the primary.
PRIMARY_UOM_CODECode identifying the primary unit of measure.
PRODUCTION_PRIORITYProduction priority.
PUBLISHED_FLAGIndicator (Y/N) for the published.
QTY_UOM_CODECode identifying the quantity unit of measure.
QUANTITY_USAGEQuantity usage.
RESOURCE_SEQ_NUMBERResource seq number.
ROLLUPKEYRollupkey.
RUNNING_EXTENDED_TOTALRunning extended total.
STATUS_CODECode identifying the status.
UNALLOCATED_EXTENDED_COSTUnallocated extended cost.
UNIT_COSTUnit cost.
VERSION_NUMBERVersion number.
WORK_DEFINITION_TYPEType of work definition.
WORK_METHOD_CODECode identifying the work method.
WORK_METHOD_IDIdentifier for the work method.
WORK_METHOD_NAMEName of the work method.
YIELD_FACTORYield 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_INDENTED_ROLLUP_DETAILS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
Inventory as of any date · What the extract does not carry · The export ceiling