eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BOM.CST_PAC_ITEM_COSTS

Object Details

Object Name:	CST_PAC_ITEM_COSTS
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_PAC_ITEM_COSTS
Subobject Name:
Status:	VALID

CST_PAC_ITEM_COSTS stores the item cost and quantity in a period and organization cost group.
The COST_LAYER_ID is unique for a period / organization cost group / item combination.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_PAC_ITEM_COSTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COST_LAYER_ID
CST_PAC_ITEM_COST_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAC_PERIOD_ID COST_GROUP_ID INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COST_LAYER_ID	NUMBER		Yes	Cost layer identifier
PAC_PERIOD_ID	NUMBER		Yes	Period Identifier
COST_GROUP_ID	NUMBER		Yes	Cost Group Identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item identifier
BUY_QUANTITY	NUMBER			The buy quantity in the period
MAKE_QUANTITY	NUMBER			The make quantity in the period
ISSUE_QUANTITY	NUMBER			The quantity issued in the periodic costing period
TOTAL_LAYER_QUANTITY	NUMBER			The net quantity at the end of the Periodic Average Costing period
ITEM_COST	NUMBER			The item cost at the end of the period.
ITEM_BUY_COST	NUMBER			The buy item cost at the end of the period
ITEM_MAKE_COST	NUMBER			The make item cost at the end of the period
BEGIN_ITEM_COST	NUMBER			The item cost at the beginning of the period
MATERIAL_COST	NUMBER			Material cost
MATERIAL_OVERHEAD_COST	NUMBER			Material overhead cost
RESOURCE_COST	NUMBER			Resource cost
OVERHEAD_COST	NUMBER			Overhead cost
OUTSIDE_PROCESSING_COST	NUMBER			Outside processing cost
PL_MATERIAL	NUMBER			Previous level material cost
PL_MATERIAL_OVERHEAD	NUMBER			Previous level material overhead cost
PL_RESOURCE	NUMBER			Previous level resource cost
PL_OUTSIDE_PROCESSING	NUMBER			Previous level outside processing cost
PL_OVERHEAD	NUMBER			Previous level overhead cost
TL_MATERIAL	NUMBER			This level material cost
TL_MATERIAL_OVERHEAD	NUMBER			This level material overhead cost
TL_RESOURCE	NUMBER			This level resource cost
TL_OUTSIDE_PROCESSING	NUMBER			This level outside processing cost
TL_OVERHEAD	NUMBER			This level overhead cost
PL_ITEM_COST	NUMBER			Total previous level item cost
TL_ITEM_COST	NUMBER			Total item cost in this level
UNBURDENED_COST	NUMBER			Item unit cost minus this level material overhead
BURDEN_COST	NUMBER			This level material overhead
LAST_UPDATE_DATE	DATE		Yes	Who column
LAST_UPDATED_BY	NUMBER		Yes	Who column
CREATION_DATE	DATE		Yes	Who column
CREATED_BY	NUMBER		Yes	Who column
REQUEST_ID	NUMBER			Who column
PROGRAM_APPLICATION_ID	NUMBER			Who column
PROGRAM_ID	NUMBER			Who column
PROGRAM_UPDATE_DATE	DATE			Who column
LAST_UPDATE_LOGIN	NUMBER			Who column
MARKET_VALUE	NUMBER			Market value
JUSTIFICATION	VARCHAR2	(2000)		Justification for the market value
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive Flexfield segment

Query Text

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


SELECT COST_LAYER_ID
,      PAC_PERIOD_ID
,      COST_GROUP_ID
,      INVENTORY_ITEM_ID
,      BUY_QUANTITY
,      MAKE_QUANTITY
,      ISSUE_QUANTITY
,      TOTAL_LAYER_QUANTITY
,      ITEM_COST
,      ITEM_BUY_COST
,      ITEM_MAKE_COST
,      BEGIN_ITEM_COST
,      MATERIAL_COST
,      MATERIAL_OVERHEAD_COST
,      RESOURCE_COST
,      OVERHEAD_COST
,      OUTSIDE_PROCESSING_COST
,      PL_MATERIAL
,      PL_MATERIAL_OVERHEAD
,      PL_RESOURCE
,      PL_OUTSIDE_PROCESSING
,      PL_OVERHEAD
,      TL_MATERIAL
,      TL_MATERIAL_OVERHEAD
,      TL_RESOURCE
,      TL_OUTSIDE_PROCESSING
,      TL_OVERHEAD
,      PL_ITEM_COST
,      TL_ITEM_COST
,      UNBURDENED_COST
,      BURDEN_COST
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MARKET_VALUE
,      JUSTIFICATION
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
FROM BOM.CST_PAC_ITEM_COSTS;

Dependencies

[top of page]

BOM.CST_PAC_ITEM_COSTS does not reference any database object

BOM.CST_PAC_ITEM_COSTS is referenced by following:

BOM: CST_PAC_ITEM_COSTS#