[Home] [Help]
View: EAM_FAILURE_SET_ASSOCIATIONS_V
Product: | EAM - Enterprise Asset Management |
Description: | This view queries all active Failure Set - Item associations. |
Implementation/DBA Data: |
APPS.EAM_FAILURE_SET_ASSOCIATIONS_V
|
View Text
SELECT SET_ID
, INVENTORY_ITEM_ID
, FAILURE_CODE_REQUIRED
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, EFFECTIVE_END_DATE
FROM EAM_FAILURE_SET_ASSOCIATIONS
WHERE TRUNC(NVL(EFFECTIVE_END_DATE
, SYSDATE+1)) > TRUNC(SYSDATE)
Columns
Name |
SET_ID |
INVENTORY_ITEM_ID |
FAILURE_CODE_REQUIRED |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
EFFECTIVE_END_DATE |