[Home] [Help]
View: EAM_CONTROL_EVENT_V
Product: | EAM - Enterprise Asset Management |
Description: | This view provides information of System Events for which Asset Operation Log is required with an Organization Context. |
Implementation/DBA Data: |
APPS.EAM_CONTROL_EVENT_V
|
View Text
SELECT ECE.ROWID AS ROW_ID
, ECE.ORGANIZATION_ID
, ECE.EVENT_TYPE
, ECE.EVENT_ID
, ML.MEANING
, ECE.CREATED_BY
, ECE.CREATION_DATE
, ECE.LAST_UPDATED_BY
, ECE.LAST_UPDATE_DATE
, ECE.LAST_UPDATE_LOGIN
FROM EAM_CONTROL_EVENT ECE
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_TYPE IN ('EAM_SYSTEM_EVENTS'
, 'OPERATIONAL_SYSTEM_EVENTS')
AND ECE.EVENT_TYPE=ML.LOOKUP_TYPE
AND ECE.EVENT_ID=ML.LOOKUP_CODE
Columns
Name |
ROW_ID |
ORGANIZATION_ID |
EVENT_TYPE |
EVENT_ID |
MEANING |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |