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

VIEW: APPS.CSTBV_PAC_ITEM_COST_DETAILS

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

View Type

A Business Intelligence System view


This shows the details of the cost of an item in a period and cost group. The costs are stored by element and level.


[View Source]

Columns
Name Datatype Length Mandatory Comments
COST_LAYER_ID NUMBER
Yes
COST_ELEMENT_ID NUMBER
Yes
LEVEL_TYPE_ID NUMBER
Yes
PAC_PERIOD_ID NUMBER
Yes
COST_GROUP_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
ITEM_COST NUMBER
Yes
ITEM_BUY_COST NUMBER

ITEM_MAKE_COST NUMBER

COST_ELEMENT_NAME VARCHAR2 (50) Yes
_LA:LEVEL_TYPE CHAR (50)
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 COST_LAYER_ID
,      COST_ELEMENT_ID
,      LEVEL_TYPE_ID
,      PAC_PERIOD_ID
,      COST_GROUP_ID
,      INVENTORY_ITEM_ID
,      ITEM_COST
,      ITEM_BUY_COST
,      ITEM_MAKE_COST
,      COST_ELEMENT_NAME
,      _LA:LEVEL_TYPE
,      PAC_PERIOD_NAME
,      COST_GROUP_NAME
,      _KF:ITEM_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      UPDATED_BY
FROM APPS.CSTBV_PAC_ITEM_COST_DETAILS;

Dependencies

[top of page]

APPS.CSTBV_PAC_ITEM_COST_DETAILS references the following:

SchemaAPPS
SynonymCST_COST_ELEMENTS
SynonymCST_COST_GROUPS
SynonymCST_PAC_ITEM_COSTS
SynonymCST_PAC_ITEM_COST_DETAILS
SynonymCST_PAC_PERIODS
SynonymMTL_SYSTEM_ITEMS

APPS.CSTBV_PAC_ITEM_COST_DETAILS is not referenced by any database object