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_BUD_DOWNLOAD_GT

Object Details

Object Name:	GL_BUD_DOWNLOAD_GT
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_BUD_DOWNLOAD_GT
Subobject Name:
Status:	VALID

Temporary Table Details

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

Columns

Name	Datatype	Length
PERIOD1_AMOUNT	NUMBER
PERIOD2_AMOUNT	NUMBER
PERIOD3_AMOUNT	NUMBER
PERIOD4_AMOUNT	NUMBER
PERIOD5_AMOUNT	NUMBER
PERIOD6_AMOUNT	NUMBER
PERIOD7_AMOUNT	NUMBER
PERIOD8_AMOUNT	NUMBER
PERIOD9_AMOUNT	NUMBER
PERIOD10_AMOUNT	NUMBER
PERIOD11_AMOUNT	NUMBER
PERIOD12_AMOUNT	NUMBER
PERIOD13_AMOUNT	NUMBER
PERIOD14_AMOUNT	NUMBER
PERIOD15_AMOUNT	NUMBER
PERIOD16_AMOUNT	NUMBER
PERIOD17_AMOUNT	NUMBER
PERIOD18_AMOUNT	NUMBER
PERIOD19_AMOUNT	NUMBER
PERIOD20_AMOUNT	NUMBER
PERIOD21_AMOUNT	NUMBER
PERIOD22_AMOUNT	NUMBER
PERIOD23_AMOUNT	NUMBER
PERIOD24_AMOUNT	NUMBER
PERIOD25_AMOUNT	NUMBER
PERIOD26_AMOUNT	NUMBER
PERIOD27_AMOUNT	NUMBER
PERIOD28_AMOUNT	NUMBER
PERIOD29_AMOUNT	NUMBER
PERIOD30_AMOUNT	NUMBER
PERIOD31_AMOUNT	NUMBER
PERIOD32_AMOUNT	NUMBER
PERIOD33_AMOUNT	NUMBER
PERIOD34_AMOUNT	NUMBER
PERIOD35_AMOUNT	NUMBER
PERIOD36_AMOUNT	NUMBER
PERIOD37_AMOUNT	NUMBER
PERIOD38_AMOUNT	NUMBER
PERIOD39_AMOUNT	NUMBER
PERIOD40_AMOUNT	NUMBER
PERIOD41_AMOUNT	NUMBER
PERIOD42_AMOUNT	NUMBER
PERIOD43_AMOUNT	NUMBER
PERIOD44_AMOUNT	NUMBER
PERIOD45_AMOUNT	NUMBER
PERIOD46_AMOUNT	NUMBER
PERIOD47_AMOUNT	NUMBER
PERIOD48_AMOUNT	NUMBER
PERIOD49_AMOUNT	NUMBER
PERIOD50_AMOUNT	NUMBER
PERIOD51_AMOUNT	NUMBER
PERIOD52_AMOUNT	NUMBER
PERIOD53_AMOUNT	NUMBER
PERIOD54_AMOUNT	NUMBER
PERIOD55_AMOUNT	NUMBER
PERIOD56_AMOUNT	NUMBER
PERIOD57_AMOUNT	NUMBER
PERIOD58_AMOUNT	NUMBER
PERIOD59_AMOUNT	NUMBER
PERIOD60_AMOUNT	NUMBER
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)
SEGMENT1_DESC	VARCHAR2	(240)
SEGMENT2_DESC	VARCHAR2	(240)
SEGMENT3_DESC	VARCHAR2	(240)
SEGMENT4_DESC	VARCHAR2	(240)
SEGMENT5_DESC	VARCHAR2	(240)
SEGMENT6_DESC	VARCHAR2	(240)
SEGMENT7_DESC	VARCHAR2	(240)
SEGMENT8_DESC	VARCHAR2	(240)
SEGMENT9_DESC	VARCHAR2	(240)
SEGMENT10_DESC	VARCHAR2	(240)
SEGMENT11_DESC	VARCHAR2	(240)
SEGMENT12_DESC	VARCHAR2	(240)
SEGMENT13_DESC	VARCHAR2	(240)
SEGMENT14_DESC	VARCHAR2	(240)
SEGMENT15_DESC	VARCHAR2	(240)
SEGMENT16_DESC	VARCHAR2	(240)
SEGMENT17_DESC	VARCHAR2	(240)
SEGMENT18_DESC	VARCHAR2	(240)
SEGMENT19_DESC	VARCHAR2	(240)
SEGMENT20_DESC	VARCHAR2	(240)
SEGMENT21_DESC	VARCHAR2	(240)
SEGMENT22_DESC	VARCHAR2	(240)
SEGMENT23_DESC	VARCHAR2	(240)
SEGMENT24_DESC	VARCHAR2	(240)
SEGMENT25_DESC	VARCHAR2	(240)
SEGMENT26_DESC	VARCHAR2	(240)
SEGMENT27_DESC	VARCHAR2	(240)
SEGMENT28_DESC	VARCHAR2	(240)
SEGMENT29_DESC	VARCHAR2	(240)
SEGMENT30_DESC	VARCHAR2	(240)
CODE_COMBINATION_ID	NUMBER	(15)
BNE_READ_ONLY_FLAG	VARCHAR2	(15)
ACTUAL_FLAG	VARCHAR2	(3)

