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

VIEW: APPS.CST_DETAIL_COSTS_FOR_GL_VIEW

Object Details
Object Name: CST_DETAIL_COSTS_FOR_GL_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_DETAIL_COSTS_FOR_GL_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_ORGANIZATION_ID NUMBER
Yes Costing Organization Identifier
COST_TYPE_ID NUMBER
Yes Cost type identifier
OPERATION_SEQUENCE_ID NUMBER

Operation sequence identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number in a routing
DEPARTMENT_ID NUMBER

Department identifier
LEVEL_TYPE NUMBER
Yes 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
ACTIVITY_UNITS NUMBER

Number of activity units applied to the item cost
USAGE_RATE_OR_AMOUNT NUMBER
Yes Number of resource units, overhead rate, or activity unit cost per basis
BASIS_TYPE NUMBER
Yes Allocation basis
BASIS_RESOURCE_ID NUMBER

Resource identifier for the resource overhead is based on
BASIS_FACTOR NUMBER
Yes Basis factor
NET_YIELD_OR_SHRINKAGE_FACTOR NUMBER
Yes Item shrinkage factor computed from the item shrinkage
ITEM_COST NUMBER
Yes Net item cost for this row
COST_ELEMENT_ID NUMBER

Cost element identifier
ROLLUP_SOURCE_TYPE NUMBER
Yes Cost source
ACTIVITY_CONTEXT VARCHAR2 (30)
Structure defining column for the Activity Unit Information
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
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COST_ORGANIZATION_ID
,      COST_TYPE_ID
,      OPERATION_SEQUENCE_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
,      ACTIVITY_CONTEXT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.CST_DETAIL_COSTS_FOR_GL_VIEW;

Dependencies

[top of page]

APPS.CST_DETAIL_COSTS_FOR_GL_VIEW references the following:

SchemaAPPS
SynonymCST_ITEM_COST_DETAILS
SynonymMTL_PARAMETERS

APPS.CST_DETAIL_COSTS_FOR_GL_VIEW is not referenced by any database object