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

TABLE: GCS.GCS_CURR_TREATMENTS_B

Object Details
Object Name: GCS_CURR_TREATMENTS_B
Object Type: TABLE
Owner: GCS
FND Design Data: TableGCS.GCS_CURR_TREATMENTS_B
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: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GCS_CURR_TREATMENTS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCURR_TREATMENT_ID
Columns
Name Datatype Length Mandatory Comments
CURR_TREATMENT_ID NUMBER (15) Yes Currency Treatment defining column
ENDING_RATE_TYPE VARCHAR2 (30) Yes Ending Rate Type
AVERAGE_RATE_TYPE VARCHAR2 (30) Yes Average Rate Type
EQUITY_MODE_CODE VARCHAR2 (30) Yes Equity Account Mode
INC_STMT_MODE_CODE VARCHAR2 (30) Yes Income Statement Account Mode
ENABLED_FLAG VARCHAR2 (1) Yes Enabled Flag
DEFAULT_FLAG VARCHAR2 (1) Yes Default Flag
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
FINANCIAL_ELEM_ID NUMBER

Foreign Key to Financial Element defining column
PRODUCT_ID NUMBER

Foreign Key to Product defining column
NATURAL_ACCOUNT_ID NUMBER

Foreign Key to Natural Account defining column
CHANNEL_ID NUMBER

Foreign Key to Channel defining column
LINE_ITEM_ID NUMBER

Foreign Key to Line Item defining column
PROJECT_ID NUMBER

Foreign Key to Project defining column
CUSTOMER_ID NUMBER

Foreign Key to Customer defining column
CTA_USER_DIM1_ID NUMBER

Foreign Key to User Dim1 defining column
CTA_USER_DIM2_ID NUMBER

Foreign Key to User Dim2 defining column
CTA_USER_DIM3_ID NUMBER

Foreign Key to User Dim3 defining column
CTA_USER_DIM4_ID NUMBER

Foreign Key to User Dim4 defining colunm
CTA_USER_DIM5_ID NUMBER

Foreign Key to User Dim5 defining column
CTA_USER_DIM6_ID NUMBER

Foreign Key to User Dim6 defining column
CTA_USER_DIM7_ID NUMBER

Foreign Key to User Dim7 defining column
CTA_USER_DIM8_ID NUMBER

Foreign Key to User Dim8 defining column
CTA_USER_DIM9_ID NUMBER

Foreign Key to User Dim9 defining column
CTA_USER_DIM10_ID NUMBER

Foreign Key to User Dim10 defining column
TASK_ID NUMBER

Foreign Key to Task defining column
OBJECT_VERSION_NUMBER NUMBER (15) Yes Version Identifier
Query Text

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


SELECT CURR_TREATMENT_ID
,      ENDING_RATE_TYPE
,      AVERAGE_RATE_TYPE
,      EQUITY_MODE_CODE
,      INC_STMT_MODE_CODE
,      ENABLED_FLAG
,      DEFAULT_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      FINANCIAL_ELEM_ID
,      PRODUCT_ID
,      NATURAL_ACCOUNT_ID
,      CHANNEL_ID
,      LINE_ITEM_ID
,      PROJECT_ID
,      CUSTOMER_ID
,      CTA_USER_DIM1_ID
,      CTA_USER_DIM2_ID
,      CTA_USER_DIM3_ID
,      CTA_USER_DIM4_ID
,      CTA_USER_DIM5_ID
,      CTA_USER_DIM6_ID
,      CTA_USER_DIM7_ID
,      CTA_USER_DIM8_ID
,      CTA_USER_DIM9_ID
,      CTA_USER_DIM10_ID
,      TASK_ID
,      OBJECT_VERSION_NUMBER
FROM GCS.GCS_CURR_TREATMENTS_B;

Dependencies

[top of page]

GCS.GCS_CURR_TREATMENTS_B does not reference any database object

GCS.GCS_CURR_TREATMENTS_B is referenced by following:

SchemaAPPS
SynonymGCS_CURR_TREATMENTS_B