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]

VIEW: APPS.JTF_GRID_COLS_VL

Object Details

Object Name:	JTF_GRID_COLS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_GRID_COLS_VL
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.

View Type

MultiLingual view (a language resolved view of the data.)

MLS view for JTF_GRID_COLS_B and JTF_GRID_COLS_TL

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id
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.
LABEL_TEXT	VARCHAR2	(80)	Yes	The Header Label for a column shown in a spreadtable UI component.
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)
FIRE_POST_QUERY_FLAG	VARCHAR2	(1)
IMAGE_DESCRIPTION_COL	VARCHAR2	(240)

Query Text

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


SELECT ROW_ID
,      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
,      LABEL_TEXT
,      QUERY_ALLOWED_FLAG
,      VALIDATION_OBJECT_CODE
,      QUERY_DISPLAY_SEQ
,      DB_SORT_COLUMN
,      FIRE_POST_QUERY_FLAG
,      IMAGE_DESCRIPTION_COL
FROM APPS.JTF_GRID_COLS_VL;

Dependencies

[top of page]

APPS.JTF_GRID_COLS_VL references the following:

APPS: JTF_GRID_COLS_B; JTF_GRID_COLS_TL

APPS.JTF_GRID_COLS_VL is referenced by following:

APPS: JTF_GRIDDB - show dependent code; JTF_GRID_COLS_PKG - show dependent code