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_DETAIL_COST_VIEW

Object Details

Object Name:	CST_DETAIL_COST_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_DETAIL_COST_VIEW
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
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
COST_TYPE_ID	NUMBER		Yes	Cost type identifier
BASIS	VARCHAR2	(80)		Allocation Basis
COST_ELEMENT	VARCHAR2	(80)		Cost element name
COST_ELEMENT_ID	NUMBER			cost element identifier
COST_ELEMENT_DESCRIPTION	VARCHAR2	(240)		Cost element description
COST_LEVEL	VARCHAR2	(80)		Level at which cost is incurred
ACTIVITY	VARCHAR2	(10)		Activity name
ACTIVITY_DESCRIPTION	VARCHAR2	(240)		Activity Description
RESOURCE_CODE	VARCHAR2	(10)		Resource code
RESOURCE_CODE_DESCRIPTION	VARCHAR2	(240)		Resource code description
OPERATION_SEQ_NUM	NUMBER			Operation sequence number in a routing
OPERATION_DESCRIPTION	VARCHAR2	(240)		Operation description
DEPARTMENT	VARCHAR2	(10)		Department name
DEPARTMENT_DESCRIPTION	VARCHAR2	(240)		Department description
RESOURCE_RATE	NUMBER			Resource unit cost
USAGE_RATE_OR_AMOUNT	NUMBER		Yes	Number of resource units, overhead rate, or activity unit cost per basis
BASIS_FACTOR	NUMBER		Yes	Basis factor
NET_YIELD_OR_SHRINKAGE_FACTOR	NUMBER		Yes	Item shrinkage factor computed from the item shrinkage
ITEM_UNITS	NUMBER			Number of item units the activity cost is applied to
ACTIVITY_UNITS	NUMBER			Number of activity units applied to the item cost
OUTPUT_UOM	VARCHAR2	(50)		Activity measurement unit
UNIT_OF_MEASURE	VARCHAR2	(3)		Unit of measure
VALUE_ADDED_ACTIVITY_FLAG	VARCHAR2	(150)		Flag indicating whether the activity adds value
ITEM_COST	NUMBER		Yes	Total item unit cost for this row
COST_SOURCE_TYPE	VARCHAR2	(80)		Cost source
CA_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
CA_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
BR_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
LEVEL_TYPE	NUMBER		Yes

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COST_TYPE_ID
,      BASIS
,      COST_ELEMENT
,      COST_ELEMENT_ID
,      COST_ELEMENT_DESCRIPTION
,      COST_LEVEL
,      ACTIVITY
,      ACTIVITY_DESCRIPTION
,      RESOURCE_CODE
,      RESOURCE_CODE_DESCRIPTION
,      OPERATION_SEQ_NUM
,      OPERATION_DESCRIPTION
,      DEPARTMENT
,      DEPARTMENT_DESCRIPTION
,      RESOURCE_RATE
,      USAGE_RATE_OR_AMOUNT
,      BASIS_FACTOR
,      NET_YIELD_OR_SHRINKAGE_FACTOR
,      ITEM_UNITS
,      ACTIVITY_UNITS
,      OUTPUT_UOM
,      UNIT_OF_MEASURE
,      VALUE_ADDED_ACTIVITY_FLAG
,      ITEM_COST
,      COST_SOURCE_TYPE
,      CA_ATTRIBUTE1
,      CA_ATTRIBUTE2
,      CA_ATTRIBUTE3
,      CA_ATTRIBUTE4
,      CA_ATTRIBUTE5
,      CA_ATTRIBUTE6
,      CA_ATTRIBUTE7
,      CA_ATTRIBUTE8
,      CA_ATTRIBUTE9
,      CA_ATTRIBUTE10
,      CA_ATTRIBUTE11
,      CA_ATTRIBUTE12
,      CA_ATTRIBUTE13
,      CA_ATTRIBUTE14
,      CA_ATTRIBUTE15
,      BR_ATTRIBUTE1
,      BR_ATTRIBUTE2
,      BR_ATTRIBUTE3
,      BR_ATTRIBUTE4
,      BR_ATTRIBUTE5
,      BR_ATTRIBUTE6
,      BR_ATTRIBUTE7
,      BR_ATTRIBUTE8
,      BR_ATTRIBUTE9
,      BR_ATTRIBUTE10
,      BR_ATTRIBUTE11
,      BR_ATTRIBUTE12
,      BR_ATTRIBUTE13
,      BR_ATTRIBUTE14
,      BR_ATTRIBUTE15
,      LEVEL_TYPE
FROM APPS.CST_DETAIL_COST_VIEW;

Dependencies

[top of page]

APPS.CST_DETAIL_COST_VIEW references the following:

APPS: BOM_DEPARTMENTS; BOM_OPERATION_SEQUENCES; BOM_RESOURCES; CST_ACTIVITIES; CST_COST_ELEMENTS; CST_ITEM_COST_DETAILS; MFG_LOOKUPS

APPS.CST_DETAIL_COST_VIEW is not referenced by any database object