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

VIEW: APPS.CSR_PLAN_TASKS_V

Object Details
Object Name: CSR_PLAN_TASKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSR.CSR_PLAN_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_END_DATE DATE

The actual end date given by the resource
ACTUAL_START_DATE DATE

The actual start date given by the resource
PLANNED_EFFORT NUMBER

Task duration column
PLANNED_EFFORT_UOM VARCHAR2 (4000)
task duration unit of measure column
SCHEDULED_END_DATE DATE

Scheduled end date column
SCHEDULED_START_DATE DATE

Scheduled start date column
TASK_ID NUMBER
Yes Primary key of Task
TASK_TYPE_ID NUMBER
Yes Task type ID column
PLANNED_END_DATE DATE

Bound before indication
PLANNED_START_DATE DATE

Bound after indication
BOUND_MODE_CODE VARCHAR2 (30)
Codewhich defines how the bounds must be interpreted
SOFT_BOUND_FLAG VARCHAR2 (1)
Indication of soft or hard contraints for bound dates
CREATION_DATE DATE
Yes Standard who column
OBJECT_VERSION_NUMBER NUMBER
Yes Number to indicate the last changed version
SCHEDULABLE_FLAG VARCHAR2 (1)
Indication whether task can be handled by Oracle Scheduler
TASK_STATUS_ID NUMBER
Yes Task Status ID Column
LOCUS_SEGMENTID NUMBER

NavTech TDS Segment ID Column
LOCUS_SIDE NUMBER

NavTech TDS Side Column
LOCUS_SPOT NUMBER

NavTech TDS Spot Column
SHOULD_CALL_LF VARCHAR2 (4000)
Indication whether Location Finder is used or not
LOCATION_ID NUMBER (15)
NavTech TDS Location ID Column
TIMEZONE_ID NUMBER

Foreign key to define timezone
TA_TASK_ASSIGNMENT_ID NUMBER

Foreign key to task assignment
TA_SCHED_TRAVEL_DISTANCE NUMBER

The scheduled travel distance
TA_SCHED_TRAVEL_DURATION NUMBER

The scheduled travel duration
TA_SCHED_TRAVEL_DURATION_UOM VARCHAR2 (4000)
The scheduled travel duration unit of measure
TA_OBJECT_VERSION_NUMBER NUMBER

The object version number of the task assignment
TA_SCHEDULABLE_FLAG VARCHAR2 (1)
Flag that indicates whether the task assignment can be handled by Oracle Scheduler
TA_RESOURCE_ID NUMBER

Foreign key to the assigned resource
TA_RESOURCE_TYPE_CODE VARCHAR2 (30)
Foreign key to the assigned resource
TA_ASSIGNMENT_STATUS_ID NUMBER

Status of the assignment ID column
TY_SCHEDULE_FLAG VARCHAR2 (1)
Indication whether the task type can be handled by Oracle Scheduler
LOCUS_LAT NUMBER

Location latitude. Long/Lat coordinates are used when the distance between two locations is calculated geometrically rather than using route information.
LOCUS_LON NUMBER

Location longitude. Long/Lat coordinates are used when the distance between two locations is calculated geometrically rather than using route information.
AVAILABILITY_DATE DATE

The date/time after which spares are available. Only for tasks that have already been assigned. For unassigned tasks the AVAILABILITY_DATE is null.
OBJECT_CAPACITY_ID NUMBER

Foreign key to CSF_TRIPS 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 for given day.
MONDAY_FIRST_END DATE

End of first access hours window for given day.
MONDAY_SECOND_START DATE

Start of second access hours window for given day.
MONDAY_SECOND_END DATE

End of second access hours window for given day.
TUESDAY_FIRST_START DATE

Start of first access hours window for given day.
TUESDAY_FIRST_END DATE

End of first access hours window for given day.
TUESDAY_SECOND_START DATE

Start of second access hours window for given day.
TUESDAY_SECOND_END DATE

End of second access hours window for given day.
WEDNESDAY_FIRST_START DATE

Start of first access hours window for given day.
WEDNESDAY_FIRST_END DATE

End of first access hours window for given day.
WEDNESDAY_SECOND_START DATE

Start of second access hours window for given day.
WEDNESDAY_SECOND_END DATE

End of second access hours window for given day.
THURSDAY_FIRST_START DATE

Start of first access hours window for given day.
THURSDAY_FIRST_END DATE

End of first access hours window for given day.
THURSDAY_SECOND_START DATE

Start of second access hours window for given day.
THURSDAY_SECOND_END DATE

End of second access hours window for given day.
FRIDAY_FIRST_START DATE

Start of first access hours window for given day.
FRIDAY_FIRST_END DATE

End of first access hours window for given day.
FRIDAY_SECOND_START DATE

Start of second access hours window for given day.
FRIDAY_SECOND_END DATE

End of second access hours window for given day.
SATURDAY_FIRST_START DATE

Start of first access hours window for given day.
SATURDAY_FIRST_END DATE

End of first access hours window for given day.
SATURDAY_SECOND_START DATE

Start of second access hours window for given day.
SATURDAY_SECOND_END DATE

End of second access hours window for given day.
SUNDAY_FIRST_START DATE

Start of first access hours window for given day.
SUNDAY_FIRST_END DATE

End of first access hours window for given day.
SUNDAY_SECOND_START DATE

Start of second access hours window for given day.
SUNDAY_SECOND_END DATE

End of second access hours window for given day.
TASK_SPLIT_FLAG VARCHAR2 (1)
Identifies whether the Task is a Normal / Parent / Child Task
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
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_END_DATE
,      ACTUAL_START_DATE
,      PLANNED_EFFORT
,      PLANNED_EFFORT_UOM
,      SCHEDULED_END_DATE
,      SCHEDULED_START_DATE
,      TASK_ID
,      TASK_TYPE_ID
,      PLANNED_END_DATE
,      PLANNED_START_DATE
,      BOUND_MODE_CODE
,      SOFT_BOUND_FLAG
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      SCHEDULABLE_FLAG
,      TASK_STATUS_ID
,      LOCUS_SEGMENTID
,      LOCUS_SIDE
,      LOCUS_SPOT
,      SHOULD_CALL_LF
,      LOCATION_ID
,      TIMEZONE_ID
,      TA_TASK_ASSIGNMENT_ID
,      TA_SCHED_TRAVEL_DISTANCE
,      TA_SCHED_TRAVEL_DURATION
,      TA_SCHED_TRAVEL_DURATION_UOM
,      TA_OBJECT_VERSION_NUMBER
,      TA_SCHEDULABLE_FLAG
,      TA_RESOURCE_ID
,      TA_RESOURCE_TYPE_CODE
,      TA_ASSIGNMENT_STATUS_ID
,      TY_SCHEDULE_FLAG
,      LOCUS_LAT
,      LOCUS_LON
,      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
,      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
,      LOCUS_SRID
,      TASK_PRIORITY
,      COUNTRY_CODE
,      THIRD_PARTY_ROLE
FROM APPS.CSR_PLAN_TASKS_V;

Dependencies

[top of page]

APPS.CSR_PLAN_TASKS_V references the following:

SchemaAPPS
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_PLAN_TASKS_V is not referenced by any database object