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 7087: csf_r_plan_option_tasks pt,

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

Line 7186: csf_r_plan_option_tasks pt,

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

Line 7280: csf_r_plan_option_tasks pt,

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

Line 7358: csf_r_plan_option_tasks pt,

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

Line 7579: ||' CSF_R_PLAN_OPTION_TASKS PT,'

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

Line 7598: ||' CSF_R_PLAN_OPTION_TASKS PT,'

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

Line 7613: ||' CSF_R_PLAN_OPTION_TASKS PT,'

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

Line 7633: ||' CSF_R_PLAN_OPTION_TASKS PT, '

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

Line 7648: ||' CSF_R_PLAN_OPTION_TASKS PT, '

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

Line 7664: ||' CSF_R_PLAN_OPTION_TASKS PT, '

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

Line 7685: ||' CSF_R_PLAN_OPTION_TASKS PT,'

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