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

VIEW: BOM.CST_ITEM_COSTS_EFC#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_COST NUMBER

ORGANIZATION_ID NUMBER
Yes
PL_ITEM_COST NUMBER

PL_RESOURCE NUMBER

UNBURDENED_COST NUMBER

TL_ITEM_COST NUMBER

OVERHEAD_COST NUMBER

COST_TYPE_ID NUMBER
Yes
ITEM_COST NUMBER

MATERIAL_COST NUMBER

TL_RESOURCE NUMBER

INVENTORY_ITEM_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
,      ORGANIZATION_ID
,      PL_ITEM_COST
,      PL_RESOURCE
,      UNBURDENED_COST
,      TL_ITEM_COST
,      OVERHEAD_COST
,      COST_TYPE_ID
,      ITEM_COST
,      MATERIAL_COST
,      TL_RESOURCE
,      INVENTORY_ITEM_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_ITEM_COSTS_EFC#;

Dependencies

[top of page]

BOM.CST_ITEM_COSTS_EFC# references the following:

SchemaBOM
TableCST_ITEM_COSTS_EFC
BOM.CST_ITEM_COSTS_EFC# is referenced by following:

SchemaAPPS
SynonymCST_ITEM_COSTS_EFC