[Home] [Help] [Dependency Information]
Object Name: | GL_BC_OPTIONS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_BC_OPTIONS |
Subobject Name: | |
Status: | VALID |
GL_BC_OPTIONS contains information about the budgetary control options you define using the Define Budgetary Control Option form. Each record includes the budgetary control option's unique ID number, name and description..
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_BC_OPTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BC_OPTION_ID
ZD_EDITION_NAME |
GL_BC_OPTIONS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BC_OPTION_NAME
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BC_OPTION_ID | NUMBER | (15) | Yes | Budgetary control option defining column |
BC_OPTION_NAME | VARCHAR2 | (30) | Yes | Budgetary control option name |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
DESCRIPTION | VARCHAR2 | (240) | Budgetary control option description | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context 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 | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BC_OPTION_ID
, BC_OPTION_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, DESCRIPTION
, LAST_UPDATE_LOGIN
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ZD_EDITION_NAME
FROM GL.GL_BC_OPTIONS;
GL.GL_BC_OPTIONS does not reference any database object
GL.GL_BC_OPTIONS is referenced by following:
|
|
|