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_MKSG_MKTSGMTS_LCV

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

View Text

SELECT AMC.CELL_CODE || '-' || INST.INSTANCE_CODE MKTSGMT_PK
, 'ALL' ALL_FK
, AMC.CELL_NAME MKTSGMT_DP
, AMC.CELL_NAME NAME
, AMC.CELL_ID MKTSGMT_ID
, AMC.CELL_CODE MKTSGMT_CODE
, AMC.ENABLED_FLAG ENABLED_FLAG
, AMC.CELL_NAME MKTSGMT_NAME
, AMC.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, AMC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AMC.CREATION_DATE CREATION_DATE
FROM AMS_CELLS_VL AMC
, EDW_LOCAL_INSTANCE INST
WHERE AMC.MARKET_SEGMENT_FLAG = 'Y' WITH READ ONLY

Columns

Name
MKTSGMT_PK
ALL_FK
MKTSGMT_DP
NAME
MKTSGMT_ID
MKTSGMT_CODE
ENABLED_FLAG
MKTSGMT_NAME
DESCRIPTION
INSTANCE
LAST_UPDATE_DATE
CREATION_DATE