[Home] [Help] [Dependency Information]
Object Name: | GL_DAILY_BALANCES# |
---|---|
Object Type: | VIEW |
Owner: | GL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
CONVERTED_FROM_CURRENCY | VARCHAR2 | (15) | ||
PERIOD_TYPE | VARCHAR2 | (15) | ||
PERIOD_YEAR | NUMBER | (15) | ||
PERIOD_NUM | NUMBER | (15) | ||
TEMPLATE_ID | NUMBER | (15) | ||
OPENING_PERIOD_AGGREGATE | NUMBER | |||
OPENING_QUARTER_AGGREGATE | NUMBER | |||
OPENING_YEAR_AGGREGATE | 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 |
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
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CONVERTED_FROM_CURRENCY
, PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NUM
, TEMPLATE_ID
, OPENING_PERIOD_AGGREGATE
, OPENING_QUARTER_AGGREGATE
, OPENING_YEAR_AGGREGATE
, 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_BALANCES#;
|
|
|