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_COST_TYPES

Object Details

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

CST_COST_TYPES stores cost type definitions. The table is seeded with three cost types: Frozen, Average, and Pending. The Frozen cost type is used in standard costing organizations.
The average cost type is used in average costing organizations. All costs reference a cost type.

PL_ELEMENT_FLAG, PL_RESOURCE_FLAG, PL_OPERATION_FLAG, PL_ACTIVITY_FLAG values are used by the Cost Rollup to determine whether to group rollup costs by cost element, sub element, operation sequence number, or activity. BOM_SNAPSHOT_FLAG is used by the Cost Rollup to determine whether to save the bill structure when rolling up costs for a cost type.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_COST_TYPES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COST_TYPE_ID
CST_COST_TYPES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	COST_TYPE ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COST_TYPE_ID	NUMBER		Yes	Cost type identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
ORGANIZATION_ID	NUMBER			Organization identifier
COST_TYPE	VARCHAR2	(10)	Yes	Cost type name
DESCRIPTION	VARCHAR2	(240)		Description
COSTING_METHOD_TYPE	NUMBER		Yes	Costing method used, standard or average
FROZEN_STANDARD_FLAG	NUMBER			Whether it is frozen standard cost type or not
DEFAULT_COST_TYPE_ID	NUMBER		Yes	Cost type identifier used as the default cost type when rolling up costs
BOM_SNAPSHOT_FLAG	NUMBER		Yes	Whether to save the bill structure when rolling up costs
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)		Alternate designator
ALLOW_UPDATES_FLAG	NUMBER			Whether the costs defined for this cost type can be changed
PL_ELEMENT_FLAG	NUMBER		Yes	Whether to group previous level cost by cost element
PL_RESOURCE_FLAG	NUMBER		Yes	Whether to group previous level cost by subelement
PL_OPERATION_FLAG	NUMBER		Yes	Whether to group previous level cost by operation sequence number
PL_ACTIVITY_FLAG	NUMBER		Yes	Whether to group previous level cost by activity
DISABLE_DATE	DATE			Inactive On/After
AVAILABLE_TO_ENG_FLAG	NUMBER			Whether the set of cost for this cost type is available for Oracle Engineering
COMPONENT_YIELD_FLAG	NUMBER		Yes	Whether to consider component yield factor when rolling up costs
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column
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
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column

Query Text

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


SELECT COST_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      COST_TYPE
,      DESCRIPTION
,      COSTING_METHOD_TYPE
,      FROZEN_STANDARD_FLAG
,      DEFAULT_COST_TYPE_ID
,      BOM_SNAPSHOT_FLAG
,      ALTERNATE_BOM_DESIGNATOR
,      ALLOW_UPDATES_FLAG
,      PL_ELEMENT_FLAG
,      PL_RESOURCE_FLAG
,      PL_OPERATION_FLAG
,      PL_ACTIVITY_FLAG
,      DISABLE_DATE
,      AVAILABLE_TO_ENG_FLAG
,      COMPONENT_YIELD_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.CST_COST_TYPES;

Dependencies

[top of page]

BOM.CST_COST_TYPES does not reference any database object

BOM.CST_COST_TYPES is referenced by following:

APPS: CST_COST_TYPES