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_TASK_CUSTOM_COLORS

Object Details

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

This table stores the custom color setup

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_TASK_CUSTOM_COLORS_U1	NORMAL	UNIQUE	APPS_TS_SEED	RULE_ID
JTF_TASK_CUSTOM_COLORS_U2	NORMAL	UNIQUE	APPS_TS_SEED	COLOR_DETERMINATION_PRIORITY

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_ID	NUMBER		Yes	Primay Key
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
COLOR_DETERMINATION_PRIORITY	NUMBER		Yes	A unique value to determine the rule in the order by the priority value
TYPE_ID	NUMBER			Task Type Id
PRIORITY_ID	NUMBER			Task Priority Id
ASSIGNMENT_STATUS_ID	NUMBER			Assignment status Id
ESCALATED_TASK	VARCHAR2	(1)		A flag to indicate the escalated task
BACKGROUND_COL_DEC	NUMBER		Yes	background decimal color
BACKGROUND_COL_RGB	VARCHAR2	(12)	Yes	backgroup rgb color
ACTIVE_FLAG	VARCHAR2	(1)	Yes	A flag to indicate that this rule is valid
CREATED_BY	NUMBER		Yes	WHO standard column
CREATION_DATE	DATE		Yes	WHO standard column
LAST_UPDATED_BY	NUMBER		Yes	WHO standard column
LAST_UPDATE_DATE	DATE		Yes	WHO standard column
LAST_UPDATE_LOGIN	NUMBER			WHO standard column

Query Text

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


SELECT RULE_ID
,      OBJECT_VERSION_NUMBER
,      COLOR_DETERMINATION_PRIORITY
,      TYPE_ID
,      PRIORITY_ID
,      ASSIGNMENT_STATUS_ID
,      ESCALATED_TASK
,      BACKGROUND_COL_DEC
,      BACKGROUND_COL_RGB
,      ACTIVE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM JTF.JTF_TASK_CUSTOM_COLORS;

Dependencies

[top of page]

JTF.JTF_TASK_CUSTOM_COLORS does not reference any database object

JTF.JTF_TASK_CUSTOM_COLORS is referenced by following:

APPS: JTF_TASK_CUSTOM_COLORS