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

TABLE: FEM.FEM_SOURCE_DATA_INTERIM_GT

Object Details
Object Name: FEM_SOURCE_DATA_INTERIM_GT
Object Type: TABLE
Owner: FEM
FND Design Data: TableFEM.FEM_SOURCE_DATA_INTERIM_GT
Subobject Name:
Status: VALID

This table is a global temporary table that will serve as the interim stage in processing the data to be transferred from the detail client data interface table to the target table. This table has a one-to-one relationship with all detail client data interface and target tables.

Temporary Table Details

FEM.FEM_SOURCE_DATA_INTERIM_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$SESSION. 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
FEM_SOURCE_DATA_INTERIM_GT_N1 NORMAL NONUNIQUE Tablespace ColumnERROR_CODE
Columns
Name Datatype Length Mandatory Comments
INTERFACE_ROWID ROWID (10)
ROWID of the corresponding record in the interface table.
ERROR_CODE VARCHAR2 (30)
Designates the status of the row. Records are first created in this table with no ERROR_CODE values. If a record is found to have an error during the validation process, the error is stored here. It will later be copied to the interface table.
DIM1 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM2 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM3 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM4 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM5 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM6 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM7 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM8 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM9 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM10 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM11 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM12 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM13 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM14 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM15 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM16 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM17 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM18 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM19 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM20 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM21 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM22 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM23 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM24 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM25 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM26 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM27 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM28 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM29 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM30 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM31 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM32 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM33 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM34 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM35 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM36 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM37 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM38 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM39 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM40 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM41 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM42 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM43 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM44 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM45 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM46 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM47 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM48 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM49 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM50 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM51 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM52 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM53 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM54 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM55 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM56 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM57 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM58 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM59 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM60 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM61 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM62 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM63 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM64 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM65 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM66 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM67 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM68 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM69 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM70 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM71 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM72 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM73 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM74 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM75 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM76 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM77 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM78 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM79 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM80 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM81 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM82 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM83 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM84 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM85 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM86 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM87 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM88 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM89 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM90 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM91 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM92 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM93 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM94 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM95 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM96 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM97 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM98 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM99 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM100 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM101 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM102 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM103 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM104 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM105 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM106 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM107 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM108 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM109 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM110 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM111 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM112 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM113 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM114 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM115 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM116 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM117 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM118 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM119 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM120 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM121 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM122 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM123 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM124 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM125 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM126 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM127 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM128 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM129 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM130 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM131 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM132 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM133 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM134 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM135 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM136 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM137 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM138 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM139 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM140 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM141 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM142 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM143 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM144 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM145 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM146 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM147 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM148 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM149 VARCHAR2 (30)
Foreign key to a dimension member table.
DIM150 VARCHAR2 (30)
Foreign key to a dimension member table.
Query Text

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


SELECT INTERFACE_ROWID
,      ERROR_CODE
,      DIM1
,      DIM2
,      DIM3
,      DIM4
,      DIM5
,      DIM6
,      DIM7
,      DIM8
,      DIM9
,      DIM10
,      DIM11
,      DIM12
,      DIM13
,      DIM14
,      DIM15
,      DIM16
,      DIM17
,      DIM18
,      DIM19
,      DIM20
,      DIM21
,      DIM22
,      DIM23
,      DIM24
,      DIM25
,      DIM26
,      DIM27
,      DIM28
,      DIM29
,      DIM30
,      DIM31
,      DIM32
,      DIM33
,      DIM34
,      DIM35
,      DIM36
,      DIM37
,      DIM38
,      DIM39
,      DIM40
,      DIM41
,      DIM42
,      DIM43
,      DIM44
,      DIM45
,      DIM46
,      DIM47
,      DIM48
,      DIM49
,      DIM50
,      DIM51
,      DIM52
,      DIM53
,      DIM54
,      DIM55
,      DIM56
,      DIM57
,      DIM58
,      DIM59
,      DIM60
,      DIM61
,      DIM62
,      DIM63
,      DIM64
,      DIM65
,      DIM66
,      DIM67
,      DIM68
,      DIM69
,      DIM70
,      DIM71
,      DIM72
,      DIM73
,      DIM74
,      DIM75
,      DIM76
,      DIM77
,      DIM78
,      DIM79
,      DIM80
,      DIM81
,      DIM82
,      DIM83
,      DIM84
,      DIM85
,      DIM86
,      DIM87
,      DIM88
,      DIM89
,      DIM90
,      DIM91
,      DIM92
,      DIM93
,      DIM94
,      DIM95
,      DIM96
,      DIM97
,      DIM98
,      DIM99
,      DIM100
,      DIM101
,      DIM102
,      DIM103
,      DIM104
,      DIM105
,      DIM106
,      DIM107
,      DIM108
,      DIM109
,      DIM110
,      DIM111
,      DIM112
,      DIM113
,      DIM114
,      DIM115
,      DIM116
,      DIM117
,      DIM118
,      DIM119
,      DIM120
,      DIM121
,      DIM122
,      DIM123
,      DIM124
,      DIM125
,      DIM126
,      DIM127
,      DIM128
,      DIM129
,      DIM130
,      DIM131
,      DIM132
,      DIM133
,      DIM134
,      DIM135
,      DIM136
,      DIM137
,      DIM138
,      DIM139
,      DIM140
,      DIM141
,      DIM142
,      DIM143
,      DIM144
,      DIM145
,      DIM146
,      DIM147
,      DIM148
,      DIM149
,      DIM150
FROM FEM.FEM_SOURCE_DATA_INTERIM_GT;

Dependencies

[top of page]

FEM.FEM_SOURCE_DATA_INTERIM_GT does not reference any database object

FEM.FEM_SOURCE_DATA_INTERIM_GT is referenced by following:

SchemaAPPS
SynonymFEM_SOURCE_DATA_INTERIM_GT