Query Text

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


SELECT PERIOD1_AMOUNT
,      PERIOD2_AMOUNT
,      PERIOD3_AMOUNT
,      PERIOD4_AMOUNT
,      PERIOD5_AMOUNT
,      PERIOD6_AMOUNT
,      PERIOD7_AMOUNT
,      PERIOD8_AMOUNT
,      PERIOD9_AMOUNT
,      PERIOD10_AMOUNT
,      PERIOD11_AMOUNT
,      PERIOD12_AMOUNT
,      PERIOD13_AMOUNT
,      PERIOD14_AMOUNT
,      PERIOD15_AMOUNT
,      PERIOD16_AMOUNT
,      PERIOD17_AMOUNT
,      PERIOD18_AMOUNT
,      PERIOD19_AMOUNT
,      PERIOD20_AMOUNT
,      PERIOD21_AMOUNT
,      PERIOD22_AMOUNT
,      PERIOD23_AMOUNT
,      PERIOD24_AMOUNT
,      PERIOD25_AMOUNT
,      PERIOD26_AMOUNT
,      PERIOD27_AMOUNT
,      PERIOD28_AMOUNT
,      PERIOD29_AMOUNT
,      PERIOD30_AMOUNT
,      PERIOD31_AMOUNT
,      PERIOD32_AMOUNT
,      PERIOD33_AMOUNT
,      PERIOD34_AMOUNT
,      PERIOD35_AMOUNT
,      PERIOD36_AMOUNT
,      PERIOD37_AMOUNT
,      PERIOD38_AMOUNT
,      PERIOD39_AMOUNT
,      PERIOD40_AMOUNT
,      PERIOD41_AMOUNT
,      PERIOD42_AMOUNT
,      PERIOD43_AMOUNT
,      PERIOD44_AMOUNT
,      PERIOD45_AMOUNT
,      PERIOD46_AMOUNT
,      PERIOD47_AMOUNT
,      PERIOD48_AMOUNT
,      PERIOD49_AMOUNT
,      PERIOD50_AMOUNT
,      PERIOD51_AMOUNT
,      PERIOD52_AMOUNT
,      PERIOD53_AMOUNT
,      PERIOD54_AMOUNT
,      PERIOD55_AMOUNT
,      PERIOD56_AMOUNT
,      PERIOD57_AMOUNT
,      PERIOD58_AMOUNT
,      PERIOD59_AMOUNT
,      PERIOD60_AMOUNT
,      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
,      SEGMENT1_DESC
,      SEGMENT2_DESC
,      SEGMENT3_DESC
,      SEGMENT4_DESC
,      SEGMENT5_DESC
,      SEGMENT6_DESC
,      SEGMENT7_DESC
,      SEGMENT8_DESC
,      SEGMENT9_DESC
,      SEGMENT10_DESC
,      SEGMENT11_DESC
,      SEGMENT12_DESC
,      SEGMENT13_DESC
,      SEGMENT14_DESC
,      SEGMENT15_DESC
,      SEGMENT16_DESC
,      SEGMENT17_DESC
,      SEGMENT18_DESC
,      SEGMENT19_DESC
,      SEGMENT20_DESC
,      SEGMENT21_DESC
,      SEGMENT22_DESC
,      SEGMENT23_DESC
,      SEGMENT24_DESC
,      SEGMENT25_DESC
,      SEGMENT26_DESC
,      SEGMENT27_DESC
,      SEGMENT28_DESC
,      SEGMENT29_DESC
,      SEGMENT30_DESC
,      CODE_COMBINATION_ID
,      BNE_READ_ONLY_FLAG
,      ACTUAL_FLAG
FROM GL.GL_BUD_DOWNLOAD_GT;

Dependencies

[top of page]

GL.GL_BUD_DOWNLOAD_GT does not reference any database object

GL.GL_BUD_DOWNLOAD_GT is referenced by following:

APPS: GL_BUD_DOWNLOAD_GT