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.

APPS.CSF_GANTT_DATA_PKG dependencies on CSF_R_PLAN_OPTION_TASKS

Line 4040: csf_r_plan_option_tasks pt,

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
4043: AND rr.resource_result_id = POP.resource_result_id
4044: AND POP.plan_option_id = pt.plan_option_id

Line 4122: csf_r_plan_option_tasks pt,

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
4125: AND rr.resource_result_id = POP.resource_result_id
4126: AND POP.plan_option_id = pt.plan_option_id

Line 4205: csf_r_plan_option_tasks pt,

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
4208: AND rr.resource_result_id = POP.resource_result_id
4209: AND POP.plan_option_id = pt.plan_option_id

Line 4285: csf_r_plan_option_tasks pt,

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
4288: AND rr.resource_result_id = POP.resource_result_id
4289: AND POP.plan_option_id = pt.plan_option_id

Line 4480: ||' CSF_R_PLAN_OPTION_TASKS PT,'

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'
4483: ||' AND (NVL(T.TASK_TYPE_ID,0) NOT IN (20,21))'
4484: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'

Line 4499: ||' CSF_R_PLAN_OPTION_TASKS PT,'

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'
4502: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'
4503: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID'

Line 4514: ||' CSF_R_PLAN_OPTION_TASKS PT,'

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'
4517: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'
4518: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID'

Line 4534: ||' CSF_R_PLAN_OPTION_TASKS PT, '

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 '
4537: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID '
4538: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID '

Line 4549: ||' CSF_R_PLAN_OPTION_TASKS PT, '

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 '
4552: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID '
4553: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID '

Line 4565: ||' CSF_R_PLAN_OPTION_TASKS PT, '

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 '
4568: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID '
4569: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID '

Line 4586: ||' CSF_R_PLAN_OPTION_TASKS PT,'

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'
4589: ||' AND RT.REQUEST_TASK_ID = RR.REQUEST_TASK_ID'
4590: ||' AND RR.RESOURCE_RESULT_ID = POP.RESOURCE_RESULT_ID'