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

VIEW: APPS.CST_QUANTITY_LAYERS_V

Object Details
Object Name: CST_QUANTITY_LAYERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_QUANTITY_LAYERS_V
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
LAYER_ID NUMBER
Yes Unique layer identifier generated by the sequence CST_QUANTITY_LAYERS_S.
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.
ITEM_COST NUMBER

Layer item 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 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
,      UNBURDENED_COST
,      BURDEN_COST
FROM APPS.CST_QUANTITY_LAYERS_V;

Dependencies

[top of page]

APPS.CST_QUANTITY_LAYERS_V references the following:

SchemaAPPS
SynonymCST_LAYER_COST_DETAILS
APPS.CST_QUANTITY_LAYERS_V is referenced by following:

SchemaAPPS
Package BodyCSTPLENG - show dependent code