[Home] [Help]
4034: , a.actual_travel_duration
4035: , a.actual_travel_duration_uom
4036: FROM (SELECT distinct rr.resource_id, rr.resource_type,pop.plan_option_id,pt.object_capacity_id
4037: FROM csf_r_request_tasks rt,
4038: csf_r_resource_results rr,
4039: csf_r_plan_options pop,
4040: csf_r_plan_option_tasks pt,
4041: jtf_tasks_b t
4042: WHERE rt.request_task_id = rr.request_task_id
4116: , a.actual_travel_duration_uom
4117: , nvl(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
4118: FROM (SELECT distinct rr.resource_id, rr.resource_type,pop.plan_option_id,pt.object_capacity_id
4119: FROM csf_r_request_tasks rt,
4120: csf_r_resource_results rr,
4121: csf_r_plan_options pop,
4122: csf_r_plan_option_tasks pt,
4123: jtf_tasks_b t
4124: WHERE rt.request_task_id = rr.request_task_id
4199: , a.actual_travel_duration
4200: , a.actual_travel_duration_uom
4201: FROM (SELECT distinct rr.resource_id, rr.resource_type,pop.plan_option_id,pt.object_capacity_id
4202: FROM csf_r_request_tasks rt,
4203: csf_r_resource_results rr,
4204: csf_r_plan_options pop,
4205: csf_r_plan_option_tasks pt,
4206: jtf_tasks_b t
4207: WHERE rt.request_task_id = rr.request_task_id
4279: , a.actual_travel_duration_uom
4280: , nvl(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
4281: FROM (SELECT distinct rr.resource_id, rr.resource_type,POP.plan_option_id,pt.object_capacity_id
4282: FROM csf_r_request_tasks rt,
4283: csf_r_resource_results rr,
4284: csf_r_plan_options pop,
4285: csf_r_plan_option_tasks pt,
4286: jtf_tasks_b t
4287: WHERE rt.request_task_id = rr.request_task_id
4474: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
4475: ||',POP.COST'
4476: ||' FROM '
4477: ||' CSF_R_REQUEST_TASKS RT,'
4478: ||' CSF_R_RESOURCE_RESULTS RR,'
4479: ||' CSF_R_PLAN_OPTIONS POP,'
4480: ||' CSF_R_PLAN_OPTION_TASKS PT,'
4481: ||' JTF_TASKS_B T'
4482: ||' WHERE RT.SCHED_REQUEST_ID =:1'
4493: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
4494: ||',POP.COST'
4495: ||' FROM '
4496: ||' CSF_R_REQUEST_TASKS RT,'
4497: ||' CSF_R_RESOURCE_RESULTS RR,'
4498: ||' CSF_R_PLAN_OPTIONS POP,'
4499: ||' CSF_R_PLAN_OPTION_TASKS PT,'
4500: ||' JTF_TASKS_B T'
4501: ||' WHERE RT.SCHED_REQUEST_ID =:1'
4508: ||' IN '
4509: ||' (SELECT RR.RESOURCE_ID,MIN(POP.COST)'
4510: ||' FROM'
4511: ||' CSF_R_REQUEST_TASKS RT,'
4512: ||' CSF_R_RESOURCE_RESULTS RR,'
4513: ||' CSF_R_PLAN_OPTIONS POP,'
4514: ||' CSF_R_PLAN_OPTION_TASKS PT,'
4515: ||' JTF_TASKS_B T'
4516: ||' WHERE RT.SCHED_REQUEST_ID =:2'
4528: ||' ,RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY '
4529: ||' ,POP.COST '
4530: ||' FROM '
4531: ||' CSF_R_REQUEST_TASKS RT, '
4532: ||' CSF_R_RESOURCE_RESULTS RR, '
4533: ||' CSF_R_PLAN_OPTIONS POP, '
4534: ||' CSF_R_PLAN_OPTION_TASKS PT, '
4535: ||' JTF_TASKS_B T '
4536: ||' WHERE RT.SCHED_REQUEST_ID = :1 '
4543: ||' SELECT PLAN_OPTION_ID FROM '
4544: ||' (SELECT PT.PLAN_OPTION_ID, MIN(trunc(PT.SCHEDULED_START_DATE)) START_TIME,MIN(POP.COST) COST '
4545: ||' FROM '
4546: ||' CSF_R_REQUEST_TASKS RT, '
4547: ||' CSF_R_RESOURCE_RESULTS RR, '
4548: ||' CSF_R_PLAN_OPTIONS POP, '
4549: ||' CSF_R_PLAN_OPTION_TASKS PT, '
4550: ||' JTF_TASKS_B T '
4551: ||' WHERE RT.SCHED_REQUEST_ID = :2 '
4559: ||' (select TRUNC(START_TIME), MIN(COST) from '
4560: ||' (SELECT MIN(trunc(PT.SCHEDULED_START_DATE)) START_TIME,MIN(POP.COST) COST '
4561: ||' FROM '
4562: ||' CSF_R_REQUEST_TASKS RT, '
4563: ||' CSF_R_RESOURCE_RESULTS RR, '
4564: ||' CSF_R_PLAN_OPTIONS POP, '
4565: ||' CSF_R_PLAN_OPTION_TASKS PT, '
4566: ||' JTF_TASKS_B T '
4567: ||' WHERE RT.SCHED_REQUEST_ID = :4 '
4580: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
4581: ||',POP.COST'
4582: ||' FROM '
4583: ||' CSF_R_REQUEST_TASKS RT,'
4584: ||' CSF_R_RESOURCE_RESULTS RR,'
4585: ||' CSF_R_PLAN_OPTIONS POP,'
4586: ||' CSF_R_PLAN_OPTION_TASKS PT,'
4587: ||' JTF_TASKS_B T'
4588: ||' WHERE RT.SCHED_REQUEST_ID =:1'