[Home] [Help] [Dependency Information]
Object Name: | EDW_GL_ACCT6_M_TEMP |
---|---|
Object Type: | TABLE |
Owner: | BIS |
FND Design Data: | BIS.EDW_GL_ACCT6_M_TEMP |
Subobject Name: | |
Status: | VALID |
Temp Table
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_GL_ACCT6_M_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | L1_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
L1_PK_KEY | NUMBER | Temp | ||
L1_DESCRIPTION | VARCHAR2 | (240) | Temp | |
L1_NAME | VARCHAR2 | (240) | Temp | |
L1_PK | VARCHAR2 | (240) | Temp | |
L1_TYPE | VARCHAR2 | (80) | Temp | |
H102_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H102_NAME | VARCHAR2 | (240) | Temp | |
H102_PK | VARCHAR2 | (240) | Temp | |
H102_TYPE | VARCHAR2 | (80) | Temp | |
H103_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H103_NAME | VARCHAR2 | (240) | Temp | |
H103_PK | VARCHAR2 | (240) | Temp | |
H103_TYPE | VARCHAR2 | (80) | Temp | |
H104_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H104_NAME | VARCHAR2 | (240) | Temp | |
H104_PK | VARCHAR2 | (240) | Temp | |
H104_TYPE | VARCHAR2 | (80) | Temp | |
H105_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H105_NAME | VARCHAR2 | (240) | Temp | |
H105_PK | VARCHAR2 | (240) | Temp | |
H105_TYPE | VARCHAR2 | (80) | Temp | |
H106_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H106_NAME | VARCHAR2 | (240) | Temp | |
H106_PK | VARCHAR2 | (240) | Temp | |
H106_TYPE | VARCHAR2 | (80) | Temp | |
H107_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H107_NAME | VARCHAR2 | (240) | Temp | |
H107_PK | VARCHAR2 | (240) | Temp | |
H107_TYPE | VARCHAR2 | (80) | Temp | |
H108_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H108_NAME | VARCHAR2 | (240) | Temp | |
H108_PK | VARCHAR2 | (240) | Temp | |
H108_TYPE | VARCHAR2 | (80) | Temp | |
H109_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H109_NAME | VARCHAR2 | (240) | Temp | |
H109_PK | VARCHAR2 | (240) | Temp | |
H109_TYPE | VARCHAR2 | (80) | Temp | |
H110_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H110_NAME | VARCHAR2 | (240) | Temp | |
H110_PK | VARCHAR2 | (240) | Temp | |
H110_TYPE | VARCHAR2 | (80) | Temp | |
H111_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H111_NAME | VARCHAR2 | (240) | Temp | |
H111_PK | VARCHAR2 | (240) | Temp | |
H111_TYPE | VARCHAR2 | (80) | Temp | |
H112_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H112_NAME | VARCHAR2 | (240) | Temp | |
H112_PK | VARCHAR2 | (240) | Temp | |
H112_TYPE | VARCHAR2 | (80) | Temp | |
H113_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H113_NAME | VARCHAR2 | (240) | Temp | |
H113_PK | VARCHAR2 | (240) | Temp | |
H113_TYPE | VARCHAR2 | (80) | Temp | |
H114_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H114_NAME | VARCHAR2 | (240) | Temp | |
H114_PK | VARCHAR2 | (240) | Temp | |
H114_TYPE | VARCHAR2 | (80) | Temp | |
H115_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H115_NAME | VARCHAR2 | (240) | Temp | |
H115_PK | VARCHAR2 | (240) | Temp | |
H115_TYPE | VARCHAR2 | (80) | Temp | |
H202_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H202_NAME | VARCHAR2 | (240) | Temp | |
H202_PK | VARCHAR2 | (240) | Temp | |
H202_TYPE | VARCHAR2 | (80) | Temp | |
H203_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H203_NAME | VARCHAR2 | (240) | Temp | |
H203_PK | VARCHAR2 | (240) | Temp | |
H203_TYPE | VARCHAR2 | (80) | Temp | |
H204_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H204_NAME | VARCHAR2 | (240) | Temp | |
H204_PK | VARCHAR2 | (240) | Temp | |
H204_TYPE | VARCHAR2 | (80) | Temp | |
H205_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H205_NAME | VARCHAR2 | (240) | Temp | |
H205_PK | VARCHAR2 | (240) | Temp | |
H205_TYPE | VARCHAR2 | (80) | Temp | |
H206_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H206_NAME | VARCHAR2 | (240) | Temp | |
H206_PK | VARCHAR2 | (240) | Temp | |
H206_TYPE | VARCHAR2 | (80) | Temp | |
H207_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H207_NAME | VARCHAR2 | (240) | Temp | |
H207_PK | VARCHAR2 | (240) | Temp | |
H207_TYPE | VARCHAR2 | (80) | Temp | |
H208_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H208_NAME | VARCHAR2 | (240) | Temp | |
H208_PK | VARCHAR2 | (240) | Temp | |
H208_TYPE | VARCHAR2 | (80) | Temp | |
H209_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H209_NAME | VARCHAR2 | (240) | Temp | |
H209_PK | VARCHAR2 | (240) | Temp | |
H209_TYPE | VARCHAR2 | (80) | Temp | |
H210_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H210_NAME | VARCHAR2 | (240) | Temp | |
H210_PK | VARCHAR2 | (240) | Temp | |
H210_TYPE | VARCHAR2 | (80) | Temp | |
H211_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H211_NAME | VARCHAR2 | (240) | Temp | |
H211_PK | VARCHAR2 | (240) | Temp | |
H211_TYPE | VARCHAR2 | (80) | Temp | |
H212_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H212_NAME | VARCHAR2 | (240) | Temp | |
H212_PK | VARCHAR2 | (240) | Temp | |
H212_TYPE | VARCHAR2 | (80) | Temp | |
H213_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H213_NAME | VARCHAR2 | (240) | Temp | |
H213_PK | VARCHAR2 | (240) | Temp | |
H213_TYPE | VARCHAR2 | (80) | Temp | |
H214_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H214_NAME | VARCHAR2 | (240) | Temp | |
H214_PK | VARCHAR2 | (240) | Temp | |
H214_TYPE | VARCHAR2 | (80) | Temp | |
H215_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H215_NAME | VARCHAR2 | (240) | Temp | |
H215_PK | VARCHAR2 | (240) | Temp | |
H215_TYPE | VARCHAR2 | (80) | Temp | |
H302_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H302_NAME | VARCHAR2 | (240) | Temp | |
H302_PK | VARCHAR2 | (240) | Temp | |
H302_TYPE | VARCHAR2 | (80) | Temp | |
H303_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H303_NAME | VARCHAR2 | (240) | Temp | |
H303_PK | VARCHAR2 | (240) | Temp | |
H303_TYPE | VARCHAR2 | (80) | Temp | |
H304_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H304_NAME | VARCHAR2 | (240) | Temp | |
H304_PK | VARCHAR2 | (240) | Temp | |
H304_TYPE | VARCHAR2 | (80) | Temp | |
H305_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H305_NAME | VARCHAR2 | (240) | Temp | |
H305_PK | VARCHAR2 | (240) | Temp | |
H305_TYPE | VARCHAR2 | (80) | Temp | |
H306_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H306_NAME | VARCHAR2 | (240) | Temp | |
H306_PK | VARCHAR2 | (240) | Temp | |
H306_TYPE | VARCHAR2 | (80) | Temp | |
H307_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H307_NAME | VARCHAR2 | (240) | Temp | |
H307_PK | VARCHAR2 | (240) | Temp | |
H307_TYPE | VARCHAR2 | (80) | Temp | |
H308_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H308_NAME | VARCHAR2 | (240) | Temp | |
H308_PK | VARCHAR2 | (240) | Temp | |
H308_TYPE | VARCHAR2 | (80) | Temp | |
H309_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H309_NAME | VARCHAR2 | (240) | Temp | |
H309_PK | VARCHAR2 | (240) | Temp | |
H309_TYPE | VARCHAR2 | (80) | Temp | |
H310_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H310_NAME | VARCHAR2 | (240) | Temp | |
H310_PK | VARCHAR2 | (240) | Temp | |
H310_TYPE | VARCHAR2 | (80) | Temp | |
H311_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H311_NAME | VARCHAR2 | (240) | Temp | |
H311_PK | VARCHAR2 | (240) | Temp | |
H311_TYPE | VARCHAR2 | (80) | Temp | |
H312_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H312_NAME | VARCHAR2 | (240) | Temp | |
H312_PK | VARCHAR2 | (240) | Temp | |
H312_TYPE | VARCHAR2 | (80) | Temp | |
H313_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H313_NAME | VARCHAR2 | (240) | Temp | |
H313_PK | VARCHAR2 | (240) | Temp | |
H313_TYPE | VARCHAR2 | (80) | Temp | |
H314_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H314_NAME | VARCHAR2 | (240) | Temp | |
H314_PK | VARCHAR2 | (240) | Temp | |
H314_TYPE | VARCHAR2 | (80) | Temp | |
H315_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H315_NAME | VARCHAR2 | (240) | Temp | |
H315_PK | VARCHAR2 | (240) | Temp | |
H315_TYPE | VARCHAR2 | (80) | Temp | |
H402_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H402_NAME | VARCHAR2 | (240) | Temp | |
H402_PK | VARCHAR2 | (240) | Temp | |
H402_TYPE | VARCHAR2 | (80) | Temp | |
H403_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H403_NAME | VARCHAR2 | (240) | Temp | |
H403_PK | VARCHAR2 | (240) | Temp | |
H403_TYPE | VARCHAR2 | (80) | Temp | |
H404_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H404_NAME | VARCHAR2 | (240) | Temp | |
H404_PK | VARCHAR2 | (240) | Temp | |
H404_TYPE | VARCHAR2 | (80) | Temp | |
H405_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H405_NAME | VARCHAR2 | (240) | Temp | |
H405_PK | VARCHAR2 | (240) | Temp | |
H405_TYPE | VARCHAR2 | (80) | Temp | |
H406_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H406_NAME | VARCHAR2 | (240) | Temp | |
H406_PK | VARCHAR2 | (240) | Temp | |
H406_TYPE | VARCHAR2 | (80) | Temp | |
H407_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H407_NAME | VARCHAR2 | (240) | Temp | |
H407_PK | VARCHAR2 | (240) | Temp | |
H407_TYPE | VARCHAR2 | (80) | Temp | |
H408_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H408_NAME | VARCHAR2 | (240) | Temp | |
H408_PK | VARCHAR2 | (240) | Temp | |
H408_TYPE | VARCHAR2 | (80) | Temp | |
H409_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H409_NAME | VARCHAR2 | (240) | Temp | |
H409_PK | VARCHAR2 | (240) | Temp | |
H409_TYPE | VARCHAR2 | (80) | Temp | |
H410_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H410_NAME | VARCHAR2 | (240) | Temp | |
H410_PK | VARCHAR2 | (240) | Temp | |
H410_TYPE | VARCHAR2 | (80) | Temp | |
H411_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H411_NAME | VARCHAR2 | (240) | Temp | |
H411_PK | VARCHAR2 | (240) | Temp | |
H411_TYPE | VARCHAR2 | (80) | Temp | |
H412_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H412_NAME | VARCHAR2 | (240) | Temp | |
H412_PK | VARCHAR2 | (240) | Temp | |
H412_TYPE | VARCHAR2 | (80) | Temp | |
H413_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H413_NAME | VARCHAR2 | (240) | Temp | |
H413_PK | VARCHAR2 | (240) | Temp | |
H413_TYPE | VARCHAR2 | (80) | Temp | |
H414_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H414_NAME | VARCHAR2 | (240) | Temp | |
H414_PK | VARCHAR2 | (240) | Temp | |
H414_TYPE | VARCHAR2 | (80) | Temp | |
H415_DESCRIPTION | VARCHAR2 | (240) | Temp | |
H415_NAME | VARCHAR2 | (240) | Temp | |
H415_PK | VARCHAR2 | (240) | Temp | |
H415_TYPE | VARCHAR2 | (80) | Temp | |
ALL_DESCRIPTION | VARCHAR2 | (80) | Temp | |
ALL_NAME | VARCHAR2 | (80) | Temp | |
ALL_PK | VARCHAR2 | (80) | Temp | |
TYPE_DESCRIPTION | VARCHAR2 | (80) | Temp | |
TYPE_NAME | VARCHAR2 | (80) | Temp | |
TYPE_PK | VARCHAR2 | (80) | Temp | |
ROW_ID1 | ROWID | (10) | Temp | |
ROW_ID2 | ROWID | (10) | Temp | |
OPERATION_CODE1 | VARCHAR2 | (40) | Temp | |
OPERATION_CODE2 | VARCHAR2 | (40) | Temp |
Cut, paste (and edit) the following text to query this object:
SELECT L1_PK_KEY
, L1_DESCRIPTION
, L1_NAME
, L1_PK
, L1_TYPE
, H102_DESCRIPTION
, H102_NAME
, H102_PK
, H102_TYPE
, H103_DESCRIPTION
, H103_NAME
, H103_PK
, H103_TYPE
, H104_DESCRIPTION
, H104_NAME
, H104_PK
, H104_TYPE
, H105_DESCRIPTION
, H105_NAME
, H105_PK
, H105_TYPE
, H106_DESCRIPTION
, H106_NAME
, H106_PK
, H106_TYPE
, H107_DESCRIPTION
, H107_NAME
, H107_PK
, H107_TYPE
, H108_DESCRIPTION
, H108_NAME
, H108_PK
, H108_TYPE
, H109_DESCRIPTION
, H109_NAME
, H109_PK
, H109_TYPE
, H110_DESCRIPTION
, H110_NAME
, H110_PK
, H110_TYPE
, H111_DESCRIPTION
, H111_NAME
, H111_PK
, H111_TYPE
, H112_DESCRIPTION
, H112_NAME
, H112_PK
, H112_TYPE
, H113_DESCRIPTION
, H113_NAME
, H113_PK
, H113_TYPE
, H114_DESCRIPTION
, H114_NAME
, H114_PK
, H114_TYPE
, H115_DESCRIPTION
, H115_NAME
, H115_PK
, H115_TYPE
, H202_DESCRIPTION
, H202_NAME
, H202_PK
, H202_TYPE
, H203_DESCRIPTION
, H203_NAME
, H203_PK
, H203_TYPE
, H204_DESCRIPTION
, H204_NAME
, H204_PK
, H204_TYPE
, H205_DESCRIPTION
, H205_NAME
, H205_PK
, H205_TYPE
, H206_DESCRIPTION
, H206_NAME
, H206_PK
, H206_TYPE
, H207_DESCRIPTION
, H207_NAME
, H207_PK
, H207_TYPE
, H208_DESCRIPTION
, H208_NAME
, H208_PK
, H208_TYPE
, H209_DESCRIPTION
, H209_NAME
, H209_PK
, H209_TYPE
, H210_DESCRIPTION
, H210_NAME
, H210_PK
, H210_TYPE
, H211_DESCRIPTION
, H211_NAME
, H211_PK
, H211_TYPE
, H212_DESCRIPTION
, H212_NAME
, H212_PK
, H212_TYPE
, H213_DESCRIPTION
, H213_NAME
, H213_PK
, H213_TYPE
, H214_DESCRIPTION
, H214_NAME
, H214_PK
, H214_TYPE
, H215_DESCRIPTION
, H215_NAME
, H215_PK
, H215_TYPE
, H302_DESCRIPTION
, H302_NAME
, H302_PK
, H302_TYPE
, H303_DESCRIPTION
, H303_NAME
, H303_PK
, H303_TYPE
, H304_DESCRIPTION
, H304_NAME
, H304_PK
, H304_TYPE
, H305_DESCRIPTION
, H305_NAME
, H305_PK
, H305_TYPE
, H306_DESCRIPTION
, H306_NAME
, H306_PK
, H306_TYPE
, H307_DESCRIPTION
, H307_NAME
, H307_PK
, H307_TYPE
, H308_DESCRIPTION
, H308_NAME
, H308_PK
, H308_TYPE
, H309_DESCRIPTION
, H309_NAME
, H309_PK
, H309_TYPE
, H310_DESCRIPTION
, H310_NAME
, H310_PK
, H310_TYPE
, H311_DESCRIPTION
, H311_NAME
, H311_PK
, H311_TYPE
, H312_DESCRIPTION
, H312_NAME
, H312_PK
, H312_TYPE
, H313_DESCRIPTION
, H313_NAME
, H313_PK
, H313_TYPE
, H314_DESCRIPTION
, H314_NAME
, H314_PK
, H314_TYPE
, H315_DESCRIPTION
, H315_NAME
, H315_PK
, H315_TYPE
, H402_DESCRIPTION
, H402_NAME
, H402_PK
, H402_TYPE
, H403_DESCRIPTION
, H403_NAME
, H403_PK
, H403_TYPE
, H404_DESCRIPTION
, H404_NAME
, H404_PK
, H404_TYPE
, H405_DESCRIPTION
, H405_NAME
, H405_PK
, H405_TYPE
, H406_DESCRIPTION
, H406_NAME
, H406_PK
, H406_TYPE
, H407_DESCRIPTION
, H407_NAME
, H407_PK
, H407_TYPE
, H408_DESCRIPTION
, H408_NAME
, H408_PK
, H408_TYPE
, H409_DESCRIPTION
, H409_NAME
, H409_PK
, H409_TYPE
, H410_DESCRIPTION
, H410_NAME
, H410_PK
, H410_TYPE
, H411_DESCRIPTION
, H411_NAME
, H411_PK
, H411_TYPE
, H412_DESCRIPTION
, H412_NAME
, H412_PK
, H412_TYPE
, H413_DESCRIPTION
, H413_NAME
, H413_PK
, H413_TYPE
, H414_DESCRIPTION
, H414_NAME
, H414_PK
, H414_TYPE
, H415_DESCRIPTION
, H415_NAME
, H415_PK
, H415_TYPE
, ALL_DESCRIPTION
, ALL_NAME
, ALL_PK
, TYPE_DESCRIPTION
, TYPE_NAME
, TYPE_PK
, ROW_ID1
, ROW_ID2
, OPERATION_CODE1
, OPERATION_CODE2
FROM BIS.EDW_GL_ACCT6_M_TEMP;
BIS.EDW_GL_ACCT6_M_TEMP does not reference any database object
BIS.EDW_GL_ACCT6_M_TEMP is referenced by following:
|
|
|