VIEW: APPS.JTF_AGENDA_V

Source

View Text - Preformatted

SELECT v.row_id , v.task_assignment_id , v.created_by , v.creation_date , v.last_updated_by , v.last_update_date , v.last_update_login , v.task_id , v.resource_type_code , v.resource_id , v.actual_effort , v.actual_effort_uom , v.schedule_flag , v.alarm_type_code , v.alarm_contact , v.sched_travel_distance , v.sched_travel_duration , v.sched_travel_duration_uom , v.actual_travel_distance , v.actual_travel_duration , v.actual_travel_duration_uom , v.actual_start_date , v.actual_end_date , v.palm_flag , v.wince_flag , v.laptop_flag , v.device1_flag , v.device2_flag , v.device3_flag , v.attribute1 , v.attribute2 , v.attribute3 , v.attribute4 , v.attribute5 , v.attribute6 , v.attribute7 , v.attribute8 , v.attribute9 , v.attribute10 , v.attribute11 , v.attribute12 , v.attribute13 , v.attribute14 , v.attribute15 , v.attribute_category , v.object_version_number , v.resource_territory_id , v.assignment_status_id , v.shift_construct_id , v.task_number , v.task_type_id , v.task_status_id , v.task_priority_id , v.owner_type_code , v.owner_id , v.assigned_by_id , v.cust_account_id , v.customer_id , v.address_id , v.planned_start_date , v.planned_end_date , v.scheduled_start_date , v.scheduled_end_date , v.timezone_id , v.source_object_type_code , v.source_object_id , v.source_object_name , v.duration , v.duration_uom , v.planned_effort , v.planned_effort_uom , v.percentage_complete , v.reason_code , v.private_flag , v.publish_flag , v.restrict_closure_flag , v.multi_booked_flag , v.milestone_flag , v.holiday_flag , v.billable_flag , v.bound_mode_code , v.soft_bound_flag , v.workflow_process_id , jtf_agenda_calculations.set_escalation_flag(v.task_id) escalation_flag , v.escalation_level , v.notification_flag , v.notification_period , v.notification_period_uom , v.parent_task_id , v.alarm_start , v.alarm_start_uom , v.alarm_on , v.alarm_count , v.alarm_fired_count , v.alarm_interval , v.alarm_interval_uom , v.recurrence_rule_id , v.costs , v.currency_code , v.org_id , v.shift_start , v.shift_end , nvl(v.actual_start_date, v.scheduled_start_date + jtf_agenda_calculations.predict_time_difference(v.task_assignment_id)) predicted_start_date , nvl(v.actual_end_date, v.scheduled_end_date + jtf_agenda_calculations.predict_time_difference(v.task_assignment_id)) predicted_end_date , substr(jtf_agenda_calculations.set_sequence_flag(v.task_assignment_id), 1, 1) out_of_sequence_flag , jtf_agenda_calculations.get_assignment_status(v.resource_id, v.resource_type_code) current_status_id , substr(jtf_agenda_calculations.get_status_name(jtf_agenda_calculations.get_assignment_status(v.resource_id, v.resource_type_code)), 1, 30) current_status_name , substr(jtf_agenda_calculations.get_status_name(v.assignment_status_id), 1, 30) assignment_status_name , jtf_agenda_calculations.get_current_task(v.resource_id, v.resource_type_code) current_task_id from jtf_agenda_ta_v v

View Text - HTML Formatted

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