78: and jtt_vl.task_type_id in (
79: select
80: task_type_id
81: from
82: JTF_TASK_TYPES_B
83: where
84: rule = 'DISPATCH'
85: ) -- only dispatch tasks
86: and nvl(jtt_vl.schedule_flag, 'N') = 'Y' -- schedulable tasks
115: and jtt_vl.task_type_id in (
116: select
117: task_type_id
118: from
119: JTF_TASK_TYPES_B
120: where
121: rule = 'DISPATCH'
122: ) -- only dispatch tasks
123: and jtt_vl.schedule_flag = 'Y' -- schedulable tasks
168: and jtt_vl.task_type_id in (
169: select
170: task_type_id
171: from
172: JTF_TASK_TYPES_B
173: where
174: rule = 'DISPATCH'
175: ) -- only dispatch tasks
176: and jtt_vl.schedule_flag = 'Y' -- schedulable tasks
935: and jtt_vl.task_type_id in (
936: select
937: task_type_id
938: from
939: JTF_TASK_TYPES_B
940: where
941: rule = 'DISPATCH'
942: ) -- only dispatch tasks
943: and nvl(jtt_vl.schedule_flag, 'N') = 'Y' -- schedulable tasks