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_TGST_TGSMT_L8_LCV

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

View Text

SELECT AMC.CELL_CODE || '-' || INST.INSTANCE_CODE TGTSGMT_PK
, 'ALL' ALL_FK
, AMC.CELL_NAME TGTSGMT_DP
, AMC.CELL_NAME NAME
, AMC.CELL_ID TGTSGMT_ID
, AMC.CELL_CODE TGTSGMT_CODE
, AMC.MARKET_SEGMENT_FLAG MARKET_SEGMENT_FLAG
, AMC.ENABLED_FLAG ENABLED_FLAG
, AMC.ORIGINAL_SIZE ORIGINAL_SIZE
, AMC.CELL_NAME TGTSGMT_NAME
, AMC.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, AMC.CREATION_DATE CREATION_DATE
, AMC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM AMS_CELLS_VL AMC
, EDW_BIM_TGSMT_DENORM BTD
, EDW_LOCAL_INSTANCE INST
WHERE AMC.CELL_ID = BTD.TARGET_SEGMENT_ID
AND BTD.LEVEL_FROM_ROOT = 0 WITH READ ONLY

Columns

Name
TGTSGMT_PK
ALL_FK
TGTSGMT_DP
NAME
TGTSGMT_ID
TGTSGMT_CODE
MARKET_SEGMENT_FLAG
ENABLED_FLAG
ORIGINAL_SIZE
TGTSGMT_NAME
DESCRIPTION
INSTANCE
CREATION_DATE
LAST_UPDATE_DATE