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: GL.GL_DAILY_POST_INT

Object Details

Object Name:	GL_DAILY_POST_INT
Object Type:	TABLE
Owner:	GL
Subobject Name:
Status:	VALID

Temporary Table Details

GL.GL_DAILY_POST_INT 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:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_DAILY_POST_INT_N1	NORMAL	NONUNIQUE		CODE_COMBINATION_ID PERIOD_NAME CURRENCY_CODE
GL_DAILY_POST_INT_N2	NORMAL	NONUNIQUE		TEMPLATE_ID

Columns

Name	Datatype	Length	Mandatory
LEDGER_ID	NUMBER	(15)	Yes
CODE_COMBINATION_ID	NUMBER	(15)	Yes
CURRENCY_CODE	VARCHAR2	(15)	Yes
CURRENCY_TYPE	VARCHAR2	(1)	Yes
ACTUAL_FLAG	VARCHAR2	(1)	Yes
PERIOD_NAME	VARCHAR2	(15)	Yes
PERIOD_START_DATE	DATE		Yes
PERIOD_END_DATE	DATE		Yes
QUARTER_START_DATE	DATE		Yes
YEAR_START_DATE	DATE		Yes
CONVERTED_FROM_CURRENCY	VARCHAR2	(15)
BAL_SEG_VALUE	VARCHAR2	(25)
PERIOD_TYPE	VARCHAR2	(15)
PERIOD_YEAR	NUMBER	(15)
PERIOD_NUM	NUMBER	(15)
TEMPLATE_ID	NUMBER	(15)
GDB_ROWID	ROWID	(10)
OPENING_PERIOD_AGGREGATE	NUMBER
OPENING_QUARTER_AGGREGATE	NUMBER
OPENING_YEAR_AGGREGATE	NUMBER
PERIOD_END_NET_INCOME	NUMBER
PERIOD_AGGREGATE1	NUMBER
PERIOD_AGGREGATE2	NUMBER
PERIOD_AGGREGATE3	NUMBER
PERIOD_AGGREGATE4	NUMBER
PERIOD_AGGREGATE5	NUMBER
PERIOD_AGGREGATE6	NUMBER
PERIOD_AGGREGATE7	NUMBER
PERIOD_AGGREGATE8	NUMBER
PERIOD_AGGREGATE9	NUMBER
PERIOD_AGGREGATE10	NUMBER
PERIOD_AGGREGATE11	NUMBER
PERIOD_AGGREGATE12	NUMBER
PERIOD_AGGREGATE13	NUMBER
PERIOD_AGGREGATE14	NUMBER
PERIOD_AGGREGATE15	NUMBER
PERIOD_AGGREGATE16	NUMBER
PERIOD_AGGREGATE17	NUMBER
PERIOD_AGGREGATE18	NUMBER
PERIOD_AGGREGATE19	NUMBER
PERIOD_AGGREGATE20	NUMBER
PERIOD_AGGREGATE21	NUMBER
PERIOD_AGGREGATE22	NUMBER
PERIOD_AGGREGATE23	NUMBER
PERIOD_AGGREGATE24	NUMBER
PERIOD_AGGREGATE25	NUMBER
PERIOD_AGGREGATE26	NUMBER
PERIOD_AGGREGATE27	NUMBER
PERIOD_AGGREGATE28	NUMBER
PERIOD_AGGREGATE29	NUMBER
PERIOD_AGGREGATE30	NUMBER
PERIOD_AGGREGATE31	NUMBER
PERIOD_AGGREGATE32	NUMBER
PERIOD_AGGREGATE33	NUMBER
PERIOD_AGGREGATE34	NUMBER
PERIOD_AGGREGATE35	NUMBER
END_OF_DAY1	NUMBER
END_OF_DAY2	NUMBER
END_OF_DAY3	NUMBER
END_OF_DAY4	NUMBER
END_OF_DAY5	NUMBER
END_OF_DAY6	NUMBER
END_OF_DAY7	NUMBER
END_OF_DAY8	NUMBER
END_OF_DAY9	NUMBER
END_OF_DAY10	NUMBER
END_OF_DAY11	NUMBER
END_OF_DAY12	NUMBER
END_OF_DAY13	NUMBER
END_OF_DAY14	NUMBER
END_OF_DAY15	NUMBER
END_OF_DAY16	NUMBER
END_OF_DAY17	NUMBER
END_OF_DAY18	NUMBER
END_OF_DAY19	NUMBER
END_OF_DAY20	NUMBER
END_OF_DAY21	NUMBER
END_OF_DAY22	NUMBER
END_OF_DAY23	NUMBER
END_OF_DAY24	NUMBER
END_OF_DAY25	NUMBER
END_OF_DAY26	NUMBER
END_OF_DAY27	NUMBER
END_OF_DAY28	NUMBER
END_OF_DAY29	NUMBER
END_OF_DAY30	NUMBER
END_OF_DAY31	NUMBER
END_OF_DAY32	NUMBER
END_OF_DAY33	NUMBER
END_OF_DAY34	NUMBER
END_OF_DAY35	NUMBER
QUARTER_AGGREGATE1	NUMBER
QUARTER_AGGREGATE2	NUMBER
QUARTER_AGGREGATE3	NUMBER
QUARTER_AGGREGATE4	NUMBER
QUARTER_AGGREGATE5	NUMBER
QUARTER_AGGREGATE6	NUMBER
QUARTER_AGGREGATE7	NUMBER
QUARTER_AGGREGATE8	NUMBER
QUARTER_AGGREGATE9	NUMBER
QUARTER_AGGREGATE10	NUMBER
QUARTER_AGGREGATE11	NUMBER
QUARTER_AGGREGATE12	NUMBER
QUARTER_AGGREGATE13	NUMBER
QUARTER_AGGREGATE14	NUMBER
QUARTER_AGGREGATE15	NUMBER
QUARTER_AGGREGATE16	NUMBER
QUARTER_AGGREGATE17	NUMBER
QUARTER_AGGREGATE18	NUMBER
QUARTER_AGGREGATE19	NUMBER
QUARTER_AGGREGATE20	NUMBER
QUARTER_AGGREGATE21	NUMBER
QUARTER_AGGREGATE22	NUMBER
QUARTER_AGGREGATE23	NUMBER
QUARTER_AGGREGATE24	NUMBER
QUARTER_AGGREGATE25	NUMBER
QUARTER_AGGREGATE26	NUMBER
QUARTER_AGGREGATE27	NUMBER
QUARTER_AGGREGATE28	NUMBER
QUARTER_AGGREGATE29	NUMBER
QUARTER_AGGREGATE30	NUMBER
QUARTER_AGGREGATE31	NUMBER
QUARTER_AGGREGATE32	NUMBER
QUARTER_AGGREGATE33	NUMBER
QUARTER_AGGREGATE34	NUMBER
QUARTER_AGGREGATE35	NUMBER
YEAR_AGGREGATE1	NUMBER
YEAR_AGGREGATE2	NUMBER
YEAR_AGGREGATE3	NUMBER
YEAR_AGGREGATE4	NUMBER
YEAR_AGGREGATE5	NUMBER
YEAR_AGGREGATE6	NUMBER
YEAR_AGGREGATE7	NUMBER
YEAR_AGGREGATE8	NUMBER
YEAR_AGGREGATE9	NUMBER
YEAR_AGGREGATE10	NUMBER
YEAR_AGGREGATE11	NUMBER
YEAR_AGGREGATE12	NUMBER
YEAR_AGGREGATE13	NUMBER
YEAR_AGGREGATE14	NUMBER
YEAR_AGGREGATE15	NUMBER
YEAR_AGGREGATE16	NUMBER
YEAR_AGGREGATE17	NUMBER
YEAR_AGGREGATE18	NUMBER
YEAR_AGGREGATE19	NUMBER
YEAR_AGGREGATE20	NUMBER
YEAR_AGGREGATE21	NUMBER
YEAR_AGGREGATE22	NUMBER
YEAR_AGGREGATE23	NUMBER
YEAR_AGGREGATE24	NUMBER
YEAR_AGGREGATE25	NUMBER
YEAR_AGGREGATE26	NUMBER
YEAR_AGGREGATE27	NUMBER
YEAR_AGGREGATE28	NUMBER
YEAR_AGGREGATE29	NUMBER
YEAR_AGGREGATE30	NUMBER
YEAR_AGGREGATE31	NUMBER
YEAR_AGGREGATE32	NUMBER
YEAR_AGGREGATE33	NUMBER
YEAR_AGGREGATE34	NUMBER
YEAR_AGGREGATE35	NUMBER

