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

VIEW: APPS.JTF_AGENDA_V

Object Details
Object Name: JTF_AGENDA_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_AGENDA_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view performs several calculations on the assigned tasks, selected by the JTF_AGENDA_TA_V view. These calculations consist of the following:
- Predict start and end times of the assigned task
- Get shift start and end times of the resource
- Determine current task and status of the resource


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Rowid JTF_TASK_ASSIGNMENTS record
TASK_ASSIGNMENT_ID NUMBER
Yes Corresponds with column in the JTF_TASK_ASSIGNMENTS table
CREATED_BY NUMBER
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
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

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TASK_ID NUMBER
Yes Corresponds with column in the JTF_TASK_ASSIGNMENTS table
RESOURCE_TYPE_CODE VARCHAR2 (30) Yes Corresponds with column in the JTF_TASK_ASSIGNMENTS table
RESOURCE_ID NUMBER
Yes Corresponds with column in the JTF_TASK_ASSIGNMENTS table
ACTUAL_EFFORT NUMBER

Corresponds with column in the JTF_TASK_ASSIGNMENTS table
ACTUAL_EFFORT_UOM VARCHAR2 (3)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
SCHEDULE_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
ALARM_TYPE_CODE VARCHAR2 (30)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
ALARM_CONTACT VARCHAR2 (200)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
SCHED_TRAVEL_DISTANCE NUMBER

Corresponds with column in the JTF_TASK_ASSIGNMENTS table
SCHED_TRAVEL_DURATION NUMBER

Corresponds with column in the JTF_TASK_ASSIGNMENTS table
SCHED_TRAVEL_DURATION_UOM VARCHAR2 (3)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
ACTUAL_TRAVEL_DISTANCE NUMBER

Corresponds with column in the JTF_TASK_ASSIGNMENTS table
ACTUAL_TRAVEL_DURATION NUMBER

Corresponds with column in the JTF_TASK_ASSIGNMENTS table
ACTUAL_TRAVEL_DURATION_UOM VARCHAR2 (3)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
ACTUAL_START_DATE DATE

Corresponds with column in the JTF_TASK_ASSIGNMENTS table
ACTUAL_END_DATE DATE

Corresponds with column in the JTF_TASK_ASSIGNMENTS table
PALM_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
WINCE_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
LAPTOP_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
DEVICE1_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
DEVICE2_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
DEVICE3_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASK_ASSIGNMENTS table
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
OBJECT_VERSION_NUMBER NUMBER
Yes Corresponds with column in the JTF_TASK_ASSIGNMENTS table
RESOURCE_TERRITORY_ID NUMBER

Corresponds with column in the JTF_TASK_ASSIGNMENTS table
ASSIGNMENT_STATUS_ID NUMBER
Yes Corresponds with column in the JTF_TASK_ASSIGNMENTS table
SHIFT_CONSTRUCT_ID NUMBER

Corresponds with column in the JTF_TASK_ASSIGNMENTS table
TASK_NUMBER VARCHAR2 (30) Yes Corresponds with column in the JTF_TASKS_B table
TASK_TYPE_ID NUMBER
Yes Corresponds with column in the JTF_TASKS_B table
TASK_STATUS_ID NUMBER
Yes Corresponds with column in the JTF_TASKS_B table
TASK_PRIORITY_ID NUMBER

Corresponds with column in the JTF_TASKS_B table
OWNER_TYPE_CODE VARCHAR2 (30) Yes Corresponds with column in the JTF_TASKS_B table
OWNER_ID NUMBER
Yes Corresponds with column in the JTF_TASKS_B table
ASSIGNED_BY_ID NUMBER

Corresponds with column in the JTF_TASKS_B table
CUST_ACCOUNT_ID NUMBER

Corresponds with column in the JTF_TASKS_B table
CUSTOMER_ID NUMBER

Corresponds with column in the JTF_TASKS_B table
ADDRESS_ID NUMBER

Corresponds with column in the JTF_TASKS_B table
PLANNED_START_DATE DATE

