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

VIEW: APPS.CSR_TRIP_TASKS_V

Object Details
Object Name: CSR_TRIP_TASKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSR.CSR_TRIP_TASKS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTUAL_START_DATE DATE

The actual start date given by the resource
ACTUAL_END_DATE DATE

The actual end date given by the resource
PLANNED_EFFORT NUMBER

Task duration column
TA_SCHED_TRAVEL_DURATION_UOM VARCHAR2 (4000)
scheduled travel duration unit of measure
PLANNED_EFFORT_UOM VARCHAR2 (4000)
task duration unit of measure
TA_SCHED_TRAVEL_DURATION NUMBER

Travel duration calculated by scheduler
TA_SCHED_TRAVEL_DISTANCE NUMBER

Travel distance (km?) calculated by scheduler
SCHEDULED_START_DATE DATE

Start date/time calculated by scheduler
SCHEDULED_END_DATE DATE

End date/time calculated by scheduler
TA_TASK_ASSIGNMENT_ID NUMBER
Yes Primary key in jtf_task_assignments table
TASK_ID NUMBER
Yes Primary key in jtf_tasks_b
TASK_TYPE_ID NUMBER
Yes Task type. Foreign key in jtf_task_types_b table
PLANNED_START_DATE DATE

Planned start time is the earliest date/time on which the task with id task_id may be scheduled.
PLANNED_END_DATE DATE

Planned end date is the latest time on which this the task with task_id has to start. Note that the scheduled date/time may actually be later than the planned_end_date because the planned_end_date has already passed when the task is offered to scheduler for scheduling.
SOFT_BOUND_FLAG VARCHAR2 (1)
Soft Bound Flag
TASK_STATUS_ID NUMBER
Yes Status id, foreign key in jtf_task_statuses_b
TIMEZONE_ID NUMBER

Task timezone id, based on location (party_site_address) where task has to be performed
TA_OBJECT_VERSION_NUMBER NUMBER
Yes Task assignment object version number. Incremented after every update of the task assignment (ta_task_assignment_id)
CREATION_DATE DATE
Yes Task creation date/time
TA_ASSIGNMENT_STATUS_ID NUMBER
Yes Task assignment status. Foreign key in jtf_task_statuses_b.
TA_RESOURCE_ID NUMBER
Yes Resource that (who?) the task with task_id is assigned to. Foreign key in jtf_rs_resource_extns.
TA_RESOURCE_TYPE_CODE VARCHAR2 (30) Yes Resource type (also called 'category') of the resource with id resource_id. This field refers to jtf_rs_resource_extns.category
TA_SHIFT_CONSTRUCT_ID NUMBER

Shift of resource resource_id. The shift construct is derived from the resource's calendar and refers to a shift on a certain day. Foreign key in table jtf_cal_shift_constructs.
OBJECT_VERSION_NUMBER NUMBER
Yes Task object version number. This number is incremented when the task with id task_id is updated.
TY_SCHEDULE_FLAG VARCHAR2 (1)
Schedule flag of task type with id task_type_id. Indicates whether scheduler may schedule a task of this type.
SCHEDULABLE_FLAG VARCHAR2 (1)
Task status schedulable flag. Indicates whether a task in the status given by task_status_id may be scheduled by scheduler.
TA_SCHEDULABLE_FLAG VARCHAR2 (1)
Taks assignment status schedulable flag. Indicates whether a task assignment with status id ta_assignment_status_id may be scheduled by scheduler.
ASSIGNMENT_COUNT NUMBER

Nr of task assignments belonging to task with id task_id. Task assignments with 'cancelled' flag set will *not* be counted.
LOCUS_SEGMENTID NUMBER

Locus segment id is a value from the sdo_geometry that this task is associated with through the party_site_id (ak jtf_tasks_b.address_id) and the location_id in hz_locations. This field specifies the segment in a network of roades.
LOCUS_SIDE NUMBER

Locus side a value from the sdo_geometry that this task is associated with through the party_site_id (ak jtf_tasks_b.address_id) and the location_id in hz_locations. This field specifies the side of the road the task's address is located on.
LOCUS_SPOT NUMBER

Locus spot is a value from the sdo_geometry that this task is associated with through the party_site_id (ak jtf_tasks_b.address_id) and the location_id in hz_locations.
SHOULD_CALL_LF VARCHAR2 (4000)
'Y', 'N' value indicating whether the address associated with the task with id task_id could be found in the road network. If found, the locus_segmentid, locus_spot and locus_side have valid values. If not found the locus_xx fields have meaningless values.
LOCUS_LAT NUMBER

Latitude value of address.
LOCUS_LON NUMBER

Longitude value of address.
LOCATION_ID NUMBER (15)
Identifies location where task with id task_id has to be performed. Foreign key in hz_locaitons.
BOUND_MODE_CODE VARCHAR2 (30)
Codewhich defines how the bounds must be interpreted
AVAILABILITY_DATE DATE

The date/time after which spares are available. Only for tasks that have already been assigned. For tasks without spares reservations, the AVAILABILITY_DATE is null.
OBJECT_CAPACITY_ID NUMBER
Yes Foreign key to CAC_SR_OBJECT_CAPACITY table. Specifies the trip this task-assignment belongs to.
PARENT_TASK_ID NUMBER

