[Home] [Help] [Dependency Information]
Object Name: | CSF_R_PLAN_OPTION_TASKS |
---|---|
Object Type: | TABLE |
Owner: | CSF |
FND Design Data: | CSF.CSF_R_PLAN_OPTION_TASKS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSF_R_PLAN_OPTION_TASKS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PLAN_OPTION_TASK_ID |
CSF_R_PLAN_OPTION_TASKS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PLAN_OPTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_OPTION_TASK_ID | NUMBER | Yes | Primary key for table CSF_R_PLAN_OPTION_TASKS. | |
PLAN_OPTION_ID | NUMBER | Yes | Foreign key to table CSF_R_PLAN_OPTIONS. | |
TASK_ID | NUMBER | Foreign key to the task affected by the requests schedule action. | ||
SCHEDULED_START_DATE | DATE | The calculated/adjusted scheduled start date. | ||
SCHEDULED_END_DATE | DATE | The calculated/adjusted scheduled end date. | ||
TRAVEL_TIME | NUMBER | The calculated/adjusted travel time to the task. | ||
TASK_ASSIGNMENT_ID | NUMBER | Foreign key to table JTF_TASK_ASSIGNMENTS. Added to make some queries in Forms easier. Without this, Forms has to query the task assignment id based on the task id and the resource id from the associated plan option. | ||
SECURITY_GROUP_ID | NUMBER | Security group identifier. | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number. Number is incremented by one after every update. | |
OBJECT_CAPACITY_ID | NUMBER | Yes | The object capacity identifier is a foreign key to the trip. |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_OPTION_TASK_ID
, PLAN_OPTION_ID
, TASK_ID
, SCHEDULED_START_DATE
, SCHEDULED_END_DATE
, TRAVEL_TIME
, TASK_ASSIGNMENT_ID
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, OBJECT_CAPACITY_ID
FROM CSF.CSF_R_PLAN_OPTION_TASKS;
CSF.CSF_R_PLAN_OPTION_TASKS does not reference any database object
CSF.CSF_R_PLAN_OPTION_TASKS is referenced by following:
|
|
|