FND Design Data [Home] [Help]

View: CSP_FAILURE_RATES_V

Product: CSP - Spares Management
Description: Lists failure rates for components of a product
Implementation/DBA Data: ViewAPPS.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