[Home] [Help] [Dependency Information]
Object Name: | CST_ITEM_COSTS_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.CST_ITEM_COSTS_VIEW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|