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_DATA_SUB_DTLS

Object Details

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

GCS_DATA_SUB_DTLS stores header level information regarding pristine data loads submitted by end-users, which impact their pristine data in FEM_BALANCES.

GCS_DATA_SUB_DTLS stores Acquisition and Disposal transaction control records as they relate to changes in consolidation hierarchies. Each record in GCS_AD_TRANSACTIONS has several GCS_AD_TRIAL_BALANCES records.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GCS_DATA_SUB_DTLS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOAD_ID
SYS_IL0000399869C00013$$	LOB	UNIQUE	APPS_TS_TX_DATA
GCS_DATA_SUB_DTLS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSOCIATED_REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LOAD_ID	NUMBER	(15)	Yes	Load defining column
LOAD_NAME	VARCHAR2	(50)	Yes	User-Defined Load Name
ENTITY_ID	NUMBER		Yes	Entity defining column
CAL_PERIOD_ID	NUMBER		Yes	Calendar Period defining column
CURRENCY_CODE	VARCHAR2	(30)		Currency Code defining column
BALANCE_TYPE_CODE	VARCHAR2	(30)	Yes	Balance Type defining column
LOAD_METHOD_CODE	VARCHAR2	(30)	Yes	Load Methods defining column
CURRENCY_TYPE_CODE	VARCHAR2	(30)	Yes	Currency Options defining column
AMOUNT_TYPE_CODE	VARCHAR2	(30)	Yes	Amount Type defining column
MEASURE_TYPE_CODE	VARCHAR2	(30)	Yes	Measure Type defining column
RULE_SET_ID	NUMBER	(15)		Interface Data Transformer Rule Set defining column
NOTIFY_OPTIONS_CODE	VARCHAR2	(30)	Yes	Notification Options defining column
NOTIFICATION_TEXT	CLOB	(4000)		Notification Text
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
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Change defining column
START_TIME	DATE		Yes	Start Time
END_TIME	DATE			End Time
STATUS_CODE	VARCHAR2	(30)	Yes	Status Code
LOCKED_FLAG	VARCHAR2	(1)	Yes	Locked Data defining column
MOST_RECENT_FLAG	VARCHAR2	(1)	Yes	Most recent flag
ASSOCIATED_REQUEST_ID	NUMBER	(15)		Associated Concurrent Request
VALIDATION_RULE_SET_ID	NUMBER	(15)		Validation Rule Set Defining column
BALANCES_RULE_ID	NUMBER	(9)		Balances Rule Defining Column

Query Text

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


SELECT LOAD_ID
,      LOAD_NAME
,      ENTITY_ID
,      CAL_PERIOD_ID
,      CURRENCY_CODE
,      BALANCE_TYPE_CODE
,      LOAD_METHOD_CODE
,      CURRENCY_TYPE_CODE
,      AMOUNT_TYPE_CODE
,      MEASURE_TYPE_CODE
,      RULE_SET_ID
,      NOTIFY_OPTIONS_CODE
,      NOTIFICATION_TEXT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      START_TIME
,      END_TIME
,      STATUS_CODE
,      LOCKED_FLAG
,      MOST_RECENT_FLAG
,      ASSOCIATED_REQUEST_ID
,      VALIDATION_RULE_SET_ID
,      BALANCES_RULE_ID
FROM GCS.GCS_DATA_SUB_DTLS;

Dependencies

[top of page]

GCS.GCS_DATA_SUB_DTLS does not reference any database object

GCS.GCS_DATA_SUB_DTLS is referenced by following:

APPS: GCS_DATA_SUB_DTLS