eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on CSF_R_REQUEST_TASKS

Line 4037: FROM csf_r_request_tasks rt,

4033: , NVL(child_position, 'N') child_task
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

Line 4119: FROM csf_r_request_tasks rt,

4115: , a.actual_travel_duration
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

Line 4202: FROM csf_r_request_tasks rt,

4198: , NVL(child_position, 'N') child_task
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

Line 4282: FROM csf_r_request_tasks rt,

4278: , a.actual_travel_duration
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

Line 4477: ||' CSF_R_REQUEST_TASKS RT,'

4473: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
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'

Line 4496: ||' CSF_R_REQUEST_TASKS RT,'

4492: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
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'

Line 4511: ||' CSF_R_REQUEST_TASKS RT,'

4507: ||' AND (RR.RESOURCE_ID,POP.COST)'
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'

Line 4531: ||' CSF_R_REQUEST_TASKS RT, '

4527: ||' ,CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME '
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 '

Line 4546: ||' CSF_R_REQUEST_TASKS RT, '

4542: ||' AND PT.PLAN_OPTION_ID IN ( '
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 '

Line 4562: ||' CSF_R_REQUEST_TASKS RT, '

4558: ||' ) WHERE (TRUNC(START_TIME),COST) IN '
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 '

Line 4583: ||' CSF_R_REQUEST_TASKS RT,'

4579: ||',CSF_GANTT_DATA_PKG.GET_RESOURCE_TYPE_NAME(RR.RESOURCE_TYPE ) RESOURCE_TYPE_NAME'
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'