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]

VIEW: APPS.CST_COST_TYPES_VAL_V

Object Details

Object Name:	CST_COST_TYPES_VAL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_COST_TYPES_VAL_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

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 whose set of costs will be used as the default cost type during the cost roll up
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
ALLOW_UPDATES_FLAG_DSP	VARCHAR2	(80)	Yes
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 sub-element
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			Disable date
AVAILABLE_TO_ENG_FLAG	NUMBER			Whether the set of cost for this cost type is available for ENG
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
,      ALLOW_UPDATES_FLAG_DSP
,      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 APPS.CST_COST_TYPES_VAL_V;

Dependencies

[top of page]

APPS.CST_COST_TYPES_VAL_V references the following:

APPS: CST_COST_TYPES; MFG_LOOKUPS

APPS.CST_COST_TYPES_VAL_V is not referenced by any database object