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_TYPE_HISTORY

Object Details

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

CST_COST_TYPE_HISTORY stores Cost Rollup information and cost type
purge information. You can obtain information about prior Cost
Rollups by requesting an Indented Bills of Material Cost Report.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_COST_TYPE_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COST_TYPE_ID ORGANIZATION_ID ROLLUP_DATE PURGE_DATE
CST_COST_TYPE_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COST_TYPE_ID	NUMBER		Yes	Cost type identifier
ORGANIZATION_ID	NUMBER		Yes	Organization 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
ROLLUP_ID	NUMBER			Rollup identifier
ROLLUP_DATE	DATE			Cost Rollup run date
REPORT_OPTION	NUMBER			Report option
REPORT_TYPE	NUMBER			Report type
ROLLUP_OPTION	NUMBER			Rollup option, full or single level rollup
RANGE	NUMBER			Range option
REVISION_DATE	DATE			Effective date of the assembly
UNIMPLEMENTED_ECN_FLAG	NUMBER			Included unimplemented ECN in the cost type or not
ALTERNATE_BOM_DESIGNATOR	VARCHAR2	(10)		Alternate designator
ALTERNATE_RTG_DESIGNATOR	VARCHAR2	(10)		Alternate routing designator
ENGINEERING_FLAG	NUMBER			Include engineering bills or not
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
CATEGORY_SET_ID	NUMBER			Category set identifier
CATEGORY_ID	NUMBER			Category identifier
CATEGORY	VARCHAR2	(240)		Category name
RANGE_LOW	VARCHAR2	(240)		Inventory item from value
RANGE_HIGH	VARCHAR2	(240)		Inventory item to value
PURGE_DATE	DATE			Date the cost type was deleted
PURGE_OPTION	NUMBER			Purge option
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
REQUEST_ID	NUMBER			Concurrent Who column

Query Text

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


SELECT COST_TYPE_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ROLLUP_ID
,      ROLLUP_DATE
,      REPORT_OPTION
,      REPORT_TYPE
,      ROLLUP_OPTION
,      RANGE
,      REVISION_DATE
,      UNIMPLEMENTED_ECN_FLAG
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_RTG_DESIGNATOR
,      ENGINEERING_FLAG
,      INVENTORY_ITEM_ID
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      CATEGORY
,      RANGE_LOW
,      RANGE_HIGH
,      PURGE_DATE
,      PURGE_OPTION
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM BOM.CST_COST_TYPE_HISTORY;

Dependencies

[top of page]

BOM.CST_COST_TYPE_HISTORY does not reference any database object

BOM.CST_COST_TYPE_HISTORY is referenced by following:

BOM: CST_COST_TYPE_HISTORY#