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_HISTORICAL_RATES

Object Details

Object Name:	GCS_HISTORICAL_RATES
Object Type:	TABLE
Owner:	GCS
FND Design Data:	GCS.GCS_HISTORICAL_RATES
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_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ENTITY_ID	NUMBER		Yes	Entity defining column
HIERARCHY_ID	NUMBER	(15)	Yes	Hierarchy defining column
CAL_PERIOD_ID	NUMBER		Yes	Calendar period identifying column
FROM_CURRENCY	VARCHAR2	(15)	Yes	From currency code
TO_CURRENCY	VARCHAR2	(15)	Yes	To currency code
COMPANY_COST_CENTER_ORG_ID	NUMBER			Organization dimension defining column
FINANCIAL_ELEM_ID	NUMBER			Financial element dimension defining column
PRODUCT_ID	NUMBER			Product dimension defining column
NATURAL_ACCOUNT_ID	NUMBER			Natural account dimension defining column
CHANNEL_ID	NUMBER			Channel dimension defining column
LINE_ITEM_ID	NUMBER			Line item dimension defining column
PROJECT_ID	NUMBER			Project dimension defining column
CUSTOMER_ID	NUMBER			Customer dimension defining column
INTERCOMPANY_ID	NUMBER			Intercompany dimension defining
TASK_ID	NUMBER			Task dimension defining column
USER_DIM1_ID	NUMBER			User-defined dimension defining column
USER_DIM2_ID	NUMBER			User-defined dimension defining column
USER_DIM3_ID	NUMBER			User-defined dimension defining column
USER_DIM4_ID	NUMBER			User-defined dimension defining column
USER_DIM5_ID	NUMBER			User-defined dimension defining column
USER_DIM6_ID	NUMBER			User-defined dimension defining column
USER_DIM7_ID	NUMBER			User-defined dimension defining column
USER_DIM8_ID	NUMBER			User-defined dimension defining column
USER_DIM9_ID	NUMBER			User-defined dimension defining column
USER_DIM10_ID	NUMBER			User-defined dimension defining column
TRANSLATED_RATE	NUMBER			Historical rate
TRANSLATED_AMOUNT	NUMBER			Historical amount
RATE_TYPE_CODE	VARCHAR2	(30)		Historical rate type
UPDATE_FLAG	VARCHAR2	(1)	Yes	Update flag
ACCOUNT_TYPE_CODE	VARCHAR2	(30)		Account type
STOP_ROLLFORWARD_FLAG	VARCHAR2	(1)	Yes	Stop roll forward year to date rate flag
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
STANDARD_RE_RATE_FLAG	VARCHAR2	(1)

Query Text

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


SELECT ENTITY_ID
,      HIERARCHY_ID
,      CAL_PERIOD_ID
,      FROM_CURRENCY
,      TO_CURRENCY
,      COMPANY_COST_CENTER_ORG_ID
,      FINANCIAL_ELEM_ID
,      PRODUCT_ID
,      NATURAL_ACCOUNT_ID
,      CHANNEL_ID
,      LINE_ITEM_ID
,      PROJECT_ID
,      CUSTOMER_ID
,      INTERCOMPANY_ID
,      TASK_ID
,      USER_DIM1_ID
,      USER_DIM2_ID
,      USER_DIM3_ID
,      USER_DIM4_ID
,      USER_DIM5_ID
,      USER_DIM6_ID
,      USER_DIM7_ID
,      USER_DIM8_ID
,      USER_DIM9_ID
,      USER_DIM10_ID
,      TRANSLATED_RATE
,      TRANSLATED_AMOUNT
,      RATE_TYPE_CODE
,      UPDATE_FLAG
,      ACCOUNT_TYPE_CODE
,      STOP_ROLLFORWARD_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      STANDARD_RE_RATE_FLAG
FROM GCS.GCS_HISTORICAL_RATES;

Dependencies

[top of page]

GCS.GCS_HISTORICAL_RATES does not reference any database object

GCS.GCS_HISTORICAL_RATES is referenced by following:

APPS: GCS_HISTORICAL_RATES