DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.BIM_DIMV_TARGET_SGMTS

Object Details
Object Name: BIM_DIMV_TARGET_SGMTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIM.BIM_DIMV_TARGET_SGMTS
Subobject Name:
Status: VALID

View Type

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.
.


[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.BIM_DIMV_TARGET_SGMTS references the following:

SchemaAPPS
SynonymAMS_CELLS_ALL_B
SynonymAMS_CELLS_ALL_TL
SynonymBIM_I_SGMT_DENORM
APPS.BIM_DIMV_TARGET_SGMTS is referenced by following:

SchemaAPPS
ViewBIM_SUMV_CAMP_RESP
ViewBIM_SUMV_SLIST_PERF