[Home] [Help]
View: BIM_DIMV_TARGET_SGMTS
Product: | BIM - Marketing Intelligence(Obsolete) |
Description: | Shows all target segments. |
Implementation/DBA Data: |
APPS.BIM_DIMV_TARGET_SGMTS
|
View Text
SELECT TO_CHAR(AMC.CELL_ID)
, SUBSTR(AMC.CELL_NAME
, 1
, 80)
, AMC.CELL_ID TARGET_SEGMENT_ID
, AMC.CELL_CODE TARGET_SEGMENT_CODE
, AMC.CELL_NAME TARGET_SEGMENT_NAME
, AMC.DESCRIPTION DESCRIPTION
, AMC.ORIGINAL_SIZE ORIGINAL_SIZE
, AMC.PARENT_CELL_ID PARENT_TARGET_SEGMENT_ID
, AMC.ENABLED_FLAG ENABLED_FLAG
FROM AMS_CELLS_VL AMC
WHERE AMC.MARKET_SEGMENT_FLAG <> 'Y' UNION ALL SELECT '-999'
, MEANING
, -999
, MEANING
, MEANING
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY
Columns
Name |
ID |
VALUE |
TARGET_SEGMENT_ID |
TARGET_SEGMENT_CODE |
TARGET_SEGMENT_NAME |
DESCRIPTION |
ORIGINAL_SIZE |
PARENT_TARGET_SEGMENT_ID |
ENABLED_FLAG |