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_OPP_STATUS_M_IV

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

View Text

SELECT ROWID ROW_ID
, L1_OPPSTATUS_PK_KEY
, L0_ALL_PK_KEY
, L1_USER_ATTRIBUTE5
, L1_USER_ATTRIBUTE4
, L1_USER_ATTRIBUTE3
, L1_USER_ATTRIBUTE2
, L1_USER_ATTRIBUTE1
, L1_STATUS_CODE
, L1_OPPSTATUS_PK
, L1_OPPSTATUS_DP
, L1_NAME
, L1_MEANING
, L1_INSTANCE
, L1_DESCRIPTION
, L1_OPEN_STATUS_FLAG
, L1_FORECAST_ROLLUP_FLAG
, L1_WIN_LOSS_INDICATOR
, L0_NAME
, L0_ALL_PK
, L1_LAST_UPDATE_DATE
, L1_CREATION_DATE
, SECURITY_GROUP_ID
, L1_USER_ATTRIBUTE5 OPERATION_CODE
FROM EDW_BIM_OPP_STATUS_M

Columns

Name
ROW_ID
L1_OPPSTATUS_PK_KEY
L0_ALL_PK_KEY
L1_USER_ATTRIBUTE5
L1_USER_ATTRIBUTE4
L1_USER_ATTRIBUTE3
L1_USER_ATTRIBUTE2
L1_USER_ATTRIBUTE1
L1_STATUS_CODE
L1_OPPSTATUS_PK
L1_OPPSTATUS_DP
L1_NAME
L1_MEANING
L1_INSTANCE
L1_DESCRIPTION
L1_OPEN_STATUS_FLAG
L1_FORECAST_ROLLUP_FLAG
L1_WIN_LOSS_INDICATOR
L0_NAME
L0_ALL_PK
L1_LAST_UPDATE_DATE
L1_CREATION_DATE
SECURITY_GROUP_ID
OPERATION_CODE