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: JTF.JTF_GRID_COLS_B#

Object Details

Object Name:	JTF_GRID_COLS_B#
Object Type:	VIEW
Owner:	JTF
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
GRID_DATASOURCE_NAME	VARCHAR2	(30)	Yes
GRID_COL_ALIAS	VARCHAR2	(30)	Yes
DB_COL_NAME	VARCHAR2	(255)	Yes
DATA_TYPE_CODE	VARCHAR2	(30)	Yes
QUERY_SEQ	NUMBER	(3)	Yes
SORTABLE_FLAG	VARCHAR2	(1)	Yes
SORT_ASC_BY_DEFAULT_FLAG	VARCHAR2	(1)	Yes
VISIBLE_FLAG	VARCHAR2	(1)	Yes
FREEZE_VISIBLE_FLAG	VARCHAR2	(1)	Yes
DISPLAY_SEQ	NUMBER	(3)	Yes
DISPLAY_TYPE_CODE	VARCHAR2	(30)	Yes
DISPLAY_HSIZE	NUMBER	(6)	Yes
HEADER_ALIGNMENT_CODE	VARCHAR2	(30)	Yes
CELL_ALIGNMENT_CODE	VARCHAR2	(30)	Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
DISPLAY_FORMAT_TYPE_CODE	VARCHAR2	(30)
DISPLAY_FORMAT_MASK	VARCHAR2	(255)
CHECKBOX_CHECKED_VALUE	VARCHAR2	(255)
CHECKBOX_UNCHECKED_VALUE	VARCHAR2	(255)
CHECKBOX_OTHER_VALUES	VARCHAR2	(1)
DB_CURRENCY_CODE_COL	VARCHAR2	(30)
SECURITY_GROUP_ID	NUMBER
QUERY_ALLOWED_FLAG	VARCHAR2	(1)	Yes
VALIDATION_OBJECT_CODE	VARCHAR2	(30)
QUERY_DISPLAY_SEQ	NUMBER	(3)
DB_SORT_COLUMN	VARCHAR2	(255)
FIRE_POST_QUERY_FLAG	VARCHAR2	(1)
IMAGE_DESCRIPTION_COL	VARCHAR2	(240)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

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
,      ZD_EDITION_NAME
FROM JTF.JTF_GRID_COLS_B#;

Dependencies

[top of page]

JTF.JTF_GRID_COLS_B# references the following:

JTF: JTF_GRID_COLS_B

JTF.JTF_GRID_COLS_B# is referenced by following:

APPS: JTF_GRID_COLS_B; JTF_GRID_COLS_B+