[Home] [Help] [Dependency Information]
Object Name: | JTF_GRID_DATASOURCES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_GRID_DATASOURCES_VL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
MultiLingual view (a language resolved view of the data.)
MLS view for JTF_GRID_DATASOURCES_B and JTF_GRID_DATASOURCES_TL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Id. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
MAX_QUERIED_ROWS | NUMBER | (5) | The maximum number of rows returned by the query for this set of meta data. | |
WHERE_CLAUSE | VARCHAR2 | (2000) | An optional WHERE clause used to limit the number of rows returned from the database. NEVER start with the keyword "WHERE", this is automatically prepended to the statement. | |
ALT_COLOR_CODE | VARCHAR2 | (30) | An optional color code used to display every ALT_COLOR_INTERVAL in a spreadtable UI component in the given color. | |
ALT_COLOR_INTERVAL | NUMBER | (1) | The interval used to display alternating rows in a spreadtable UI component in the color specified in the ALT_COLOR_CODE column. | |
APPLICATION_ID | NUMBER | Yes | Application identifier | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
DB_VIEW_NAME | VARCHAR2 | (30) | Yes | The name of the database view that will be used to retrieve data. |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
GRID_DATASOURCE_NAME | VARCHAR2 | (30) | Yes | The unique name that identifies a set of meta data. Must always be |
DEFAULT_ROW_HEIGHT | NUMBER | (2) | Yes | The number of lines displayed per row by default. |
TITLE_TEXT | VARCHAR2 | (80) | Yes | The translated title for a set of meta data. |
FETCH_SIZE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, LAST_UPDATE_LOGIN
, MAX_QUERIED_ROWS
, WHERE_CLAUSE
, ALT_COLOR_CODE
, ALT_COLOR_INTERVAL
, APPLICATION_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, DB_VIEW_NAME
, CREATED_BY
, CREATION_DATE
, GRID_DATASOURCE_NAME
, DEFAULT_ROW_HEIGHT
, TITLE_TEXT
, FETCH_SIZE
FROM APPS.JTF_GRID_DATASOURCES_VL;
|
|
|