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: GCS.GCS_HIER_MEMBERS_T

Object Details

Object Name:	GCS_HIER_MEMBERS_T
Object Type:	TABLE
Owner:	GCS
FND Design Data:	GCS.GCS_HIER_MEMBERS_T
Subobject Name:
Status:	VALID

GCS_HIER_MEMBERS_T stores dimension hierarchies data to be loaded into FEM schema.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
SEQUENCE_NUM	NUMBER	(15)	Yes	Sequence number
PARENT_VS_DISPLAY_CODE	VARCHAR2	(150)	Yes	Parent value set display code
PARENT_DISPLAY_CODE	VARCHAR2	(150)		Parent display code
CHILD_VS_DISPLAY_CODE	VARCHAR2	(150)	Yes	Child value set display code
CHILD_DISPLAY_CODE	VARCHAR2	(150)	Yes	Child display code
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Change defining column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT SEQUENCE_NUM
,      PARENT_VS_DISPLAY_CODE
,      PARENT_DISPLAY_CODE
,      CHILD_VS_DISPLAY_CODE
,      CHILD_DISPLAY_CODE
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM GCS.GCS_HIER_MEMBERS_T;

Dependencies

[top of page]

GCS.GCS_HIER_MEMBERS_T does not reference any database object

GCS.GCS_HIER_MEMBERS_T is referenced by following:

APPS: GCS_HIER_MEMBERS_T