[Home] [Help]
View: EDW_BIM_TGST_TGSMT_L2_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
, BTD.PARENT_TGTSGMT_CODE || '-' || INST.INSTANCE_CODE PARENT_TGTSGMT_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 = 6
AND BTD.IMMEDIATE_PARENT_FLAG = 'Y' UNION ALL SELECT BPTD.TGTSGMT_PK TGTSGMT_PK
, BPTD.TGTSGMT_PK PARENT_TGTSGMT_FK
, BPTD.TGTSGMT_DP TGTSGMT_DP
, BPTD.NAME NAME
, BPTD.TGTSGMT_ID TGTSGMT_ID
, BPTD.TGTSGMT_CODE TGTSGMT_CODE
, BPTD.MARKET_SEGMENT_FLAG MARKET_SEGMENT_FLAG
, BPTD.ENABLED_FLAG ENABLED_FLAG
, BPTD.ORIGINAL_SIZE ORIGINAL_SIZE
, BPTD.TGTSGMT_NAME TGTSGMT_NAME
, BPTD.DESCRIPTION DESCRIPTION
, BPTD.INSTANCE INSTANCE
, BPTD.CREATION_DATE CREATION_DATE
, BPTD.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM EDW_BIM_TGST_TGSMT_L3_LCV BPTD WITH READ ONLY
Columns
Name |
TGTSGMT_PK |
PARENT_TGTSGMT_FK |
TGTSGMT_DP |
NAME |
TGTSGMT_ID |
TGTSGMT_CODE |
MARKET_SEGMENT_FLAG |
ENABLED_FLAG |
ORIGINAL_SIZE |
TGTSGMT_NAME |
DESCRIPTION |
INSTANCE |
CREATION_DATE |
LAST_UPDATE_DATE |