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

TABLE: JTF.JTA_TASK_EXCLUSIONS

Object Details
Object Name: JTA_TASK_EXCLUSIONS
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTA_TASK_EXCLUSIONS
Subobject Name:
Status: VALID


Stores the information of tasks/appointments excluded from a repeating series.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTA_TASK_EXCLUSIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECURRENCE_RULE_ID
JTA_TASK_EXCLUSIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTASK_ID
Columns
Name Datatype Length Mandatory Comments
TASK_EXCLUSION_ID NUMBER
Yes Task Exclusion identifier.
TASK_ID NUMBER
Yes Task identifier. Foreign Key to JTF_TASKS_B
RECURRENCE_RULE_ID NUMBER
Yes Recurrence rule identifier. Foriegn Key to JTF_TASK_RECUR_RULES
EXCLUSION_DATE DATE
Yes Calendar start date of the task excluded.
CREATED_BY NUMBER
Yes Standard Who Column - Created By
CREATION_DATE DATE
Yes Standard Who Column - Creation Date
LAST_UPDATED_BY NUMBER
Yes Standard Who Column - Last Updated By
LAST_UPDATE_DATE DATE
Yes Standard Who Column - Last Update Date
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who Column - Last Update Login
SECURITY_GROUP_ID NUMBER

Used in hosted environment
Query Text

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


SELECT TASK_EXCLUSION_ID
,      TASK_ID
,      RECURRENCE_RULE_ID
,      EXCLUSION_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM JTF.JTA_TASK_EXCLUSIONS;

Dependencies

[top of page]

JTF.JTA_TASK_EXCLUSIONS does not reference any database object

JTF.JTA_TASK_EXCLUSIONS is referenced by following:

SchemaAPPS
SynonymJTA_TASK_EXCLUSIONS