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

TABLE: GL.GL_BUDGET_PERIOD_RANGES

Object Details
Object Name: GL_BUDGET_PERIOD_RANGES
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_BUDGET_PERIOD_RANGES
Subobject Name:
Status: VALID


GL_BUDGET_PERIOD_RANGES stores the period ranges for a budget using the Enter Budget Amounts form. Each open year of your budget is divided into one or more period ranges. Each range spans up to 13 periods, and a range cannot cross a fiscal year. The Open Budget Year program inserts one row into this table for each period range in the year that you open. The Open_Flag column is always 'O'.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_BUDGET_PERIOD_RANGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_VERSION_ID
ColumnPERIOD_YEAR
ColumnSTART_PERIOD_NUM
Columns
Name Datatype Length Mandatory Comments
BUDGET_VERSION_ID NUMBER (15) Yes Budget version defining column
PERIOD_YEAR NUMBER (15) Yes Fiscal year accounting period falls in
START_PERIOD_NAME VARCHAR2 (15) Yes First accounting period of range
START_PERIOD_NUM NUMBER (15) Yes Number of first accounting period of range
END_PERIOD_NAME VARCHAR2 (15) Yes Final accounting period of range
END_PERIOD_NUM NUMBER (15) Yes Number of final accounting period of range
OPEN_FLAG VARCHAR2 (1) Yes Open range flag
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
Query Text

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


SELECT BUDGET_VERSION_ID
,      PERIOD_YEAR
,      START_PERIOD_NAME
,      START_PERIOD_NUM
,      END_PERIOD_NAME
,      END_PERIOD_NUM
,      OPEN_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM GL.GL_BUDGET_PERIOD_RANGES;

Dependencies

[top of page]

GL.GL_BUDGET_PERIOD_RANGES does not reference any database object

GL.GL_BUDGET_PERIOD_RANGES is referenced by following:

SchemaGL
ViewGL_BUDGET_PERIOD_RANGES#