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

Line 1438: FROM PA_TASKS TASK, PA_TASKS PARENT

1434: --VWPE: ER:12424063 :: SKPATHAK :: 07-JUN-2012
1435: --Get the parent project task for a given task
1436: CURSOR c_get_parent_project_task (c_project_task_id IN NUMBER) IS
1437: SELECT PARENT.TASK_ID PARENT_TASK_ID, PARENT.PM_TASK_REFERENCE PARENT_TASK_REFERENCE
1438: FROM PA_TASKS TASK, PA_TASKS PARENT
1439: WHERE TASK.TASK_ID = c_project_task_id
1440: AND PARENT.TASK_ID (+) = TASK.PARENT_TASK_ID;
1441:
1442: parent_project_task_rec c_get_parent_project_task%ROWTYPE;

Line 1833: FROM PA_TASKS pt

1829:
1830: CURSOR get_proj_details (x_prjId IN NUMBER)
1831: IS
1832: SELECT pt.task_id,pt.project_id,pt.parent_task_id, pt.task_name
1833: FROM PA_TASKS pt
1834: WHERE
1835: pt.project_id=x_prjId;
1836:
1837: get_proj_details_rec get_proj_details%ROWTYPE;

Line 2425: pa_tasks parent_p_tsks

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
2428: AND por.object_id_from1 = ppev1.element_version_id
2429: AND ppev.project_id = c_project_id

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 2458: FROM PA_TASKS CURR,

