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.AHL_VWP_PROJ_PROD_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 2422: FROM pa_proj_element_versions ppev, pa_object_relationships por,

2418: CURSOR get_project_tasks_csr (c_project_id IN NUMBER) IS
2419: SELECT ppe.pm_source_reference, ppe1.pm_source_reference PARENT_TASK_REFERENCE, ppe.proj_element_id TASK_ID
2420: , parent_p_tsks.task_id PARENT_TASK_ID, PPEV.DISPLAY_SEQUENCE
2421: --SELECT ppe.pm_source_reference, ppe1.pm_source_reference PARENT_TASK_REFERENCE, ppe.proj_element_id
2422: FROM pa_proj_element_versions ppev, pa_object_relationships por,
2423: pa_proj_element_versions ppev1, pa_proj_elements ppe,
2424: pa_proj_elements ppe1,
2425: pa_tasks parent_p_tsks
2426: WHERE ppev.element_version_id = por.object_id_to1

Line 2423: pa_proj_element_versions ppev1, pa_proj_elements ppe,

2419: SELECT ppe.pm_source_reference, ppe1.pm_source_reference PARENT_TASK_REFERENCE, ppe.proj_element_id TASK_ID
2420: , parent_p_tsks.task_id PARENT_TASK_ID, PPEV.DISPLAY_SEQUENCE
2421: --SELECT ppe.pm_source_reference, ppe1.pm_source_reference PARENT_TASK_REFERENCE, ppe.proj_element_id
2422: FROM pa_proj_element_versions ppev, pa_object_relationships por,
2423: pa_proj_element_versions ppev1, pa_proj_elements ppe,
2424: pa_proj_elements ppe1,
2425: pa_tasks parent_p_tsks
2426: WHERE ppev.element_version_id = por.object_id_to1
2427: AND por.relationship_type = 'S' -- WORKPLAN STRUCTURE

Line 2445: FROM PA_TASKS CURR, PA_PROJ_ELEMENT_VERSIONS PPEV, PA_TASKS P_CURR

2441: CURSOR get_other_vst_prj_tsks_csr(c_project_id IN NUMBER, c_top_task_id IN NUMBER) IS
2442: SELECT CURR.PM_TASK_REFERENCE, P_CURR.PM_TASK_REFERENCE PARENT_TASK_REFERENCE,
2443: CURR.TASK_ID -- PRAKKUM :: 24-NOV-2010 :: Bug 9370120 :: FP:12.0-12.2 :: Fetch project task id as well
2444: , P_CURR.task_id PARENT_TASK_ID, PPEV.DISPLAY_SEQUENCE
2445: FROM PA_TASKS CURR, PA_PROJ_ELEMENT_VERSIONS PPEV, PA_TASKS P_CURR
2446: WHERE CURR.PROJECT_ID = c_project_id
2447: AND CURR.TOP_TASK_ID <> c_top_task_id
2448: AND PPEV.PROJ_ELEMENT_ID = CURR.TASK_ID
2449: AND PPEV.PROJECT_ID = c_project_id

Line 2459: PA_PROJ_ELEMENT_VERSIONS PPEV

