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

VIEW: APPS.CSTBV_PAC_QUANTITY_LAYERS

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

View Type

A Business Intelligence System view


This shows the layer quantity of an item by period.
The QUANTITY_LAYER_ID is unique for a period and cost layer combination. In periodic LIFO method, multiple layer may exist in the same period. On the other hand, only one layer exists in each period for periodic weighted average costing method.


[View Source]

Columns
Name Datatype Length Mandatory Comments
QUANTITY_LAYER_ID NUMBER
Yes
COST_LAYER_ID NUMBER
Yes
PAC_PERIOD_ID NUMBER
Yes
COST_GROUP_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
LAYER_QUANTITY NUMBER

BEGIN_LAYER_QUANTITY NUMBER

PAC_PERIOD_NAME VARCHAR2 (15) Yes
COST_GROUP_NAME VARCHAR2 (10) Yes
_KF:ITEM_NAME CHAR (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
UPDATED_BY NUMBER
Yes
Query Text

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


SELECT QUANTITY_LAYER_ID
,      COST_LAYER_ID
,      PAC_PERIOD_ID
,      COST_GROUP_ID
,      INVENTORY_ITEM_ID
,      LAYER_QUANTITY
,      BEGIN_LAYER_QUANTITY
,      PAC_PERIOD_NAME
,      COST_GROUP_NAME
,      _KF:ITEM_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      UPDATED_BY
FROM APPS.CSTBV_PAC_QUANTITY_LAYERS;

Dependencies

[top of page]

APPS.CSTBV_PAC_QUANTITY_LAYERS references the following:

SchemaAPPS
SynonymCST_COST_GROUPS
SynonymCST_PAC_PERIODS
SynonymCST_PAC_QUANTITY_LAYERS
SynonymMTL_SYSTEM_ITEMS

APPS.CSTBV_PAC_QUANTITY_LAYERS is not referenced by any database object