DBA Data[Home] [Help] [Dependency Information]


VIEW: BOM.CST_QUANTITY_LAYERS_EFC#

Object Details
Object Name: CST_QUANTITY_LAYERS_EFC#
Object Type: VIEW
Owner: BOM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_COST NUMBER

PL_ITEM_COST NUMBER

PL_RESOURCE NUMBER

UNBURDENED_COST NUMBER

TL_ITEM_COST NUMBER

OVERHEAD_COST NUMBER

ITEM_COST NUMBER
Yes
MATERIAL_COST NUMBER

TL_RESOURCE NUMBER

LAYER_ID NUMBER
Yes
PL_OVERHEAD NUMBER

PL_MATERIAL NUMBER

TL_OVERHEAD NUMBER

TL_MATERIAL NUMBER

OUTSIDE_PROCESSING_COST NUMBER

PL_OUTSIDE_PROCESSING NUMBER

MATERIAL_OVERHEAD_COST NUMBER

PL_MATERIAL_OVERHEAD NUMBER

BURDEN_COST NUMBER

TL_OUTSIDE_PROCESSING NUMBER

TL_MATERIAL_OVERHEAD NUMBER

SET_OF_BOOKS_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RESOURCE_COST
,      PL_ITEM_COST
,      PL_RESOURCE
,      UNBURDENED_COST
,      TL_ITEM_COST
,      OVERHEAD_COST
,      ITEM_COST
,      MATERIAL_COST
,      TL_RESOURCE
,      LAYER_ID
,      PL_OVERHEAD
,      PL_MATERIAL
,      TL_OVERHEAD
,      TL_MATERIAL
,      OUTSIDE_PROCESSING_COST
,      PL_OUTSIDE_PROCESSING
,      MATERIAL_OVERHEAD_COST
,      PL_MATERIAL_OVERHEAD
,      BURDEN_COST
,      TL_OUTSIDE_PROCESSING
,      TL_MATERIAL_OVERHEAD
,      SET_OF_BOOKS_ID
FROM BOM.CST_QUANTITY_LAYERS_EFC#;

Dependencies

[top of page]

BOM.CST_QUANTITY_LAYERS_EFC# references the following:

SchemaBOM
TableCST_QUANTITY_LAYERS_EFC
BOM.CST_QUANTITY_LAYERS_EFC# is referenced by following:

SchemaAPPS
SynonymCST_QUANTITY_LAYERS_EFC