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_BIM_CMPSTATS_M_IV

Product:	BIM - Marketing Intelligence(Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ROWID ROW_ID
, L0_ALL_PK_KEY
, L0_ALL_PK
, L0_NAME
, L1_CMPGN_STATUS_PK_KEY
, L1_CMPGN_STATUS_PK
, L1_CMPGN_STATUS_DP
, L1_NAME
, L1_CMPGN_STATUS_ID
, L1_USER_ATTRIBUTE5
, L1_USER_ATTRIBUTE4
, L1_USER_ATTRIBUTE3
, L1_USER_ATTRIBUTE2
, L1_USER_ATTRIBUTE1
, L1_SYSTEM_STATUS_TYPE
, L1_SYSTEM_STATUS_CODE
, L1_INSTANCE
, L1_ENABLED_FLAG
, L1_DESCRIPTION
, L1_CMPGN_STATUS_NAME
, L1_DEFAULT_FLAG
, L1_SEEDED_FLAG
, L1_START_DATE_ACTIVE
, L1_LAST_UPDATE_DATE
, L1_END_DATE_ACTIVE
, L1_CREATION_DATE
, SECURITY_GROUP_ID
, L1_USER_ATTRIBUTE5 OPERATION_CODE
FROM EDW_BIM_CMPSTATS_M

Columns

Name
ROW_ID
L0_ALL_PK_KEY
L0_ALL_PK
L0_NAME
L1_CMPGN_STATUS_PK_KEY
L1_CMPGN_STATUS_PK
L1_CMPGN_STATUS_DP
L1_NAME
L1_CMPGN_STATUS_ID
L1_USER_ATTRIBUTE5
L1_USER_ATTRIBUTE4
L1_USER_ATTRIBUTE3
L1_USER_ATTRIBUTE2
L1_USER_ATTRIBUTE1
L1_SYSTEM_STATUS_TYPE
L1_SYSTEM_STATUS_CODE
L1_INSTANCE
L1_ENABLED_FLAG
L1_DESCRIPTION
L1_CMPGN_STATUS_NAME
L1_DEFAULT_FLAG
L1_SEEDED_FLAG
L1_START_DATE_ACTIVE
L1_LAST_UPDATE_DATE
L1_END_DATE_ACTIVE
L1_CREATION_DATE
SECURITY_GROUP_ID
OPERATION_CODE