[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_BUDGET_ENTITIES |
|---|---|
| Object Type: | TABLE |
| Owner: | GL |
| FND Design Data: |  SQLGL.GL_BUDGET_ENTITIES
|
| Subobject Name: | |
| Status: | VALID |
GL_BUDGET_ENTITIES stores information about your budget organizations. Each row includes the organization name, description, ledger ID, and optional password. Each row also stores the segment display order for the Enter Budget Amounts form. This table corresponds to the Define Budget Organization window of the Define Budget Organization form.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_BUDGET_ENTITIES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 BUDGET_ENTITY_ID
|
| GL_BUDGET_ENTITIES_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
NAME
LEDGER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BUDGET_ENTITY_ID | NUMBER | (15) | Yes | Budget organization defining column |
| NAME | VARCHAR2 | (25) | Yes | Budget organization name |
| LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| BUDGET_PASSWORD_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Budget Organization password required flag |
| STATUS_CODE | VARCHAR2 | (1) | Yes | Budget organization status ('C'urrent or 'D'eleted) |
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| ENCRYPTED_BUDGET_PASSWORD | VARCHAR2 | (100) | Encrypted budget organization password | |
| DESCRIPTION | VARCHAR2 | (240) | Budget Organization description | |
| START_DATE | DATE | Starting date of when your Budget Organization active | ||
| END_DATE | DATE | End date of your Budget Organization after which it is no longer active | ||
| SEGMENT1_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT2_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT3_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT4_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT5_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT6_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT7_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT8_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT9_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT10_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT11_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT12_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT13_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT14_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT15_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT16_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT17_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT18_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT19_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT20_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT21_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT22_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT23_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT24_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT25_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT26_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT27_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT28_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT29_TYPE | NUMBER | (15) | Segment order column | |
| SEGMENT30_TYPE | NUMBER | (15) | Segment order column | |
| 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 | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Extended Who column | |
| PROGRAM_ID | NUMBER | (15) | Extended Who column | |
| PROGRAM_UPDATE_DATE | DATE | Extended Who column | ||
| REQUEST_ID | NUMBER | (15) | Concurrent program request id | |
| SECURITY_FLAG | VARCHAR2 | (1) | Yes | Enable definition access set security flag |
Cut, paste (and edit) the following text to query this object:
SELECT BUDGET_ENTITY_ID
, NAME
, LEDGER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, BUDGET_PASSWORD_REQUIRED_FLAG
, STATUS_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ENCRYPTED_BUDGET_PASSWORD
, DESCRIPTION
, START_DATE
, END_DATE
, SEGMENT1_TYPE
, SEGMENT2_TYPE
, SEGMENT3_TYPE
, SEGMENT4_TYPE
, SEGMENT5_TYPE
, SEGMENT6_TYPE
, SEGMENT7_TYPE
, SEGMENT8_TYPE
, SEGMENT9_TYPE
, SEGMENT10_TYPE
, SEGMENT11_TYPE
, SEGMENT12_TYPE
, SEGMENT13_TYPE
, SEGMENT14_TYPE
, SEGMENT15_TYPE
, SEGMENT16_TYPE
, SEGMENT17_TYPE
, SEGMENT18_TYPE
, SEGMENT19_TYPE
, SEGMENT20_TYPE
, SEGMENT21_TYPE
, SEGMENT22_TYPE
, SEGMENT23_TYPE
, SEGMENT24_TYPE
, SEGMENT25_TYPE
, SEGMENT26_TYPE
, SEGMENT27_TYPE
, SEGMENT28_TYPE
, SEGMENT29_TYPE
, SEGMENT30_TYPE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CONTEXT
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, SECURITY_FLAG
FROM GL.GL_BUDGET_ENTITIES;
GL.GL_BUDGET_ENTITIES does not reference any database object
GL.GL_BUDGET_ENTITIES is referenced by following:
APPS
GL_BUDGET_ENTITIES
|
|
|
|