2455: -- Query to retrive only project tasks whihc are not mapped to visits - excluding roll up tasks
2456: CURSOR get_prj_tsks_not_mapd_to_vst(c_project_id IN NUMBER, c_visit_id IN NUMBER) IS
2457: SELECT CURR.TASK_ID TASK_ID, CURR.PARENT_TASK_ID PARENT_TASK_ID, PPEV.DISPLAY_SEQUENCE
2458: FROM PA_TASKS CURR,
2459: PA_PROJ_ELEMENT_VERSIONS PPEV
2460: WHERE CURR.PROJECT_ID = c_project_id
2461: AND CURR.TOP_TASK_ID not IN
2462: (
2463: SELECT DISTINCT TOP_TASK_ID

Line 2464: FROM AHL_VISIT_TASKS_VL VT, PA_PROJ_ELEMENT_VERSIONS PPEV, PA_TASKS PTSKS

2460: WHERE CURR.PROJECT_ID = c_project_id
2461: AND CURR.TOP_TASK_ID not IN
2462: (
2463: SELECT DISTINCT TOP_TASK_ID
2464: FROM AHL_VISIT_TASKS_VL VT, PA_PROJ_ELEMENT_VERSIONS PPEV, PA_TASKS PTSKS
2465: WHERE PPEV.PROJECT_ID = c_project_id
2466: AND VT.VISIT_ID = c_visit_id -- PRAKKUM :: 17-JAN-2013 :: FPBug 16481709 for BaseBug 14828418
2467: AND PPEV.PROJ_ELEMENT_ID = VT.PROJECT_TASK_ID
2468: AND PTSKS.TASK_ID = PPEV.PROJ_ELEMENT_ID

Line 2476: FROM AHL_VISIT_TASKS_VL VT, PA_PROJ_ELEMENT_VERSIONS PPEV, PA_TASKS PTSKS

2472: ORDER BY PPEV.DISPLAY_SEQUENCE;
2473:
2474: CURSOR get_vst_prj_top_task(c_project_id IN AHL_VISITS_B.PROJECT_ID%TYPE, c_visit_id IN AHL_VISITS_B.VISIT_ID%TYPE) IS
2475: SELECT distinct PTSKS.TOP_TASK_ID TOP_TASK_ID
2476: FROM AHL_VISIT_TASKS_VL VT, PA_PROJ_ELEMENT_VERSIONS PPEV, PA_TASKS PTSKS
2477: WHERE PPEV.PROJECT_ID = c_project_id
2478: AND PPEV.PROJ_ELEMENT_ID = VT.PROJECT_TASK_ID
2479: AND PTSKS.TASK_ID = PPEV.PROJ_ELEMENT_ID
2480: AND VT.VISIT_ID = c_visit_id;

Line 2504: FROM AHL_VISIT_TASKS_VL VT, PA_PROJ_ELEMENT_VERSIONS PPEV

2500: -- SELECT * FROM AHL_VISIT_TASKS_VL
2501: -- WHERE VISIT_ID = x_id
2502: -- AND NVL(status_code, 'Y') <> NVL ('DELETED', 'X');
2503: SELECT PPEV.DISPLAY_SEQUENCE, VT.*
2504: FROM AHL_VISIT_TASKS_VL VT, PA_PROJ_ELEMENT_VERSIONS PPEV
2505: WHERE VT.VISIT_ID = x_id
2506: AND NVL(VT.status_code, 'Y') <> NVL ('DELETED', 'X')
2507: AND PPEV.PROJ_ELEMENT_ID (+) = VT.PROJECT_TASK_ID;
2508: c_task_rec c_task%ROWTYPE;

Line 2528: FROM PA_PROJ_ELEMENT_VERSIONS PPEV

2524: AND PARENT.TASK_ID (+) = CURR.PARENT_TASK_ID;
2525:
2526: CURSOR get_task_disp_seq_csr (c_project_task_id IN NUMBER) IS
2527: SELECT PPEV.DISPLAY_SEQUENCE
2528: FROM PA_PROJ_ELEMENT_VERSIONS PPEV
2529: WHERE PPEV.PROJ_ELEMENT_ID = c_project_task_id;
2530:
2531: CURSOR c_pjm_param(x_proj_id IN NUMBER,x_org_id IN NUMBER) IS
2532: SELECT 'x'

Line 2576: FROM ahl_routes_vl ar,ahl_visit_tasks_vl avt, ahl_mr_routes mrr, pa_proj_element_versions ppev

2572: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date,
2573: avt.end_date_time task_end_date, avt.project_Task_id project_task_id, ppev.display_sequence,
2574: avt.task_type_code, avt.cost_parent_id, avt.service_type_code, avt.visit_task_id
2575: , avt.repair_batch_name --PRAKKUM :: 11/06/2012 :: Bug 14068468
2576: FROM ahl_routes_vl ar,ahl_visit_tasks_vl avt, ahl_mr_routes mrr, pa_proj_element_versions ppev
2577: WHERE avt.visit_id = p_visit_id
2578: --VWPE: ER:12424063 :: SKPATHAK :: 07-JUN-2012 :: Tasks should not be in deleted status
2579: AND NVL(avt.status_code,'Y') <> 'DELETED'
2580: AND avt.task_type_code NOT IN ('SUMMARY','UNASSOCIATED','STAGE') ----SKPATHAK :: VWPE: ER:12424063 :: 13-JUN-2012 :: Need not create project task for a stage

Line 2590: FROM ahl_mr_headers_v amh,ahl_visit_tasks_vl avt, pa_proj_element_versions ppev

2586: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date,
2587: avt.end_date_time task_end_date, avt.project_Task_id project_task_id, ppev.display_sequence,
2588: avt.task_type_code, avt.cost_parent_id, avt.service_type_code, avt.visit_task_id
2589: , avt.repair_batch_name --PRAKKUM :: 11/06/2012 :: Bug 14068468
2590: FROM ahl_mr_headers_v amh,ahl_visit_tasks_vl avt, pa_proj_element_versions ppev
2591: WHERE avt.visit_id = p_visit_id
2592: --VWPE: ER:12424063 :: SKPATHAK :: 07-JUN-2012 :: Tasks should not be in deleted status
2593: AND NVL(avt.status_code,'Y') <> 'DELETED'
2594: AND avt.task_type_code = 'SUMMARY'

Line 2604: FROM ahl_visit_tasks_vl avt, pa_proj_element_versions ppev

2600: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date,
2601: avt.end_date_time task_end_date, avt.project_Task_id project_task_id, ppev.display_sequence,
2602: avt.task_type_code, avt.cost_parent_id, avt.service_type_code, avt.visit_task_id
2603: , avt.repair_batch_name --PRAKKUM :: 11/06/2012 :: Bug 14068468
2604: FROM ahl_visit_tasks_vl avt, pa_proj_element_versions ppev
2605: WHERE avt.visit_id = p_visit_id
2606: --VWPE: ER:12424063 :: SKPATHAK :: 07-JUN-2012 :: Tasks should not be in deleted status
2607: AND NVL(avt.status_code,'Y') <> 'DELETED'
2608: AND ((avt.task_type_code = 'SUMMARY' AND avt.summary_task_flag = 'Y')

Line 12679: FROM PA_TASKS CURR, PA_PROJ_ELEMENT_VERSIONS PPEV, PA_TASKS PARENT, AHL_VISIT_TASKS_B VTSK

12675: -- This cursor gets the task details for all the tasks in the given project
12676: CURSOR get_all_prj_tsks_csr(c_project_id IN NUMBER, c_visit_id IN NUMBER) IS
12677: SELECT CURR.TASK_ID, CURR.DESCRIPTION, CURR.PM_TASK_REFERENCE, PARENT.PM_TASK_REFERENCE PARENT_TASK_REFERENCE, VTSK.VISIT_TASK_ID
12678: , CURR.PARENT_TASK_ID PARENT_TASK_ID -- PRAKKUM :: 08-JAN-2013 :: FPBug 16481709 for BaseBug 14828418 : In reference of bug 9047048
12679: FROM PA_TASKS CURR, PA_PROJ_ELEMENT_VERSIONS PPEV, PA_TASKS PARENT, AHL_VISIT_TASKS_B VTSK
12680: WHERE CURR.PROJECT_ID = c_project_id
12681: AND PPEV.PROJ_ELEMENT_ID = CURR.TASK_ID
12682: AND PPEV.PROJECT_ID = c_project_id
12683: AND PARENT.TASK_ID (+) = CURR.PARENT_TASK_ID