[Home] [Help]
7081: , a.actual_travel_duration
7082: , a.actual_travel_duration_uom
7083: FROM (SELECT distinct rr.resource_id, rr.resource_type,pop.plan_option_id,pt.object_capacity_id
7084: FROM csf_r_request_tasks rt,
7085: csf_r_resource_results rr,
7086: csf_r_plan_options pop,
7087: csf_r_plan_option_tasks pt,
7088: jtf_tasks_b t
7089: WHERE rt.request_task_id = rr.request_task_id
7180: , a.actual_travel_duration_uom
7181: , nvl(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
7182: FROM (SELECT distinct rr.resource_id, rr.resource_type,pop.plan_option_id,pt.object_capacity_id
7183: FROM csf_r_request_tasks rt,
7184: csf_r_resource_results rr,
7185: csf_r_plan_options pop,
7186: csf_r_plan_option_tasks pt,
7187: jtf_tasks_b t
7188: WHERE rt.request_task_id = rr.request_task_id
7274: , a.actual_travel_duration
7275: , a.actual_travel_duration_uom
7276: FROM (SELECT distinct rr.resource_id, rr.resource_type,pop.plan_option_id,pt.object_capacity_id
7277: FROM csf_r_request_tasks rt,
7278: csf_r_resource_results rr,
7279: csf_r_plan_options pop,
7280: csf_r_plan_option_tasks pt,
7281: jtf_tasks_b t
7282: WHERE rt.request_task_id = rr.request_task_id
7352: , a.actual_travel_duration_uom
7353: , nvl(jdd.dependent_on_task_id,0) || '-' || plan_option_id task_dep1
7354: FROM (SELECT distinct rr.resource_id, rr.resource_type,POP.plan_option_id,pt.object_capacity_id
7355: FROM csf_r_request_tasks rt,
7356: csf_r_resource_results rr,
7357: csf_r_plan_options pop,
7358: csf_r_plan_option_tasks pt,
7359: jtf_tasks_b t
7360: WHERE rt.request_task_id = rr.request_task_id
7573: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
7574: ||',POP.COST'
7575: ||' FROM '
7576: ||' CSF_R_REQUEST_TASKS RT,'
7577: ||' CSF_R_RESOURCE_RESULTS RR,'
7578: ||' CSF_R_PLAN_OPTIONS POP,'
7579: ||' CSF_R_PLAN_OPTION_TASKS PT,'
7580: ||' JTF_TASKS_B T'
7581: ||' WHERE RT.SCHED_REQUEST_ID =:1'
7592: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
7593: ||',POP.COST'
7594: ||' FROM '
7595: ||' CSF_R_REQUEST_TASKS RT,'
7596: ||' CSF_R_RESOURCE_RESULTS RR,'
7597: ||' CSF_R_PLAN_OPTIONS POP,'
7598: ||' CSF_R_PLAN_OPTION_TASKS PT,'
7599: ||' JTF_TASKS_B T'
7600: ||' WHERE RT.SCHED_REQUEST_ID =:1'
7607: ||' IN '
7608: ||' (SELECT RR.RESOURCE_ID,MIN(POP.COST)'
7609: ||' FROM'
7610: ||' CSF_R_REQUEST_TASKS RT,'
7611: ||' CSF_R_RESOURCE_RESULTS RR,'
7612: ||' CSF_R_PLAN_OPTIONS POP,'
7613: ||' CSF_R_PLAN_OPTION_TASKS PT,'
7614: ||' JTF_TASKS_B T'
7615: ||' WHERE RT.SCHED_REQUEST_ID =:2'
7627: ||' ,RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY '
7628: ||' ,POP.COST '
7629: ||' FROM '
7630: ||' CSF_R_REQUEST_TASKS RT, '
7631: ||' CSF_R_RESOURCE_RESULTS RR, '
7632: ||' CSF_R_PLAN_OPTIONS POP, '
7633: ||' CSF_R_PLAN_OPTION_TASKS PT, '
7634: ||' JTF_TASKS_B T '
7635: ||' WHERE RT.SCHED_REQUEST_ID = :1 '
7642: ||' SELECT PLAN_OPTION_ID FROM '
7643: ||' (SELECT PT.PLAN_OPTION_ID, MIN(trunc(PT.SCHEDULED_START_DATE)) START_TIME,MIN(POP.COST) COST '
7644: ||' FROM '
7645: ||' CSF_R_REQUEST_TASKS RT, '
7646: ||' CSF_R_RESOURCE_RESULTS RR, '
7647: ||' CSF_R_PLAN_OPTIONS POP, '
7648: ||' CSF_R_PLAN_OPTION_TASKS PT, '
7649: ||' JTF_TASKS_B T '
7650: ||' WHERE RT.SCHED_REQUEST_ID = :2 '
7658: ||' (select TRUNC(START_TIME), MIN(COST) from '
7659: ||' (SELECT MIN(trunc(PT.SCHEDULED_START_DATE)) START_TIME,MIN(POP.COST) COST '
7660: ||' FROM '
7661: ||' CSF_R_REQUEST_TASKS RT, '
7662: ||' CSF_R_RESOURCE_RESULTS RR, '
7663: ||' CSF_R_PLAN_OPTIONS POP, '
7664: ||' CSF_R_PLAN_OPTION_TASKS PT, '
7665: ||' JTF_TASKS_B T '
7666: ||' WHERE RT.SCHED_REQUEST_ID = :4 '
7679: ||',RR.RESOURCE_ID||''-''||RR.RESOURCE_TYPE||''-''||POP.PLAN_OPTION_ID RESOURCE_KEY'
7680: ||',POP.COST'
7681: ||' FROM '
7682: ||' CSF_R_REQUEST_TASKS RT,'
7683: ||' CSF_R_RESOURCE_RESULTS RR,'
7684: ||' CSF_R_PLAN_OPTIONS POP,'
7685: ||' CSF_R_PLAN_OPTION_TASKS PT,'
7686: ||' JTF_TASKS_B T'
7687: ||' WHERE RT.SCHED_REQUEST_ID =:1'