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

TABLE: GL.GL_BUDGET_TYPES

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


GL_BUDGET_TYPES stores information about budget types. Oracle General Ledger supports only one budget type, 'STANDARD'. Therefore, this table always contains only one row. This table has no foreign keys other than the standard Who columns.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_BUDGET_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnBUDGET_TYPE
Columns
Name Datatype Length Mandatory Comments
BUDGET_TYPE VARCHAR2 (15) Yes Budget type defining column (always STANDARD)
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
AUDIT_TRAIL_FLAG VARCHAR2 (1) Yes Provide audit trail flag
DESCRIPTION VARCHAR2 (240)
Budget type description
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
CONTEXT VARCHAR2 (150)
Descriptive flex context column
Query Text

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


SELECT BUDGET_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      AUDIT_TRAIL_FLAG
,      DESCRIPTION
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      CONTEXT
FROM GL.GL_BUDGET_TYPES;

Dependencies

[top of page]

GL.GL_BUDGET_TYPES does not reference any database object

GL.GL_BUDGET_TYPES is referenced by following:

SchemaGL
ViewGL_BUDGET_TYPES#