Corresponds with column in the JTF_TASKS_B table
PLANNED_END_DATE DATE

Corresponds with column in the JTF_TASKS_B table
SCHEDULED_START_DATE DATE

Corresponds with column in the JTF_TASKS_B table
SCHEDULED_END_DATE DATE

Corresponds with column in the JTF_TASKS_B table
TIMEZONE_ID NUMBER

Corresponds with column in the JTF_TASKS_B table
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
Corresponds with column in the JTF_TASKS_B table
SOURCE_OBJECT_ID NUMBER

Corresponds with column in the JTF_TASKS_B table
SOURCE_OBJECT_NAME VARCHAR2 (80)
Corresponds with column in the JTF_TASKS_B table
DURATION NUMBER

Corresponds with column in the JTF_TASKS_B table
DURATION_UOM VARCHAR2 (3)
Corresponds with column in the JTF_TASKS_B table
PLANNED_EFFORT NUMBER

Corresponds with column in the JTF_TASKS_B table
PLANNED_EFFORT_UOM VARCHAR2 (3)
Corresponds with column in the JTF_TASKS_B table
PERCENTAGE_COMPLETE NUMBER

Corresponds with column in the JTF_TASKS_B table
REASON_CODE VARCHAR2 (30)
Corresponds with column in the JTF_TASKS_B table
PRIVATE_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASKS_B table
PUBLISH_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASKS_B table
RESTRICT_CLOSURE_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASKS_B table
MULTI_BOOKED_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASKS_B table
MILESTONE_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASKS_B table
HOLIDAY_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASKS_B table
BILLABLE_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASKS_B table
BOUND_MODE_CODE VARCHAR2 (30)
Corresponds with column in the JTF_TASKS_B table
SOFT_BOUND_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASKS_B table
WORKFLOW_PROCESS_ID NUMBER

Corresponds with column in the JTF_TASKS_B table
ESCALATION_FLAG VARCHAR2 (4000)
Corresponds with column in the JTF_TASKS_B table
ESCALATION_LEVEL VARCHAR2 (30)
Corresponds with column in the JTF_TASKS_B table
NOTIFICATION_FLAG VARCHAR2 (1)
Corresponds with column in the JTF_TASKS_B table
NOTIFICATION_PERIOD NUMBER

Corresponds with column in the JTF_TASKS_B table
NOTIFICATION_PERIOD_UOM VARCHAR2 (3)
Corresponds with column in the JTF_TASKS_B table
PARENT_TASK_ID NUMBER

Corresponds with column in the JTF_TASKS_B table
ALARM_START NUMBER

Corresponds with column in the JTF_TASKS_B table
ALARM_START_UOM VARCHAR2 (3)
Corresponds with column in the JTF_TASKS_B table
ALARM_ON VARCHAR2 (1)
Corresponds with column in the JTF_TASKS_B table
ALARM_COUNT NUMBER

Corresponds with column in the JTF_TASKS_B table
ALARM_FIRED_COUNT NUMBER

Corresponds with column in the JTF_TASKS_B table
ALARM_INTERVAL NUMBER

Corresponds with column in the JTF_TASKS_B table
ALARM_INTERVAL_UOM VARCHAR2 (3)
Corresponds with column in the JTF_TASKS_B table
RECURRENCE_RULE_ID NUMBER

Corresponds with column in the JTF_TASKS_B table
COSTS NUMBER

Corresponds with column in the JTF_TASKS_B table
CURRENCY_CODE VARCHAR2 (15)
Corresponds with column in the JTF_TASKS_B table
ORG_ID NUMBER

Organization identifier
SHIFT_START DATE

Start time of the shift of the resource
SHIFT_END DATE

End time of the shift of the resource
PREDICTED_START_DATE DATE

Predicted start date of the task
PREDICTED_END_DATE DATE

Predicted end date of the task
OUT_OF_SEQUENCE_FLAG VARCHAR2 (1)
Indicates whether scheduled sequence has been broken
CURRENT_STATUS_ID NUMBER

