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.

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

TABLE: BIM.EDW_BIM_TGSMT_DENORM

Object Details

Object Name:	EDW_BIM_TGSMT_DENORM
Object Type:	TABLE
Owner:	BIM
FND Design Data:	BIM.EDW_BIM_TGSMT_DENORM
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
TARGET_SEGMENT_ID	NUMBER		Yes	Unique Identifier for Target Segment .
PARENT_TARGET_SEGMENT_ID	NUMBER		Yes	Unique Identifier for Parent target segment .
CREATION_DATE	DATE		Yes	Standard Who Column .
CREATED_BY	NUMBER		Yes	Standard Who Column .
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column .
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column .
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column .
REQUEST_ID	NUMBER			Standard Who Column .
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column .
PROGRAM_ID	NUMBER			Standard Who Column .
PROGRAM_UPDATE_DATE	DATE			Standard Who Column .
TGTSGMT_CODE	VARCHAR2	(40)		Unique code of the target segment .
PARENT_TGTSGMT_CODE	VARCHAR2	(40)		Unique code of the parent target segment .
IMMEDIATE_PARENT_FLAG	VARCHAR2	(20)	Yes	"Y" indicates parent_target_segment_id is the immediate parent of target_segment_id .
ROOT_FLAG	VARCHAR2	(20)	Yes	"Y" indicates target_segment_id is at the root of the hierarchy .
LEVEL_FROM_PARENT	NUMBER		Yes	Number of Levels of the target_segment_id from the parent_target_segment_id .
LEVEL_FROM_ROOT	NUMBER		Yes	Number of Levels of the target_segment_id from the root .
PARENT_LEVEL_FROM_ROOT	NUMBER		Yes	Number of Levels of the parent_target_segment_id from the root .
SECURITY_GROUP_ID	NUMBER			Standard Who Column .

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TARGET_SEGMENT_ID
,      PARENT_TARGET_SEGMENT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TGTSGMT_CODE
,      PARENT_TGTSGMT_CODE
,      IMMEDIATE_PARENT_FLAG
,      ROOT_FLAG
,      LEVEL_FROM_PARENT
,      LEVEL_FROM_ROOT
,      PARENT_LEVEL_FROM_ROOT
,      SECURITY_GROUP_ID
FROM BIM.EDW_BIM_TGSMT_DENORM;

Dependencies

[top of page]

BIM.EDW_BIM_TGSMT_DENORM does not reference any database object

BIM.EDW_BIM_TGSMT_DENORM is referenced by following:

BIM: EDW_BIM_TGSMT_DENORM#