If this task-assignment refers to a child-task, this field specifies the parent of that child-task. For inspection parent-tasks and break/fix tasks, this field is null.
TASK_CONFIRMATION_STATUS VARCHAR2 (1)
Field indicating whether customer confirmation is required or not, and if it is, whether confirmation has been attained or not. 'N' or Null, no confirmation required. 'R' confirmation required but not yet attained. 'C' confirmation required and confirmed.
TASK_CONFIRMATION_COUNTER NUMBER

Number of times the company had to ask the customer for confirmation because of schedule changes.
ACCESS_HOURS_REQUIRED VARCHAR2 (2)
Specifies whether customer requires special access hours for the task at hand. 'N' or Null, no access hours required. 'Y' special access hours required; the access hours are specified in the subsequent fields.
AFTER_HOURS_FLAG VARCHAR2 (2)
Specifies if customer requires access only outside normal working hours. 'N' or Null, no access outside working hours. 'Y' access only outside working hours.
MONDAY_FIRST_START DATE

Start of first access hours window.
MONDAY_FIRST_END DATE

End of first access hours window.
MONDAY_SECOND_START DATE

Start of second access hours window.
MONDAY_SECOND_END DATE

End of second access hours window.
TUESDAY_FIRST_START DATE

Start of first access hours window.
TUESDAY_FIRST_END DATE

End of first access hours window.
TUESDAY_SECOND_START DATE

Start of second access hours window.
TUESDAY_SECOND_END DATE

End of second access hours window.
WEDNESDAY_FIRST_START DATE

Start of first access hours window.
WEDNESDAY_FIRST_END DATE

End of first access hours window.
WEDNESDAY_SECOND_START DATE

Start of second access hours window.
WEDNESDAY_SECOND_END DATE

End of second access hours window.
THURSDAY_FIRST_START DATE

Start of first access hours window.
THURSDAY_FIRST_END DATE

End of first access hours window.
THURSDAY_SECOND_START DATE

Start of second access hours window.
THURSDAY_SECOND_END DATE

End of second access hours window.
FRIDAY_FIRST_START DATE

Start of first access hours window.
FRIDAY_FIRST_END DATE

End of first access hours window.
FRIDAY_SECOND_START DATE

Start of second access hours window.
FRIDAY_SECOND_END DATE

End of second access hours window.
SATURDAY_FIRST_START DATE

Start of first access hours window.
SATURDAY_FIRST_END DATE

End of first access hours window.
SATURDAY_SECOND_START DATE

Start of second access hours window.
SATURDAY_SECOND_END DATE

End of second access hours window.
SUNDAY_FIRST_START DATE

Start of first access hours window.
SUNDAY_FIRST_END DATE

End of first access hours window.
SUNDAY_SECOND_START DATE

Start of second access hours window.
SUNDAY_SECOND_END DATE

End of second access hours window.
TASK_SPLIT_FLAG VARCHAR2 (1)
Identifies whether the Task is a Normal / Parent / Child Task
OC_TRIP_STATUS NUMBER
Yes Status of the Trip
TS_ASSIGNED_FLAG VARCHAR2 (1)
Value of Assigned Flag corresponding to the Task Status
TS_WORKING_FLAG VARCHAR2 (1)
Value of Working Flag corresponding to the Task Status
TS_APPROVED_FLAG VARCHAR2 (1)
Value of Approved Flag corresponding to the Task Status
TS_COMPLETED_FLAG VARCHAR2 (1)
Value of Completed Flag corresponding to the Task Status
TS_CANCELLED_FLAG VARCHAR2 (1)
Value of Cancelled Flag corresponding to the Task Status
TS_CLOSED_FLAG VARCHAR2 (1)
Value of Closed Flag corresponding to the Task Status
TS_REJECTED_FLAG VARCHAR2 (1)
Value of Rejected Flag corresponding to the Task Status
TS_ACCEPTED_FLAG VARCHAR2 (1)
Value of Accepted Flag corresponding to the Task Status
TS_ON_HOLD_FLAG VARCHAR2 (1)
Value of On Hold Flag corresponding to the Task Status
TS_DELETE_ALLOWED_FLAG VARCHAR2 (1)
Value of Delete Allowed Flag corresponding to the Task Status
TASK_NUMBER VARCHAR2 (30) Yes Task Number
HAS_PARENT_DEPENDENCY CHAR (1)
Indicates whether the Task is dependent on other tasks
HAS_CHILD_DEPENDENCY CHAR (1)
Indicates whether there are other tasks dependent on this task
SPARES_REQUIRED_FLAG CHAR (1)
Indicates whether Spares is required for this Task
ACTUAL_EFFORT NUMBER

Actual Effort of the Task
PERSONAL_TASK_FLAG CHAR (1)
Indicates whether the Task is a Personal Task (ie) not associated with a Service Request
ACTUAL_TRAVEL_DURATION NUMBER

ACTUAL_TRAVEL_DISTANCE NUMBER

LOCUS_SRID NUMBER

