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

VIEW: APPS.MSC_ITEM_BUDGETS_V

Object Details
Object Name: MSC_ITEM_BUDGETS_V
Object Type: VIEW
Owner: APPS
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
QUERY_ID NUMBER
Yes Query Id - internal
INVENTORY_ITEM_ID NUMBER

Item Id
BUDGET_VALUE NUMBER

Budget Value
INVENTORY_VALUE NUMBER

Inventory Value
PERCENT_INVENTORY_VALUE NUMBER

Percentage that this item is of the total inventory value
TARGET_SERVICE_LEVEL NUMBER

Target Service level
ACHIEVED_SERVICE_LEVEL NUMBER

Achieved Service level
TARGET_SAFETY_STOCK NUMBER

Target Service level
ACHIEVED_SAFETY_STOCK NUMBER

Achieved Safety Stock
BUCKET_DATE DATE

Bucket DATe
ITEM VARCHAR2 (400)
Item name
BUCKET_TYPE VARCHAR2 (80)
Weeks/Period bucket
Query Text

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


SELECT QUERY_ID
,      INVENTORY_ITEM_ID
,      BUDGET_VALUE
,      INVENTORY_VALUE
,      PERCENT_INVENTORY_VALUE
,      TARGET_SERVICE_LEVEL
,      ACHIEVED_SERVICE_LEVEL
,      TARGET_SAFETY_STOCK
,      ACHIEVED_SAFETY_STOCK
,      BUCKET_DATE
,      ITEM
,      BUCKET_TYPE
FROM APPS.MSC_ITEM_BUDGETS_V;

Dependencies

[top of page]

APPS.MSC_ITEM_BUDGETS_V references the following:

SchemaAPPS
SynonymMSC_FORM_QUERY

APPS.MSC_ITEM_BUDGETS_V is not referenced by any database object