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


TABLE: FUN.FUN_XLA_TAB_GT

Object Details
Object Name: FUN_XLA_TAB_GT
Object Type: TABLE
Owner: FUN
FND Design Data: TableFUN.FUN_XLA_TAB_GT
Subobject Name:
Status: VALID

Temporary Table Details

FUN.FUN_XLA_TAB_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
Columns
Name Datatype Length Mandatory Comments
SOURCE_DISTRIBUTION_ID_CHAR_1 VARCHAR2 (240)
SOURCE_DISTRIBUTION_ID_CHAR_2 VARCHAR2 (240)
SOURCE_DISTRIBUTION_ID_CHAR_3 VARCHAR2 (240)
SOURCE_DISTRIBUTION_ID_CHAR_4 VARCHAR2 (240)
SOURCE_DISTRIBUTION_ID_CHAR_5 VARCHAR2 (240)
SOURCE_DISTRIBUTION_ID_NUM_1 NUMBER

SOURCE_DISTRIBUTION_ID_NUM_2 NUMBER

SOURCE_DISTRIBUTION_ID_NUM_3 NUMBER

SOURCE_DISTRIBUTION_ID_NUM_4 NUMBER

SOURCE_DISTRIBUTION_ID_NUM_5 NUMBER

ACCOUNT_TYPE_CODE VARCHAR2 (30) Yes
FTB_ATTRIBUTE1 VARCHAR2 (80)
FTB_ATTRIBUTE10 VARCHAR2 (80)
FTB_ATTRIBUTE11 VARCHAR2 (80)
FTB_ATTRIBUTE12 VARCHAR2 (80)
FTB_ATTRIBUTE13 VARCHAR2 (80)
FTB_ATTRIBUTE14 VARCHAR2 (80)
FTB_ATTRIBUTE15 VARCHAR2 (80)
FTB_ATTRIBUTE2 VARCHAR2 (80)
FTB_ATTRIBUTE3 VARCHAR2 (80)
FTB_ATTRIBUTE4 VARCHAR2 (80)
FTB_ATTRIBUTE5 VARCHAR2 (80)
FTB_ATTRIBUTE6 VARCHAR2 (80)
FTB_ATTRIBUTE7 VARCHAR2 (80)
FTB_ATTRIBUTE8 VARCHAR2 (80)
FTB_ATTRIBUTE9 VARCHAR2 (80)
FTB_CATEGORY_CODE VARCHAR2 (80)
FTB_CURRENCY_CODE VARCHAR2 (80)
FTB_FROM_LEDGER_ID NUMBER

FTB_FROM_LE_ID NUMBER

FTB_INITIATOR_BSV VARCHAR2 (80)
FTB_INITIATOR_ID NUMBER

FTH_ATTRIBUTE1 VARCHAR2 (80)
FTH_ATTRIBUTE10 VARCHAR2 (80)
FTH_ATTRIBUTE11 VARCHAR2 (80)
FTH_ATTRIBUTE12 VARCHAR2 (80)
FTH_ATTRIBUTE13 VARCHAR2 (80)
FTH_ATTRIBUTE14 VARCHAR2 (80)
FTH_ATTRIBUTE15 VARCHAR2 (80)
FTH_ATTRIBUTE2 VARCHAR2 (80)
FTH_ATTRIBUTE3 VARCHAR2 (80)
FTH_ATTRIBUTE4 VARCHAR2 (80)
FTH_ATTRIBUTE5 VARCHAR2 (80)
FTH_ATTRIBUTE6 VARCHAR2 (80)
FTH_ATTRIBUTE7 VARCHAR2 (80)
FTH_ATTRIBUTE8 VARCHAR2 (80)
FTH_ATTRIBUTE9 VARCHAR2 (80)
FTH_ATTRIBUTE_CATEGORY VARCHAR2 (80)
FTH_RECIPIENT_BSV VARCHAR2 (80)
FTH_RECIPIENT_ID NUMBER

FTH_TO_LEDGER_ID NUMBER

FTH_TO_LE_ID NUMBER

FTT_ALLOW_INTEREST_ACCR_FLAG VARCHAR2 (80)
FTT_ALLOW_INVOICING_FLAG VARCHAR2 (80)
FTT_ATTRIBUTE1 VARCHAR2 (80)
FTT_ATTRIBUTE10 VARCHAR2 (80)
FTT_ATTRIBUTE11 VARCHAR2 (80)
FTT_ATTRIBUTE12 VARCHAR2 (80)
FTT_ATTRIBUTE13 VARCHAR2 (80)
FTT_ATTRIBUTE14 VARCHAR2 (80)
FTT_ATTRIBUTE15 VARCHAR2 (80)
FTT_ATTRIBUTE2 VARCHAR2 (80)
FTT_ATTRIBUTE3 VARCHAR2 (80)
FTT_ATTRIBUTE4 VARCHAR2 (80)
FTT_ATTRIBUTE5 VARCHAR2 (80)
FTT_ATTRIBUTE6 VARCHAR2 (80)
FTT_ATTRIBUTE7 VARCHAR2 (80)
FTT_ATTRIBUTE8 VARCHAR2 (80)
FTT_ATTRIBUTE9 VARCHAR2 (80)
FTT_ATTRIBUTE_CATEGORY VARCHAR2 (80)
FTT_MANUAL_APPROVE_FLAG VARCHAR2 (80)
FTT_TRX_TYPE_ID NUMBER

