[Home] [Help] [Dependency Information]
Object Name: | BIM_DIMV_MARKET_SGMTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIM.BIM_DIMV_MARKET_SGMTS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BIM_DIMV_MARKET_SGMTS is a view showing all market segments.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MARKET_SEGMENT_ID | NUMBER | AMS_CELLS_VL.CELL_ID | ||
MARKET_SEGMENT_CODE | VARCHAR2 | (30) | AMS_CELLS_VL.CELL_CODE | |
MARKET_SEGMENT_ORIGINAL_SIZE | NUMBER | AMS_CELLS_VL.ORIGINAL_SIZE | ||
ENABLED_FLAG | VARCHAR2 | (1) | AMS_CELLS_VL.ENABLED_FLAG | |
MARKET_SEGMENT_NAME | VARCHAR2 | (120) | AMS_CELLS_VL.CELL_NAME | |
DESCRIPTION | VARCHAR2 | (4000) | AMS_CELLS_VL.DESCRIPTION |
Cut, paste (and edit) the following text to query this object:
SELECT MARKET_SEGMENT_ID
, MARKET_SEGMENT_CODE
, MARKET_SEGMENT_ORIGINAL_SIZE
, ENABLED_FLAG
, MARKET_SEGMENT_NAME
, DESCRIPTION
FROM APPS.BIM_DIMV_MARKET_SGMTS;
|
|
|