[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT task_id ,
task_name ,
task_type_id ,
description ,
task_status_id ,
task_priority_id ,
owner_type_code ,
owner_id ,
owner_territory_id ,
assigned_by_id ,
customer_id ,
cust_account_id ,
address_id ,
planned_start_date ,
planned_end_date ,
scheduled_start_date ,
scheduled_end_date ,
actual_start_date ,
actual_end_date ,
timezone_id ,
source_object_type_code,
source_object_id ,
source_object_name ,
duration ,
duration_uom ,
planned_effort ,
planned_effort_uom ,
actual_effort ,
actual_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 ,
notification_flag ,
notification_period ,
notification_period_uom,
parent_task_id ,
alarm_start ,
alarm_start_uom ,
alarm_on ,
alarm_count ,
alarm_interval ,
alarm_interval_uom ,
palm_flag ,
wince_flag ,
laptop_flag ,
device1_flag ,
device2_flag ,
device3_flag ,
costs ,
currency_code ,
escalation_level ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 ,
attribute_category
FROM jtf_tasks_vl
WHERE task_id = p_task_id
AND deleted_flag ='N';
SELECT task_id
FROM jtf_task_references_b
WHERE object_id = p_object_id
AND object_type_code = p_object_type_code;
SELECT task_id ,
task_name ,
task_type_id ,
description ,
task_status_id ,
task_priority_id ,
owner_type_code ,
owner_id ,
owner_territory_id ,
assigned_by_id ,
customer_id ,
cust_account_id ,
address_id ,
planned_start_date ,
planned_end_date ,
scheduled_start_date ,
scheduled_end_date ,
actual_start_date ,
actual_end_date ,
timezone_id ,
source_object_type_code,
source_object_id ,
source_object_name ,
duration ,
duration_uom ,
planned_effort ,
planned_effort_uom ,
actual_effort ,
actual_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 ,
notification_flag ,
notification_period ,
notification_period_uom,
parent_task_id ,
alarm_start ,
alarm_start_uom ,
alarm_on ,
alarm_count ,
alarm_interval ,
alarm_interval_uom ,
palm_flag ,
wince_flag ,
laptop_flag ,
device1_flag ,
device2_flag ,
device3_flag ,
costs ,
currency_code ,
escalation_level ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 ,
attribute_category
FROM jtf_tasks_vl tk
WHERE tk.source_object_id = p_object_id
AND tk.source_object_type_code = p_object_type_code
AND tk.deleted_flag ='N'
AND (EXISTS (SELECT o.object_id
FROM jtf_object_mappings o
WHERE o.object_id = TO_CHAR(tk.task_type_id)
AND o.source_object_code = 'ASO_QUOTE')
OR NOT EXISTS ( SELECT om.object_id
FROM JTF_OBJECT_MAPPINGS om
WHERE om.object_id = TO_CHAR(tk.task_type_id)));