[Home] [Help] [Dependency Information]

TABLE: GCS.GCS_ENTRIES_GT

Object Details

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

Temporary Table Details

GCS.GCS_ENTRIES_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:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
GCS_ENTRIES_GT_N1	NORMAL	NONUNIQUE		RULE_ID STEP_SEQ

Columns

Query Text

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

SELECT RULE_ID
,      STEP_SEQ
,      STEP_NAME
,      FORMULA_TEXT
,      RULE_STEP_ID
,      CURRENCY_CODE
,      OFFSET_FLAG
,      SQL_STATEMENT_NUM
,      SRC_COMPANY_COST_CENTER_ORG_ID
,      SRC_FINANCIAL_ELEM_ID
,      SRC_PRODUCT_ID
,      SRC_NATURAL_ACCOUNT_ID
,      SRC_CHANNEL_ID
,      SRC_LINE_ITEM_ID
,      SRC_PROJECT_ID
,      SRC_CUSTOMER_ID
,      SRC_ENTITY_ID
,      SRC_INTERCOMPANY_ID
,      SRC_TASK_ID
,      SRC_USER_DIM1_ID
,      SRC_USER_DIM2_ID
,      SRC_USER_DIM3_ID
,      SRC_USER_DIM4_ID
,      SRC_USER_DIM5_ID
,      SRC_USER_DIM6_ID
,      SRC_USER_DIM7_ID
,      SRC_USER_DIM8_ID
,      SRC_USER_DIM9_ID
,      SRC_USER_DIM10_ID
,      TGT_COMPANY_COST_CENTER_ORG_ID
,      TGT_FINANCIAL_ELEM_ID
,      TGT_PRODUCT_ID
,      TGT_NATURAL_ACCOUNT_ID
,      TGT_CHANNEL_ID
,      TGT_LINE_ITEM_ID
,      TGT_PROJECT_ID
,      TGT_CUSTOMER_ID
,      TGT_ENTITY_ID
,      TGT_INTERCOMPANY_ID
,      TGT_TASK_ID
,      TGT_USER_DIM1_ID
,      TGT_USER_DIM2_ID
,      TGT_USER_DIM3_ID
,      TGT_USER_DIM4_ID
,      TGT_USER_DIM5_ID
,      TGT_USER_DIM6_ID
,      TGT_USER_DIM7_ID
,      TGT_USER_DIM8_ID
,      TGT_USER_DIM9_ID
,      TGT_USER_DIM10_ID
,      OFF_FINANCIAL_ELEM_ID
,      OFF_PRODUCT_ID
,      OFF_NATURAL_ACCOUNT_ID
,      OFF_CHANNEL_ID
,      OFF_LINE_ITEM_ID
,      OFF_PROJECT_ID
,      OFF_CUSTOMER_ID
,      OFF_ENTITY_ID
,      OFF_TASK_ID
,      OFF_USER_DIM1_ID
,      OFF_USER_DIM2_ID
,      OFF_USER_DIM3_ID
,      OFF_USER_DIM4_ID
,      OFF_USER_DIM5_ID
,      OFF_USER_DIM6_ID
,      OFF_USER_DIM7_ID
,      OFF_USER_DIM8_ID
,      OFF_USER_DIM9_ID
,      OFF_USER_DIM10_ID
,      AD_INPUT_AMOUNT
,      PE_INPUT_AMOUNT
,      CE_INPUT_AMOUNT
,      EE_INPUT_AMOUNT
,      OUTPUT_AMOUNT
,      BALANCE_FACTOR
,      ENTITY_ID
,      YTD_CREDIT_BALANCE_E
,      YTD_DEBIT_BALANCE_E
FROM GCS.GCS_ENTRIES_GT;

Dependencies

[top of page]

GCS.GCS_ENTRIES_GT does not reference any database object

GCS.GCS_ENTRIES_GT is referenced by following:

APPS

GCS_ENTRIES_GT