[Home] [Help]
View: CSP_FAILURE_RATES_V
Product: | CSP - Spares Management |
Description: | Lists failure rates for components of a product |
Implementation/DBA Data: |
APPS.CSP_FAILURE_RATES_V
|
View Text
SELECT FAILURE_RATE_ID
, PRODUCT_ID
, INVENTORY_ITEM_ID
, ROUND(CALCULATED_FAILURE_RATE
, 5) CALCULATED_FAILURE_RATE
, ROUND(MANUAL_FAILURE_RATE
, 5) MANUAL_FAILURE_RATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, PLANNING_PARAMETERS_ID
FROM CSP_FAILURE_RATES
Columns
Name |
FAILURE_RATE_ID |
PRODUCT_ID |
INVENTORY_ITEM_ID |
CALCULATED_FAILURE_RATE |
MANUAL_FAILURE_RATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
SECURITY_GROUP_ID |
PLANNING_PARAMETERS_ID |