eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: EDW_OPI_ACTV_ACTV_LCV

Product:	OPI - Operations Intelligence (Obsolete)
Description:	Sources All Activities from Descrete and Process
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT 'ALL'
, ACTIVITY||'-'||I.INSTANCE_CODE||'-OPM'
, 'ACTV'
, ACTIVITY
, ACTIVITY
, ACTIVITY
, ACTIVITY_DESC
, COST_ANALYSIS_CODE
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, FA.LAST_UPDATE_DATE
, FA.CREATION_DATE
FROM FM_ACTV_MST FA
, EDW_LOCAL_INSTANCE I UNION SELECT 'ALL'
, CA.ACTIVITY_ID || '-' || INST.INSTANCE_CODE || '-OPI' ACTV_PK
, 'ACTV' ACTV_DP
, CA.ACTIVITY ACTV_CODE
, CA.ACTIVITY NAME
, CA.ACTIVITY ACTV_NAME
, CA.DESCRIPTION DESCRIPTION
, NULL COST_ANALYSIS_CODE
, DECODE(CA.VALUE_ADDED_ACTIVITY_FLAG
, 'YES'
, 1
, 'NO'
, 0
, TO_NUMBER(NULL)) VALUE_ADDED
, TO_CHAR(NULL) USER_ATTRIBUTE1
, TO_CHAR(NULL) USER_ATTRIBUTE2
, TO_CHAR(NULL) USER_ATTRIBUTE3
, TO_CHAR(NULL) USER_ATTRIBUTE4
, TO_CHAR(NULL) USER_ATTRIBUTE5
, CA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CA.CREATION_DATE CREATION_DATE
FROM CST_ACTIVITIES CA
, EDW_LOCAL_INSTANCE INST

Columns

Name
ALL_FK
ACTV_PK
ACTV_DP
ACTV_CODE
NAME
ACTV_NAME
DESCRIPTION
COST_ANALYSIS_CODE
VALUE_ADDED
USER_ATTRIBUTE1
USER_ATTRIBUTE2
USER_ATTRIBUTE3
USER_ATTRIBUTE4
USER_ATTRIBUTE5
LAST_UPDATE_DATE
CREATION_DATE