The status id of the assignment which contains the most recent actual start (or end) date of a resource.
CURRENT_STATUS_NAME VARCHAR2 (30)
The name of the CURRENT_STATUS_ID
ASSIGNMENT_STATUS_NAME VARCHAR2 (30)
The name of the ASSIGNMENT_STATUS_ID
CURRENT_TASK_ID NUMBER

The task id of the assignment which contains the most recent actual start (or end) date of a resource.
Query Text

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


SELECT ROW_ID
,      TASK_ASSIGNMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TASK_ID
,      RESOURCE_TYPE_CODE
,      RESOURCE_ID
,      ACTUAL_EFFORT
,      ACTUAL_EFFORT_UOM
,      SCHEDULE_FLAG
,      ALARM_TYPE_CODE
,      ALARM_CONTACT
,      SCHED_TRAVEL_DISTANCE
,      SCHED_TRAVEL_DURATION
,      SCHED_TRAVEL_DURATION_UOM
,      ACTUAL_TRAVEL_DISTANCE
,      ACTUAL_TRAVEL_DURATION
,      ACTUAL_TRAVEL_DURATION_UOM
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      PALM_FLAG
,      WINCE_FLAG
,      LAPTOP_FLAG
,      DEVICE1_FLAG
,      DEVICE2_FLAG
,      DEVICE3_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      OBJECT_VERSION_NUMBER
,      RESOURCE_TERRITORY_ID
,      ASSIGNMENT_STATUS_ID
,      SHIFT_CONSTRUCT_ID
,      TASK_NUMBER
,      TASK_TYPE_ID
,      TASK_STATUS_ID
,      TASK_PRIORITY_ID
,      OWNER_TYPE_CODE
,      OWNER_ID
,      ASSIGNED_BY_ID
,      CUST_ACCOUNT_ID
,      CUSTOMER_ID
,      ADDRESS_ID
,      PLANNED_START_DATE
,      PLANNED_END_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      TIMEZONE_ID
,      SOURCE_OBJECT_TYPE_CODE
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NAME
,      DURATION
,      DURATION_UOM
,      PLANNED_EFFORT
,      PLANNED_EFFORT_UOM
,      PERCENTAGE_COMPLETE
,      REASON_CODE
,      PRIVATE_FLAG
,      PUBLISH_FLAG
,      RESTRICT_CLOSURE_FLAG
,      MULTI_BOOKED_FLAG
,      MILESTONE_FLAG
,      HOLIDAY_FLAG
,      BILLABLE_FLAG
,      BOUND_MODE_CODE
,      SOFT_BOUND_FLAG
,      WORKFLOW_PROCESS_ID
,      ESCALATION_FLAG
,      ESCALATION_LEVEL
,      NOTIFICATION_FLAG
,      NOTIFICATION_PERIOD
,      NOTIFICATION_PERIOD_UOM
,      PARENT_TASK_ID
,      ALARM_START
,      ALARM_START_UOM
,      ALARM_ON
,      ALARM_COUNT
,      ALARM_FIRED_COUNT
,      ALARM_INTERVAL
,      ALARM_INTERVAL_UOM
,      RECURRENCE_RULE_ID
,      COSTS
,      CURRENCY_CODE
,      ORG_ID
,      SHIFT_START
,      SHIFT_END
,      PREDICTED_START_DATE
,      PREDICTED_END_DATE
,      OUT_OF_SEQUENCE_FLAG
,      CURRENT_STATUS_ID
,      CURRENT_STATUS_NAME
,      ASSIGNMENT_STATUS_NAME
,      CURRENT_TASK_ID
FROM APPS.JTF_AGENDA_V;

Dependencies

[top of page]

APPS.JTF_AGENDA_V references the following:

SchemaAPPS
PL/SQL PackageJTF_AGENDA_CALCULATIONS - show dependent code
ViewJTF_AGENDA_TA_V
APPS.JTF_AGENDA_V is referenced by following:

SchemaAPPS
Package BodyJTF_AGENDA_CALCULATIONS - show dependent code