2454: -- PRAKKUM :: 04-JAN-2013 :: FPBug 16481709 for BaseBug 14828418 : In reference of bug 9047048 :: START
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: (

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 2513: FROM PA_TASKS

2509:
2510: -- To find tasks information for visit
2511: CURSOR c_task_proj (x_id IN NUMBER) IS
2512: SELECT TASK_ID, TASK_NUMBER
2513: FROM PA_TASKS
2514: WHERE PROJECT_ID = x_id;
2515: c_task_proj_rec c_task_proj%ROWTYPE;
2516:
2517: -- PRAKKUM :: PIE :: 13-OCT-2010

Line 2521: FROM PA_TASKS CURR, PA_TASKS PARENT

2517: -- PRAKKUM :: PIE :: 13-OCT-2010
2518: -- To find project task id, given the task number
2519: CURSOR get_task_id_parent_ref_csr (c_project_id IN NUMBER, c_task_number IN VARCHAR2) IS
2520: SELECT CURR.TASK_ID, PARENT.PM_TASK_REFERENCE PARENT_TASK_REFERENCE
2521: FROM PA_TASKS CURR, PA_TASKS PARENT
2522: WHERE CURR.PROJECT_ID = c_project_id
2523: AND CURR.TASK_NUMBER = c_task_number
2524: AND PARENT.TASK_ID (+) = CURR.PARENT_TASK_ID;
2525:

Line 2643: pa_tasks pt

2639: visit_id = c_visit_id AND
2640: EXISTS (
2641: SELECT 1
2642: FROM ahl_visit_tasks_b avt,
2643: pa_tasks pt
2644: WHERE avt.visit_id = vst.visit_id
2645: AND avt.visit_id = c_visit_id
2646: AND avt.repair_batch_name IS NOT NULL
2647: and avt.project_task_id = pt.task_id

Line 11847: SELECT pm_task_reference from pa_tasks

11843: SELECT visit_task_number, task_type_code from ahl_visit_tasks_b
11844: where visit_task_id = c_visit_task_id;
11845:
11846: CURSOR top_task_ref_csr (c_top_project_task_id IN NUMBER) IS
11847: SELECT pm_task_reference from pa_tasks
11848: where task_id = c_top_project_task_id;
11849:
11850:
11851: -- SATHAPLI::Bug 5758813, 04-Jun-2008

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

Line 12701: PA_TASKS PAT

12697: CURSOR get_task_dates_cur(p_wo_id IN NUMBER) IS
12698: SELECT AVT.PROJECT_TASK_ID, AVT.START_DATE_TIME, AVT.END_DATE_TIME,
12699: PAT.DESCRIPTION -- Pass the old description back again
12700: FROM AHL_VISIT_TASKS_B AVT, AHL_WORKORDERS WO,
12701: PA_TASKS PAT
12702: WHERE WO.VISIT_TASK_ID = AVT.VISIT_TASK_ID AND
12703: WO.WORKORDER_ID = p_wo_id AND
12704: PAT.TASK_ID (+) = AVT.PROJECT_TASK_ID;
12705: get_task_dates_rec get_task_dates_cur%ROWTYPE;

Line 13744: FROM ahl_visit_tasks_b avt, pa_tasks pt

13740: --To find the project task details
13741: CURSOR get_prj_tsk_details_csr (c_task_id IN NUMBER) IS
13742: SELECT avt.project_task_id, avt.task_type_code,
13743: avt.cost_parent_id, pt.project_id, pt.top_task_id
13744: FROM ahl_visit_tasks_b avt, pa_tasks pt
13745: WHERE avt.project_task_id = pt.task_id
13746: AND avt.visit_task_id = c_task_id ;
13747: get_prj_tsk_details_csr_rec get_prj_tsk_details_csr%ROWTYPE;
13748:

Line 13760: FROM pa_tasks

13756:
13757: --To find the project parent roll-up task of a project transaction task
13758: CURSOR get_prj_parent_tsk_csr (c_project_task_id IN NUMBER) IS
13759: SELECT parent_task_id
13760: FROM pa_tasks
13761: WHERE task_id = c_project_task_id;
13762:
13763: BEGIN
13764:

Line 13937: FROM pa_tasks

13933: -- Changed query to get count of visit tasks that have parent (discarding project tasks that not associated to visit task)
13934: --To find the parent task ids of the project tasks
13935: /*CURSOR get_parent_prj_tsk_id_csr (x_project_id IN NUMBER) IS
13936: SELECT parent_task_id
13937: FROM pa_tasks
13938: WHERE project_id = x_project_id ;*/
13939:
13940: CURSOR get_parent_prj_tsk_id_csr (c_project_id IN NUMBER) IS
13941: SELECT count(PTSK.parent_task_id)

Line 13942: FROM pa_tasks PTSK, AHL_VISIT_TASKS_B VTSK

13938: WHERE project_id = x_project_id ;*/
13939:
13940: CURSOR get_parent_prj_tsk_id_csr (c_project_id IN NUMBER) IS
13941: SELECT count(PTSK.parent_task_id)
13942: FROM pa_tasks PTSK, AHL_VISIT_TASKS_B VTSK
13943: WHERE
13944: VTSK.PROJECT_TASK_ID = PTSK.TASK_ID
13945: AND VTSK.VISIT_ID = p_visit_id
13946: AND PTSK.project_id = c_project_id ;

Line 13955: FROM pa_tasks

13951: -- SKPATHAK :: 07-OCT-2011 :: VWPE ER: 12856858
13952: --To find the count of the project tasks
13953: CURSOR get_project_task_count (x_project_id IN NUMBER) IS
13954: SELECT count(*)
13955: FROM pa_tasks
13956: WHERE project_id = x_project_id ;
13957: l_count NUMBER;
13958:
13959: -- SKPATHAK :: Bug 14016007 :: 03-MAY-2012 ::

Line 15477: FROM PA_TASKS pt

15473:
15474: CURSOR c_get_trans_task_id (c_project_id IN NUMBER,c_repair_batch_task_id IN NUMBER, c_visit_id IN NUMBER, c_task_trail_name IN VARCHAR2)
15475: IS
15476: SELECT pt.task_id
15477: FROM PA_TASKS pt
15478: WHERE
15479: pt.task_name LIKE c_task_trail_name /* Filter only project tasks whose name ends with -G_TRANS_TSK_TRAIL_NAME */
15480: AND pt.project_id=c_project_id
15481: AND pt.parent_task_id=c_repair_batch_task_id