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

VIEW: APPS.CST_CQL_CIC_ITEM_COSTS_V

Object Details
Object Name: CST_CQL_CIC_ITEM_COSTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_CQL_CIC_ITEM_COSTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization identifier
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
COST_GROUP_ID NUMBER

Cost group identifier
COST_TYPE_ID NUMBER

Cost type identifier
ITEM_COST NUMBER

Item unit cost
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

Previous level item cost
TL_ITEM_COST NUMBER

This level item cost
UNBURDENED_COST NUMBER

Item unit cost minus this level material overhead
BURDEN_COST NUMBER

This level material overhead
INVENTORY_ASSET_FLAG NUMBER

Flag indicating whether item is asset or expense
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      COST_GROUP_ID
,      COST_TYPE_ID
,      ITEM_COST
,      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
,      UNBURDENED_COST
,      BURDEN_COST
,      INVENTORY_ASSET_FLAG
FROM APPS.CST_CQL_CIC_ITEM_COSTS_V;

Dependencies

[top of page]

APPS.CST_CQL_CIC_ITEM_COSTS_V references the following:

SchemaAPPS
SynonymCST_ITEM_COSTS
SynonymCST_QUANTITY_LAYERS
SynonymMTL_SYSTEM_ITEMS

APPS.CST_CQL_CIC_ITEM_COSTS_V is not referenced by any database object