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

VIEW: APPS.CST_DEFAULT_DETAIL_COST_VIEW

Object Details
Object Name: CST_DEFAULT_DETAIL_COST_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_DEFAULT_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
COST_TYPE_ID NUMBER
Yes Cost type identifier
ITEM_COST_TYPE_ID NUMBER
Yes Cost type identifier or the default cost tpe identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
INVENTORY_ASSSET_FLAG NUMBER
Yes Flag indicating item is an inventory asset
LOT_SIZE NUMBER

Lot Size
BASED_ON_ROLLUP_FLAG NUMBER

Flag indicating whether cost will be rolled up
SHRINKAGE_RATE NUMBER

Manufacturing shrinkage rate (for make item only)
DEFAULTED_FLAG NUMBER
Yes Flag indicating whether the cost of the item is defaulted from the default cost type during cost roll up
COST_UPDATE_ID NUMBER

Cost update session identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number in a routing
DEPARTMENT_ID NUMBER

Department identifier
LEVEL_TYPE NUMBER

Level at which cost is incurred
ACTIVITY_ID NUMBER

Activity identifier
RESOURCE_SEQ_NUM NUMBER

Resource sequence number in an operation
RESOURCE_ID NUMBER

Resource identifier (sub-element)
RESOURCE_RATE NUMBER

Resource unit cost (resource sub-element only)
ITEM_UNITS NUMBER

Number of item units the activity cost is applied to(the number of items for each activity occurrence)
ACTIVITY_UNITS NUMBER

Number of activity units applied to the item cost(the number of times the activity occurs for the item)
USAGE_RATE_OR_AMOUNT NUMBER

Number of resource units, overhead rate, or activity unit cost per basis
BASIS_TYPE NUMBER

Basis or allocation method for the cost
BASIS_RESOURCE_ID NUMBER

Resource identifier for the resource overhead is based on
BASIS_FACTOR NUMBER

Basis factor
NET_YIELD_OR_SHRINKAGE_FACTOR NUMBER

Item shrinkage factor computed from the item shrinkage
ITEM_COST NUMBER

Total item cost for this row
COST_ELEMENT_ID NUMBER

Cost element identifier
ROLLUP_SOURCE_TYPE NUMBER

Cost source
OPERATION_SEQUENCE_ID NUMBER

Operation sequence identifier
Query Text

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


SELECT COST_TYPE_ID
,      ITEM_COST_TYPE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      INVENTORY_ASSSET_FLAG
,      LOT_SIZE
,      BASED_ON_ROLLUP_FLAG
,      SHRINKAGE_RATE
,      DEFAULTED_FLAG
,      COST_UPDATE_ID
,      OPERATION_SEQ_NUM
,      DEPARTMENT_ID
,      LEVEL_TYPE
,      ACTIVITY_ID
,      RESOURCE_SEQ_NUM
,      RESOURCE_ID
,      RESOURCE_RATE
,      ITEM_UNITS
,      ACTIVITY_UNITS
,      USAGE_RATE_OR_AMOUNT
,      BASIS_TYPE
,      BASIS_RESOURCE_ID
,      BASIS_FACTOR
,      NET_YIELD_OR_SHRINKAGE_FACTOR
,      ITEM_COST
,      COST_ELEMENT_ID
,      ROLLUP_SOURCE_TYPE
,      OPERATION_SEQUENCE_ID
FROM APPS.CST_DEFAULT_DETAIL_COST_VIEW;

Dependencies

[top of page]

APPS.CST_DEFAULT_DETAIL_COST_VIEW references the following:

SchemaAPPS
SynonymCST_COST_TYPES
SynonymCST_ITEM_COSTS
SynonymCST_ITEM_COST_DETAILS

APPS.CST_DEFAULT_DETAIL_COST_VIEW is not referenced by any database object