FTT_VAT_TAXABLE_FLAG VARCHAR2 (80)
PROCESSED_FLAG VARCHAR2 (1)
SEGMENT1 VARCHAR2 (30)
SEGMENT2 VARCHAR2 (30)
SEGMENT3 VARCHAR2 (30)
SEGMENT4 VARCHAR2 (30)
SEGMENT5 VARCHAR2 (30)
SEGMENT6 VARCHAR2 (30)
SEGMENT7 VARCHAR2 (30)
SEGMENT8 VARCHAR2 (30)
SEGMENT9 VARCHAR2 (30)
SEGMENT10 VARCHAR2 (30)
SEGMENT11 VARCHAR2 (30)
SEGMENT12 VARCHAR2 (30)
SEGMENT13 VARCHAR2 (30)
SEGMENT14 VARCHAR2 (30)
SEGMENT15 VARCHAR2 (30)
SEGMENT16 VARCHAR2 (30)
SEGMENT17 VARCHAR2 (30)
SEGMENT18 VARCHAR2 (30)
SEGMENT19 VARCHAR2 (30)
SEGMENT20 VARCHAR2 (30)
SEGMENT21 VARCHAR2 (30)
SEGMENT22 VARCHAR2 (30)
SEGMENT23 VARCHAR2 (30)
SEGMENT24 VARCHAR2 (30)
SEGMENT25 VARCHAR2 (30)
SEGMENT26 VARCHAR2 (30)
SEGMENT27 VARCHAR2 (30)
SEGMENT28 VARCHAR2 (30)
SEGMENT29 VARCHAR2 (30)
SEGMENT30 VARCHAR2 (30)
TARGET_CCID NUMBER (15)
CONCATENATED_SEGMENTS VARCHAR2 (2000)
MSG_COUNT NUMBER

MSG_DATA VARCHAR2 (2000)
DUMMY_ROWID UROWID (4000)
Query Text

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


SELECT SOURCE_DISTRIBUTION_ID_CHAR_1
,      SOURCE_DISTRIBUTION_ID_CHAR_2
,      SOURCE_DISTRIBUTION_ID_CHAR_3
,      SOURCE_DISTRIBUTION_ID_CHAR_4
,      SOURCE_DISTRIBUTION_ID_CHAR_5
,      SOURCE_DISTRIBUTION_ID_NUM_1
,      SOURCE_DISTRIBUTION_ID_NUM_2
,      SOURCE_DISTRIBUTION_ID_NUM_3
,      SOURCE_DISTRIBUTION_ID_NUM_4
,      SOURCE_DISTRIBUTION_ID_NUM_5
,      ACCOUNT_TYPE_CODE
,      FTB_ATTRIBUTE1
,      FTB_ATTRIBUTE10
,      FTB_ATTRIBUTE11
,      FTB_ATTRIBUTE12
,      FTB_ATTRIBUTE13
,      FTB_ATTRIBUTE14
,      FTB_ATTRIBUTE15
,      FTB_ATTRIBUTE2
,      FTB_ATTRIBUTE3
,      FTB_ATTRIBUTE4
,      FTB_ATTRIBUTE5
,      FTB_ATTRIBUTE6
,      FTB_ATTRIBUTE7
,      FTB_ATTRIBUTE8
,      FTB_ATTRIBUTE9
,      FTB_CATEGORY_CODE
,      FTB_CURRENCY_CODE
,      FTB_FROM_LEDGER_ID
,      FTB_FROM_LE_ID
,      FTB_INITIATOR_BSV
,      FTB_INITIATOR_ID
,      FTH_ATTRIBUTE1
,      FTH_ATTRIBUTE10
,      FTH_ATTRIBUTE11
,      FTH_ATTRIBUTE12
,      FTH_ATTRIBUTE13
,      FTH_ATTRIBUTE14
,      FTH_ATTRIBUTE15
,      FTH_ATTRIBUTE2
,      FTH_ATTRIBUTE3
,      FTH_ATTRIBUTE4
,      FTH_ATTRIBUTE5
,      FTH_ATTRIBUTE6
,      FTH_ATTRIBUTE7
,      FTH_ATTRIBUTE8
,      FTH_ATTRIBUTE9
,      FTH_ATTRIBUTE_CATEGORY
,      FTH_RECIPIENT_BSV
,      FTH_RECIPIENT_ID
,      FTH_TO_LEDGER_ID
,      FTH_TO_LE_ID
,      FTT_ALLOW_INTEREST_ACCR_FLAG
,      FTT_ALLOW_INVOICING_FLAG
,      FTT_ATTRIBUTE1
,      FTT_ATTRIBUTE10
,      FTT_ATTRIBUTE11
,      FTT_ATTRIBUTE12
,      FTT_ATTRIBUTE13
,      FTT_ATTRIBUTE14
,      FTT_ATTRIBUTE15
,      FTT_ATTRIBUTE2
,      FTT_ATTRIBUTE3
,      FTT_ATTRIBUTE4
,      FTT_ATTRIBUTE5
,      FTT_ATTRIBUTE6
,      FTT_ATTRIBUTE7
,      FTT_ATTRIBUTE8
,      FTT_ATTRIBUTE9
,      FTT_ATTRIBUTE_CATEGORY
,      FTT_MANUAL_APPROVE_FLAG
,      FTT_TRX_TYPE_ID
,      FTT_VAT_TAXABLE_FLAG
,      PROCESSED_FLAG
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      TARGET_CCID
,      CONCATENATED_SEGMENTS
,      MSG_COUNT
,      MSG_DATA
,      DUMMY_ROWID
FROM FUN.FUN_XLA_TAB_GT;

Dependencies

[top of page]

FUN.FUN_XLA_TAB_GT does not reference any database object

FUN.FUN_XLA_TAB_GT is referenced by following:

SchemaAPPS
SynonymFUN_XLA_TAB_GT