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

VIEW: APPS.CST_ITEM_COSTS_VIEW

Object Details
Object Name: CST_ITEM_COSTS_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_ITEM_COSTS_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
PL_MATERIAL NUMBER

Previous level material cost
PL_MATERIAL_OVERHEAD NUMBER

Previous level material overhead cost
PL_RESOURCE NUMBER

Previous level resource cost
PL_OUTSIDE_PROCESSING NUMBER

Previous level outside processing cost
PL_OVERHEAD NUMBER

Previous level overhead cost
TL_MATERIAL NUMBER

This level material cost
TL_MATERIAL_OVERHEAD NUMBER

This level material overhead cost
TL_RESOURCE NUMBER

This level resource cost
TL_OUTSIDE_PROCESSING NUMBER

This level outside processing cost
TL_OVERHEAD NUMBER

This level overhead cost
MATERIAL_COST NUMBER

Material cost
MATERIAL_OVERHEAD_COST NUMBER

Material overhead cost
RESOURCE_COST NUMBER

Resource cost
OUTSIDE_PROCESSING_COST NUMBER

Outside Processing cost
OVERHEAD_COST NUMBER

Overhead cost
PL_ITEM_COST NUMBER

Total previous level cost
TL_ITEM_COST NUMBER

Total this level cost
ITEM_COST NUMBER

Item unit cost
UNBURDENED_COST NUMBER

Item unit cost minus this level material overhead
BURDEN_COST NUMBER

This level material overhead
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COST_TYPE_ID
,      PL_MATERIAL
,      PL_MATERIAL_OVERHEAD
,      PL_RESOURCE
,      PL_OUTSIDE_PROCESSING
,      PL_OVERHEAD
,      TL_MATERIAL
,      TL_MATERIAL_OVERHEAD
,      TL_RESOURCE
,      TL_OUTSIDE_PROCESSING
,      TL_OVERHEAD
,      MATERIAL_COST
,      MATERIAL_OVERHEAD_COST
,      RESOURCE_COST
,      OUTSIDE_PROCESSING_COST
,      OVERHEAD_COST
,      PL_ITEM_COST
,      TL_ITEM_COST
,      ITEM_COST
,      UNBURDENED_COST
,      BURDEN_COST
FROM APPS.CST_ITEM_COSTS_VIEW;

Dependencies

[top of page]

APPS.CST_ITEM_COSTS_VIEW references the following:

SchemaAPPS
SynonymCST_ITEM_COST_DETAILS
APPS.CST_ITEM_COSTS_VIEW is referenced by following:

SchemaAPPS
Package BodyCSTPACOV - show dependent code