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

VIEW: BOM.CST_PAC_ITEM_COSTS_EFC#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
MARKET_VALUE NUMBER

RESOURCE_COST NUMBER

COST_LAYER_ID NUMBER
Yes
PL_ITEM_COST NUMBER

PAC_PERIOD_ID NUMBER
Yes
PL_RESOURCE NUMBER

UNBURDENED_COST NUMBER

ITEM_MAKE_COST NUMBER

TL_ITEM_COST NUMBER

OVERHEAD_COST NUMBER

ITEM_COST NUMBER

MATERIAL_COST NUMBER

TL_RESOURCE NUMBER

PL_OVERHEAD NUMBER

PL_MATERIAL NUMBER

BEGIN_ITEM_COST NUMBER

TL_OVERHEAD NUMBER

TL_MATERIAL NUMBER

OUTSIDE_PROCESSING_COST NUMBER

COST_GROUP_ID NUMBER
Yes
PL_OUTSIDE_PROCESSING NUMBER

MATERIAL_OVERHEAD_COST NUMBER

ITEM_BUY_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 MARKET_VALUE
,      RESOURCE_COST
,      COST_LAYER_ID
,      PL_ITEM_COST
,      PAC_PERIOD_ID
,      PL_RESOURCE
,      UNBURDENED_COST
,      ITEM_MAKE_COST
,      TL_ITEM_COST
,      OVERHEAD_COST
,      ITEM_COST
,      MATERIAL_COST
,      TL_RESOURCE
,      PL_OVERHEAD
,      PL_MATERIAL
,      BEGIN_ITEM_COST
,      TL_OVERHEAD
,      TL_MATERIAL
,      OUTSIDE_PROCESSING_COST
,      COST_GROUP_ID
,      PL_OUTSIDE_PROCESSING
,      MATERIAL_OVERHEAD_COST
,      ITEM_BUY_COST
,      PL_MATERIAL_OVERHEAD
,      BURDEN_COST
,      TL_OUTSIDE_PROCESSING
,      TL_MATERIAL_OVERHEAD
,      SET_OF_BOOKS_ID
FROM BOM.CST_PAC_ITEM_COSTS_EFC#;

Dependencies

[top of page]

BOM.CST_PAC_ITEM_COSTS_EFC# references the following:

SchemaBOM
TableCST_PAC_ITEM_COSTS_EFC
BOM.CST_PAC_ITEM_COSTS_EFC# is referenced by following:

SchemaAPPS
SynonymCST_PAC_ITEM_COSTS_EFC