[Home] [Help]
[Dependency Information]
Object Name: | MSC_INVENTORY_BUDGET_VALUES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
This table contains budget values
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_INVENTORY_BUDGET_VALUES_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUDGET_ID | NUMBER | Yes | Budget Identifier | |
BUDGET_VALUE | NUMBER | Budget Value | ||
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
SR_INSTANCE_ID | NUMBER | Yes | Source Instance identifier | |
SR_CATEGORY_ID | NUMBER | Yes | Source Category Identifier | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
CREATION_DATE | DATE | Yes | Creation Date | |
LAST_UPDATED_BY | NUMBER | Yes | Last Updated by | |
CREATED_BY | NUMBER | Yes | Created by | |
LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
CATEGORY_INSTANCE_ID | NUMBER | Category Instance Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT BUDGET_ID
, BUDGET_VALUE
, ORGANIZATION_ID
, SR_INSTANCE_ID
, SR_CATEGORY_ID
, LAST_UPDATE_DATE
, CREATION_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, CATEGORY_INSTANCE_ID
FROM MSC.MSC_INVENTORY_BUDGET_VALUES;
MSC.MSC_INVENTORY_BUDGET_VALUES does not reference any database object
MSC.MSC_INVENTORY_BUDGET_VALUES is referenced by following:
|
|
|