[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
GCS.GCS_DATA_SUB_DTLS does not reference any database object
GCS.GCS_DATA_SUB_DTLS is referenced by following:
|
|
|