eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BIS.EDW_GL_ACCT8_M_TEMP

Object Details

Object Name:	EDW_GL_ACCT8_M_TEMP
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.EDW_GL_ACCT8_M_TEMP
Subobject Name:
Status:	VALID

Temp Table

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_GL_ACCT8_M_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	L1_PK

Columns

Name	Datatype	Length	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)	TempTemp
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)	TempTemp
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

Query Text

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_ACCT8_M_TEMP;

Dependencies

[top of page]

BIS.EDW_GL_ACCT8_M_TEMP does not reference any database object

BIS.EDW_GL_ACCT8_M_TEMP is referenced by following:

APPS: EDW_GL_ACCT8_M_TEMP