TASK_PRIORITY NUMBER
Yes
COUNTRY_CODE VARCHAR2 (60)
Represents the country represented by this Location
THIRD_PARTY_ROLE VARCHAR2 (4000)
Query Text

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


SELECT ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      PLANNED_EFFORT
,      TA_SCHED_TRAVEL_DURATION_UOM
,      PLANNED_EFFORT_UOM
,      TA_SCHED_TRAVEL_DURATION
,      TA_SCHED_TRAVEL_DISTANCE
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      TA_TASK_ASSIGNMENT_ID
,      TASK_ID
,      TASK_TYPE_ID
,      PLANNED_START_DATE
,      PLANNED_END_DATE
,      SOFT_BOUND_FLAG
,      TASK_STATUS_ID
,      TIMEZONE_ID
,      TA_OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      TA_ASSIGNMENT_STATUS_ID
,      TA_RESOURCE_ID
,      TA_RESOURCE_TYPE_CODE
,      TA_SHIFT_CONSTRUCT_ID
,      OBJECT_VERSION_NUMBER
,      TY_SCHEDULE_FLAG
,      SCHEDULABLE_FLAG
,      TA_SCHEDULABLE_FLAG
,      ASSIGNMENT_COUNT
,      LOCUS_SEGMENTID
,      LOCUS_SIDE
,      LOCUS_SPOT
,      SHOULD_CALL_LF
,      LOCUS_LAT
,      LOCUS_LON
,      LOCATION_ID
,      BOUND_MODE_CODE
,      AVAILABILITY_DATE
,      OBJECT_CAPACITY_ID
,      PARENT_TASK_ID
,      TASK_CONFIRMATION_STATUS
,      TASK_CONFIRMATION_COUNTER
,      ACCESS_HOURS_REQUIRED
,      AFTER_HOURS_FLAG
,      MONDAY_FIRST_START
,      MONDAY_FIRST_END
,      MONDAY_SECOND_START
,      MONDAY_SECOND_END
,      TUESDAY_FIRST_START
,      TUESDAY_FIRST_END
,      TUESDAY_SECOND_START
,      TUESDAY_SECOND_END
,      WEDNESDAY_FIRST_START
,      WEDNESDAY_FIRST_END
,      WEDNESDAY_SECOND_START
,      WEDNESDAY_SECOND_END
,      THURSDAY_FIRST_START
,      THURSDAY_FIRST_END
,      THURSDAY_SECOND_START
,      THURSDAY_SECOND_END
,      FRIDAY_FIRST_START
,      FRIDAY_FIRST_END
,      FRIDAY_SECOND_START
,      FRIDAY_SECOND_END
,      SATURDAY_FIRST_START
,      SATURDAY_FIRST_END
,      SATURDAY_SECOND_START
,      SATURDAY_SECOND_END
,      SUNDAY_FIRST_START
,      SUNDAY_FIRST_END
,      SUNDAY_SECOND_START
,      SUNDAY_SECOND_END
,      TASK_SPLIT_FLAG
,      OC_TRIP_STATUS
,      TS_ASSIGNED_FLAG
,      TS_WORKING_FLAG
,      TS_APPROVED_FLAG
,      TS_COMPLETED_FLAG
,      TS_CANCELLED_FLAG
,      TS_CLOSED_FLAG
,      TS_REJECTED_FLAG
,      TS_ACCEPTED_FLAG
,      TS_ON_HOLD_FLAG
,      TS_DELETE_ALLOWED_FLAG
,      TASK_NUMBER
,      HAS_PARENT_DEPENDENCY
,      HAS_CHILD_DEPENDENCY
,      SPARES_REQUIRED_FLAG
,      ACTUAL_EFFORT
,      PERSONAL_TASK_FLAG
,      ACTUAL_TRAVEL_DURATION
,      ACTUAL_TRAVEL_DISTANCE
,      LOCUS_SRID
,      TASK_PRIORITY
,      COUNTRY_CODE
,      THIRD_PARTY_ROLE
FROM APPS.CSR_TRIP_TASKS_V;

Dependencies

[top of page]

APPS.CSR_TRIP_TASKS_V references the following:

SchemaAPPS
SynonymCAC_SR_OBJECT_CAPACITY
SynonymCSF_ACCESS_HOURS_B
PL/SQL PackageCSF_LOCUS_PUB - show dependent code
PL/SQL PackageCSF_TASKS_PUB - show dependent code
PL/SQL PackageCSF_UTIL_PVT - show dependent code
SynonymCSP_REQUIREMENT_HEADERS
SynonymCSP_REQUIREMENT_LINES
PL/SQL PackageCSR_SCHEDULER_PVT - show dependent code
SynonymHZ_LOCATIONS
SynonymJTF_TASKS_B
SynonymJTF_TASK_ASSIGNMENTS
SynonymJTF_TASK_DEPENDS
SynonymJTF_TASK_PRIORITIES_B
SynonymJTF_TASK_STATUSES_B
SynonymJTF_TASK_TYPES_B
APPS.CSR_TRIP_TASKS_V is referenced by following:

SchemaAPPS
Package BodyCSF_TASKS_PUB - show dependent code