[Home] [Help]
[Dependency Information]
Object Name: | MSC_ITEM_FAILURE_RATES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
This table contains item failure rate information used in planning
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_ITEM_FAILURE_RATES_U1 | NORMAL | UNIQUE |
![]() |
![]() |
MSC_ITEM_FAILURE_RATES_N1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FAILURE_RATE_ID | NUMBER | Yes | Failure Rate Identifier | |
USING_ASSEMBLY_ID | NUMBER | Yes | Using Assembly Identifier | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Identifier | |
FAILURE_RATE | NUMBER | Yes | Failure Rate | |
RETIREMENT_RATE | NUMBER | Retirement Rate | ||
COLLECTED_FLAG | NUMBER | Yes | Collected Flag | |
LAST_UPDATE_DATE | VARCHAR2 | (240) | Yes | Last Update Date |
LAST_UPDATED_BY | NUMBER | Yes | Last Updated By | |
CREATION_DATE | DATE | Yes | Creation Date | |
CREATED_BY | NUMBER | Yes | Created By | |
LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
RETURN_RATE | NUMBER | Return Rate | ||
CURRENT_INSTALL_BASE | VARCHAR2 | (240) | Current Install Base | |
ITEM_NAME | VARCHAR2 | (240) | Item Name | |
USING_ASSEMBLY_NAME | VARCHAR2 | (240) | Using Assembly Name | |
PROCESS_FLAG | VARCHAR2 | (240) | Process Flag |
Cut, paste (and edit) the following text to query this object:
SELECT FAILURE_RATE_ID
, USING_ASSEMBLY_ID
, INVENTORY_ITEM_ID
, FAILURE_RATE
, RETIREMENT_RATE
, COLLECTED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RETURN_RATE
, CURRENT_INSTALL_BASE
, ITEM_NAME
, USING_ASSEMBLY_NAME
, PROCESS_FLAG
FROM MSC.MSC_ITEM_FAILURE_RATES;
MSC.MSC_ITEM_FAILURE_RATES does not reference any database object
MSC.MSC_ITEM_FAILURE_RATES is referenced by following:
|
|
|