[Home] [Help] [Dependency Information]
Object Name: | JTF_CUSTOM_GRIDS |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_CUSTOM_GRIDS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_CUSTOM_GRIDS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CUSTOM_GRID_ID |
JTF_CUSTOM_GRIDS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CREATED_BY
LANGUAGE GRID_DATASOURCE_NAME CUSTOM_GRID_NAME |
JTF_CUSTOM_GRIDS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PUBLIC_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOM_GRID_ID | NUMBER | Yes | Unique customization identifier. | |
GRID_DATASOURCE_NAME | VARCHAR2 | (30) | Yes | The unique name that identifies a set of meta data. |
CUSTOM_GRID_NAME | VARCHAR2 | (80) | Yes | A user defined name for this particular set of customizations, unique within the current set of meta data and user. |
LANGUAGE | VARCHAR2 | (4) | Yes | Language. |
GRID_SORT_COL_ALIAS1 | VARCHAR2 | (30) | The first column the query will be sorted on (defined by the end user), for the current set of meta data. | |
PUBLIC_FLAG | VARCHAR2 | (1) | Yes | Flag (T or F) indicating if this particular set of customizations should be available to everyone. |
DEFAULT_ROW_HEIGHT | NUMBER | (2) | The number of lines displayed per row by default. | |
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. | |
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. | |
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). | |
WHERE_CLAUSE | VARCHAR2 | (2000) | An optional WHERE clause used to limit the number of rows returned from the database. The WHERE clause defined here will be appended to the one defined in the JTF_GRID_DATASOURCES table. | |
GRID_SORT_COL_ALIAS2 | VARCHAR2 | (30) | The second column the query will be sorted on (defined by the end user), for the current set of meta data. | |
GRID_SORT_COL_ALIAS3 | VARCHAR2 | (30) | The third column the query will be sorted on (defined by the end user), for the current set of meta data. | |
SECURITY_GROUP_ID | NUMBER | Security Group Id, used for hosting with VPD enabled |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOM_GRID_ID
, GRID_DATASOURCE_NAME
, CUSTOM_GRID_NAME
, LANGUAGE
, GRID_SORT_COL_ALIAS1
, PUBLIC_FLAG
, DEFAULT_ROW_HEIGHT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, WHERE_CLAUSE
, GRID_SORT_COL_ALIAS2
, GRID_SORT_COL_ALIAS3
, SECURITY_GROUP_ID
FROM JTF.JTF_CUSTOM_GRIDS;
JTF.JTF_CUSTOM_GRIDS does not reference any database object
JTF.JTF_CUSTOM_GRIDS is referenced by following:
|
|
|