[Home] [Help]
View: EDW_BIM_TGST_TGSMT_L8_LCV
Product: | BIM - Marketing Intelligence |
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 |