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_REQUEST_TASKS

Line 7084: FROM csf_r_request_tasks rt,

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

Line 7183: FROM csf_r_request_tasks rt,

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

Line 7277: FROM csf_r_request_tasks rt,

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

Line 7355: FROM csf_r_request_tasks rt,

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

Line 7576: ||' CSF_R_REQUEST_TASKS RT,'

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

Line 7595: ||' CSF_R_REQUEST_TASKS RT,'

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

Line 7610: ||' CSF_R_REQUEST_TASKS RT,'

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

Line 7630: ||' CSF_R_REQUEST_TASKS RT, '

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

Line 7645: ||' CSF_R_REQUEST_TASKS RT, '

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

Line 7661: ||' CSF_R_REQUEST_TASKS RT, '

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

Line 7682: ||' CSF_R_REQUEST_TASKS RT,'

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