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

TABLE: GCS.GCS_INTERCO_HDR_GT

Object Details
Object Name: GCS_INTERCO_HDR_GT
Object Type: TABLE
Owner: GCS
Subobject Name:
Status: VALID

Temporary Table Details

GCS.GCS_INTERCO_HDR_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
GCS_INTERCO_HDR_GT_N1 NORMAL NONUNIQUE Tablespace ColumnSOURCE_ENTITY_ID
GCS_INTERCO_HDR_GT_N2 NORMAL NONUNIQUE Tablespace ColumnTARGET_ENTITY_ID
Columns
Name Datatype Length Mandatory Comments
ENTRY_ID NUMBER (15)
Foreign key to the Entry defining column
SOURCE_ENTITY_ID NUMBER

Source entity identfying column
TARGET_ENTITY_ID NUMBER

Target entity identfying column
RULE_ID NUMBER (15)
Foreign key to the intercompany rule defining column
THRESHOLD_AMOUNT NUMBER

Threshold amount
THRESHOLD_CURRENCY VARCHAR2 (30)
Threshold amount currency
CURRENCY_CODE VARCHAR2 (15)
Currency code
CONVERSION_RATE NUMBER

Conversion rate
SUS_FINANCIAL_ELEM_ID NUMBER

Foreign key to the Financial Element dimension
SUS_PRODUCT_ID NUMBER

Foreign key to the Product dimension
SUS_NATURAL_ACCOUNT_ID NUMBER

Foreign key to the Natural Account dimension
SUS_CHANNEL_ID NUMBER

Foreign key to the Channel dimension
SUS_LINE_ITEM_ID NUMBER

Foreign key to the Line Item dimension
SUS_PROJECT_ID NUMBER

Foreign key to the Project dimension
SUS_CUSTOMER_ID NUMBER

Foreign key to the Customer dimension
SUS_TASK_ID NUMBER

Foreign key to the Task dimension
SUS_USER_DIM1_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM2_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM3_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM4_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM5_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM6_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM7_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM8_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM9_ID NUMBER

Foreign key to user defined dimension
SUS_USER_DIM10_ID NUMBER

Foreign key to user defined dimension
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 ENTRY_ID
,      SOURCE_ENTITY_ID
,      TARGET_ENTITY_ID
,      RULE_ID
,      THRESHOLD_AMOUNT
,      THRESHOLD_CURRENCY
,      CURRENCY_CODE
,      CONVERSION_RATE
,      SUS_FINANCIAL_ELEM_ID
,      SUS_PRODUCT_ID
,      SUS_NATURAL_ACCOUNT_ID
,      SUS_CHANNEL_ID
,      SUS_LINE_ITEM_ID
,      SUS_PROJECT_ID
,      SUS_CUSTOMER_ID
,      SUS_TASK_ID
,      SUS_USER_DIM1_ID
,      SUS_USER_DIM2_ID
,      SUS_USER_DIM3_ID
,      SUS_USER_DIM4_ID
,      SUS_USER_DIM5_ID
,      SUS_USER_DIM6_ID
,      SUS_USER_DIM7_ID
,      SUS_USER_DIM8_ID
,      SUS_USER_DIM9_ID
,      SUS_USER_DIM10_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM GCS.GCS_INTERCO_HDR_GT;

Dependencies

[top of page]

GCS.GCS_INTERCO_HDR_GT does not reference any database object

GCS.GCS_INTERCO_HDR_GT is referenced by following:

SchemaAPPS
SynonymGCS_INTERCO_HDR_GT