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

VIEW: APPS.CST_PAC_ITEM_COSTS_V

Object Details
Object Name: CST_PAC_ITEM_COSTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_PAC_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
COST_LAYER_ID NUMBER
Yes
PL_MATERIAL NUMBER

PL_MATERIAL_OVERHEAD NUMBER

PL_RESOURCE NUMBER

PL_OUTSIDE_PROCESSING NUMBER

PL_OVERHEAD NUMBER

TL_MATERIAL NUMBER

TL_MATERIAL_OVERHEAD NUMBER

TL_RESOURCE NUMBER

TL_OUTSIDE_PROCESSING NUMBER

TL_OVERHEAD NUMBER

MATERIAL_COST NUMBER

MATERIAL_OVERHEAD_COST NUMBER

RESOURCE_COST NUMBER

OUTSIDE_PROCESSING_COST NUMBER

OVERHEAD_COST NUMBER

PL_ITEM_COST NUMBER

TL_ITEM_COST NUMBER

ITEM_COST NUMBER

ITEM_BUY_COST NUMBER

ITEM_MAKE_COST NUMBER

UNBURDENED_COST NUMBER

BURDEN_COST NUMBER

Query Text

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


SELECT COST_LAYER_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
,      ITEM_BUY_COST
,      ITEM_MAKE_COST
,      UNBURDENED_COST
,      BURDEN_COST
FROM APPS.CST_PAC_ITEM_COSTS_V;

Dependencies

[top of page]

APPS.CST_PAC_ITEM_COSTS_V references the following:

SchemaAPPS
SynonymCST_PAC_ITEM_COST_DETAILS
APPS.CST_PAC_ITEM_COSTS_V is referenced by following:

SchemaAPPS
Package BodyCSTPPWAC - show dependent code