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: BIM.EDW_BIM_CMPSTATS_M#

Source

View Text - Preformatted


select L1_CMPGN_STATUS_PK_KEY L1_CMPGN_STATUS_PK_KEY, L0_ALL_PK_KEY L0_ALL_PK_KEY, L0_ALL_PK L0_ALL_PK, L0_NAME L0_NAME, L1_CMPGN_STATUS_PK L1_CMPGN_STATUS_PK, L1_CMPGN_STATUS_DP L1_CMPGN_STATUS_DP, L1_NAME L1_NAME, L1_CMPGN_STATUS_ID L1_CMPGN_STATUS_ID, L1_SYSTEM_STATUS_CODE L1_SYSTEM_STATUS_CODE, L1_SYSTEM_STATUS_TYPE L1_SYSTEM_STATUS_TYPE, L1_ENABLED_FLAG L1_ENABLED_FLAG, L1_DEFAULT_FLAG L1_DEFAULT_FLAG, L1_SEEDED_FLAG L1_SEEDED_FLAG, L1_START_DATE_ACTIVE L1_START_DATE_ACTIVE, L1_END_DATE_ACTIVE L1_END_DATE_ACTIVE, L1_CMPGN_STATUS_NAME L1_CMPGN_STATUS_NAME, L1_DESCRIPTION L1_DESCRIPTION, L1_INSTANCE L1_INSTANCE, L1_USER_ATTRIBUTE1 L1_USER_ATTRIBUTE1, L1_USER_ATTRIBUTE2 L1_USER_ATTRIBUTE2, L1_USER_ATTRIBUTE3 L1_USER_ATTRIBUTE3, L1_USER_ATTRIBUTE4 L1_USER_ATTRIBUTE4, L1_USER_ATTRIBUTE5 L1_USER_ATTRIBUTE5, L1_LAST_UPDATE_DATE L1_LAST_UPDATE_DATE, L1_CREATION_DATE L1_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE from "BIM"."EDW_BIM_CMPSTATS_M"

View Text - HTML Formatted

SELECT L1_CMPGN_STATUS_PK_KEY L1_CMPGN_STATUS_PK_KEY
, L0_ALL_PK_KEY L0_ALL_PK_KEY
, L0_ALL_PK L0_ALL_PK
, L0_NAME L0_NAME
, L1_CMPGN_STATUS_PK L1_CMPGN_STATUS_PK
, L1_CMPGN_STATUS_DP L1_CMPGN_STATUS_DP
, L1_NAME L1_NAME
, L1_CMPGN_STATUS_ID L1_CMPGN_STATUS_ID
, L1_SYSTEM_STATUS_CODE L1_SYSTEM_STATUS_CODE
, L1_SYSTEM_STATUS_TYPE L1_SYSTEM_STATUS_TYPE
, L1_ENABLED_FLAG L1_ENABLED_FLAG
, L1_DEFAULT_FLAG L1_DEFAULT_FLAG
, L1_SEEDED_FLAG L1_SEEDED_FLAG
, L1_START_DATE_ACTIVE L1_START_DATE_ACTIVE
, L1_END_DATE_ACTIVE L1_END_DATE_ACTIVE
, L1_CMPGN_STATUS_NAME L1_CMPGN_STATUS_NAME
, L1_DESCRIPTION L1_DESCRIPTION
, L1_INSTANCE L1_INSTANCE
, L1_USER_ATTRIBUTE1 L1_USER_ATTRIBUTE1
, L1_USER_ATTRIBUTE2 L1_USER_ATTRIBUTE2
, L1_USER_ATTRIBUTE3 L1_USER_ATTRIBUTE3
, L1_USER_ATTRIBUTE4 L1_USER_ATTRIBUTE4
, L1_USER_ATTRIBUTE5 L1_USER_ATTRIBUTE5
, L1_LAST_UPDATE_DATE L1_LAST_UPDATE_DATE
, L1_CREATION_DATE L1_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "BIM"."EDW_BIM_CMPSTATS_M"