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_L3_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
, 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 = 5
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_L4_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