[Home] [Help]
[Dependency Information]
| Object Name: | BIM_DIMV_TARGET_SGMTS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | BIM.BIM_DIMV_TARGET_SGMTS
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BIM_DIMV_TARGET_SGMTS is a view showing all target segments.
.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID | NUMBER | id | ||
| VALUE | VARCHAR2 | (120) | value | |
| NODE | NUMBER | Node | ||
| TARGET_SEGMENT_ID | VARCHAR2 | (0) | the target segment id | |
| TARGET_SEGMENT_CODE | VARCHAR2 | (0) | The target segment code. | |
| TARGET_SEGMENT_NAME | VARCHAR2 | (0) | The target segment name | |
| DESCRIPTION | VARCHAR2 | (0) | Description of the target segment. | |
| ORIGINAL_SIZE | VARCHAR2 | (0) | The original size of the target segment. | |
| PARENT_ID | VARCHAR2 | (0) | The id of the parent segment of this target segment. | |
| ENABLED_FLAG | VARCHAR2 | (0) | The enables flag for the target segment. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, VALUE
, NODE
, TARGET_SEGMENT_ID
, TARGET_SEGMENT_CODE
, TARGET_SEGMENT_NAME
, DESCRIPTION
, ORIGINAL_SIZE
, PARENT_ID
, ENABLED_FLAG
FROM APPS.BIM_DIMV_TARGET_SGMTS;
APPS
AMS_CELLS_ALL_B
AMS_CELLS_ALL_TL
BIM_I_SGMT_DENORM
APPS
BIM_SUMV_CAMP_RESP
BIM_SUMV_SLIST_PERF
|
|
|
|