Query Text

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


SELECT LEDGER_ID
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      CURRENCY_TYPE
,      ACTUAL_FLAG
,      PERIOD_NAME
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      QUARTER_START_DATE
,      YEAR_START_DATE
,      CONVERTED_FROM_CURRENCY
,      BAL_SEG_VALUE
,      PERIOD_TYPE
,      PERIOD_YEAR
,      PERIOD_NUM
,      TEMPLATE_ID
,      GDB_ROWID
,      OPENING_PERIOD_AGGREGATE
,      OPENING_QUARTER_AGGREGATE
,      OPENING_YEAR_AGGREGATE
,      PERIOD_END_NET_INCOME
,      PERIOD_AGGREGATE1
,      PERIOD_AGGREGATE2
,      PERIOD_AGGREGATE3
,      PERIOD_AGGREGATE4
,      PERIOD_AGGREGATE5
,      PERIOD_AGGREGATE6
,      PERIOD_AGGREGATE7
,      PERIOD_AGGREGATE8
,      PERIOD_AGGREGATE9
,      PERIOD_AGGREGATE10
,      PERIOD_AGGREGATE11
,      PERIOD_AGGREGATE12
,      PERIOD_AGGREGATE13
,      PERIOD_AGGREGATE14
,      PERIOD_AGGREGATE15
,      PERIOD_AGGREGATE16
,      PERIOD_AGGREGATE17
,      PERIOD_AGGREGATE18
,      PERIOD_AGGREGATE19
,      PERIOD_AGGREGATE20
,      PERIOD_AGGREGATE21
,      PERIOD_AGGREGATE22
,      PERIOD_AGGREGATE23
,      PERIOD_AGGREGATE24
,      PERIOD_AGGREGATE25
,      PERIOD_AGGREGATE26
,      PERIOD_AGGREGATE27
,      PERIOD_AGGREGATE28
,      PERIOD_AGGREGATE29
,      PERIOD_AGGREGATE30
,      PERIOD_AGGREGATE31
,      PERIOD_AGGREGATE32
,      PERIOD_AGGREGATE33
,      PERIOD_AGGREGATE34
,      PERIOD_AGGREGATE35
,      END_OF_DAY1
,      END_OF_DAY2
,      END_OF_DAY3
,      END_OF_DAY4
,      END_OF_DAY5
,      END_OF_DAY6
,      END_OF_DAY7
,      END_OF_DAY8
,      END_OF_DAY9
,      END_OF_DAY10
,      END_OF_DAY11
,      END_OF_DAY12
,      END_OF_DAY13
,      END_OF_DAY14
,      END_OF_DAY15
,      END_OF_DAY16
,      END_OF_DAY17
,      END_OF_DAY18
,      END_OF_DAY19
,      END_OF_DAY20
,      END_OF_DAY21
,      END_OF_DAY22
,      END_OF_DAY23
,      END_OF_DAY24
,      END_OF_DAY25
,      END_OF_DAY26
,      END_OF_DAY27
,      END_OF_DAY28
,      END_OF_DAY29
,      END_OF_DAY30
,      END_OF_DAY31
,      END_OF_DAY32
,      END_OF_DAY33
,      END_OF_DAY34
,      END_OF_DAY35
,      QUARTER_AGGREGATE1
,      QUARTER_AGGREGATE2
,      QUARTER_AGGREGATE3
,      QUARTER_AGGREGATE4
,      QUARTER_AGGREGATE5
,      QUARTER_AGGREGATE6
,      QUARTER_AGGREGATE7
,      QUARTER_AGGREGATE8
,      QUARTER_AGGREGATE9
,      QUARTER_AGGREGATE10
,      QUARTER_AGGREGATE11
,      QUARTER_AGGREGATE12
,      QUARTER_AGGREGATE13
,      QUARTER_AGGREGATE14
,      QUARTER_AGGREGATE15
,      QUARTER_AGGREGATE16
,      QUARTER_AGGREGATE17
,      QUARTER_AGGREGATE18
,      QUARTER_AGGREGATE19
,      QUARTER_AGGREGATE20
,      QUARTER_AGGREGATE21
,      QUARTER_AGGREGATE22
,      QUARTER_AGGREGATE23
,      QUARTER_AGGREGATE24
,      QUARTER_AGGREGATE25
,      QUARTER_AGGREGATE26
,      QUARTER_AGGREGATE27
,      QUARTER_AGGREGATE28
,      QUARTER_AGGREGATE29
,      QUARTER_AGGREGATE30
,      QUARTER_AGGREGATE31
,      QUARTER_AGGREGATE32
,      QUARTER_AGGREGATE33
,      QUARTER_AGGREGATE34
,      QUARTER_AGGREGATE35
,      YEAR_AGGREGATE1
,      YEAR_AGGREGATE2
,      YEAR_AGGREGATE3
,      YEAR_AGGREGATE4
,      YEAR_AGGREGATE5
,      YEAR_AGGREGATE6
,      YEAR_AGGREGATE7
,      YEAR_AGGREGATE8
,      YEAR_AGGREGATE9
,      YEAR_AGGREGATE10
,      YEAR_AGGREGATE11
,      YEAR_AGGREGATE12
,      YEAR_AGGREGATE13
,      YEAR_AGGREGATE14
,      YEAR_AGGREGATE15
,      YEAR_AGGREGATE16
,      YEAR_AGGREGATE17
,      YEAR_AGGREGATE18
,      YEAR_AGGREGATE19
,      YEAR_AGGREGATE20
,      YEAR_AGGREGATE21
,      YEAR_AGGREGATE22
,      YEAR_AGGREGATE23
,      YEAR_AGGREGATE24
,      YEAR_AGGREGATE25
,      YEAR_AGGREGATE26
,      YEAR_AGGREGATE27
,      YEAR_AGGREGATE28
,      YEAR_AGGREGATE29
,      YEAR_AGGREGATE30
,      YEAR_AGGREGATE31
,      YEAR_AGGREGATE32
,      YEAR_AGGREGATE33
,      YEAR_AGGREGATE34
,      YEAR_AGGREGATE35
FROM GL.GL_DAILY_POST_INT;

Dependencies

[top of page]

GL.GL_DAILY_POST_INT does not reference any database object

GL.GL_DAILY_POST_INT is referenced by following:

APPS: GL_DAILY_POST_INT