eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JTF.JTF_GRID_COLS_B

Object Details

Object Name:	JTF_GRID_COLS_B
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_GRID_COLS_B
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_GRID_COLS_B_U1	NORMAL	UNIQUE	APPS_TS_SEED	GRID_DATASOURCE_NAME GRID_COL_ALIAS
JTF_GRID_COLS_B_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	VALIDATION_OBJECT_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
GRID_DATASOURCE_NAME	VARCHAR2	(30)	Yes	The unique name that identifies a set of meta data.
GRID_COL_ALIAS	VARCHAR2	(30)	Yes	A unique alias within the current set of meta data defined for a database view column. Use this alias when referring to column values in your custom code.
DB_COL_NAME	VARCHAR2	(255)	Yes	The database view column.
DATA_TYPE_CODE	VARCHAR2	(30)	Yes	Data Type code.
QUERY_SEQ	NUMBER	(3)	Yes	The order that the columns should be selected in. IMPORTANT: For performance reasons, start with the columns that you will refer to in your code, for example the primary key columns.
SORTABLE_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether the end user should be able to sort on the current column.
SORT_ASC_BY_DEFAULT_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether the default sort order should be ascending or not.
VISIBLE_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether the column should be displayed or not.
FREEZE_VISIBLE_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether the end user should be able to change the visible property (hide / show) for the column.
DISPLAY_SEQ	NUMBER	(3)	Yes	The default sequence that the columns will be displayed in.
DISPLAY_TYPE_CODE	VARCHAR2	(30)	Yes	The display type for the column.
DISPLAY_HSIZE	NUMBER	(6)	Yes	The display width of the column in pixels.
HEADER_ALIGNMENT_CODE	VARCHAR2	(30)	Yes	The alignment for the column header label.
CELL_ALIGNMENT_CODE	VARCHAR2	(30)	Yes	The cell alignment for this column.
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).
DISPLAY_FORMAT_TYPE_CODE	VARCHAR2	(30)		The display format type, i.e. predefined format masks will be applied to the column value automatically depeding on its datatype and display type.
DISPLAY_FORMAT_MASK	VARCHAR2	(255)		The format mask that will be applied to the column value when it is retrieved from the database, this should be used sparingly and only in rare cases.
CHECKBOX_CHECKED_VALUE	VARCHAR2	(255)		The column value that should be represented as a checked checkbox or corresponding image.
CHECKBOX_UNCHECKED_VALUE	VARCHAR2	(255)		The column value that should be represented as an unchecked checkbox or corresponding image.
CHECKBOX_OTHER_VALUES	VARCHAR2	(1)		How other values should be displayed than those specified in CHECKED_VALUE or UNCHECKED_VALUE, as a checked or unchecked checkbox or their corresponding images.
DB_CURRENCY_CODE_COL	VARCHAR2	(30)		The database view column where the currency code for the current column is stored.
SECURITY_GROUP_ID	NUMBER			Security Group Id, used for hosting with VPD enabled
QUERY_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Are end user queries allowed on this field? (only used by Universal Work Queue)
VALIDATION_OBJECT_CODE	VARCHAR2	(30)		Object Code. (only used by Universal Work Queue to display a list of allowable values)
QUERY_DISPLAY_SEQ	NUMBER	(3)		Order in which to display fields for an end user to enter query criteria (only used by Universal Work Queue)
DB_SORT_COLUMN	VARCHAR2	(255)		Column used for sorting
FIRE_POST_QUERY_FLAG	VARCHAR2	(1)		Flag indicating whether a post-query is required to retrieve the value for the column
IMAGE_DESCRIPTION_COL	VARCHAR2	(240)		Database column to retrieve image descriptions

Query Text

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


SELECT GRID_DATASOURCE_NAME
,      GRID_COL_ALIAS
,      DB_COL_NAME
,      DATA_TYPE_CODE
,      QUERY_SEQ
,      SORTABLE_FLAG
,      SORT_ASC_BY_DEFAULT_FLAG
,      VISIBLE_FLAG
,      FREEZE_VISIBLE_FLAG
,      DISPLAY_SEQ
,      DISPLAY_TYPE_CODE
,      DISPLAY_HSIZE
,      HEADER_ALIGNMENT_CODE
,      CELL_ALIGNMENT_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DISPLAY_FORMAT_TYPE_CODE
,      DISPLAY_FORMAT_MASK
,      CHECKBOX_CHECKED_VALUE
,      CHECKBOX_UNCHECKED_VALUE
,      CHECKBOX_OTHER_VALUES
,      DB_CURRENCY_CODE_COL
,      SECURITY_GROUP_ID
,      QUERY_ALLOWED_FLAG
,      VALIDATION_OBJECT_CODE
,      QUERY_DISPLAY_SEQ
,      DB_SORT_COLUMN
,      FIRE_POST_QUERY_FLAG
,      IMAGE_DESCRIPTION_COL
FROM JTF.JTF_GRID_COLS_B;

Dependencies

[top of page]

JTF.JTF_GRID_COLS_B does not reference any database object

JTF.JTF_GRID_COLS_B is referenced by following:

APPS: JTF_GRID_COLS_B