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_TASKS_PVT dependencies on AHL_VISIT_TASKS_VL

Line 518: AHL_VISIT_TASKS_VL ORIGTSK,

514: AMRH.DESCRIPTION MR_DESCRIPTION
515: FROM AHL_VISITS_B AVTS,
516: AHL_VISIT_TASKS_B ATSK,
517: AHL_VISIT_TASKS_TL ATSKL,
518: AHL_VISIT_TASKS_VL ORIGTSK,
519: AHL_MR_ROUTES AMRR,
520: AHL_MR_HEADERS_VL AMRH,
521: AHL_UNIT_EFFECTIVITIES_B AUEF,
522: CSI_ITEM_INSTANCES CSIS,

Line 617: AHL_VISIT_TASKS_VL ORIGTSK,

613: AMRH.DESCRIPTION MR_DESCRIPTION
614: FROM AHL_VISITS_B AVTS,
615: AHL_VISIT_TASKS_B ATSK,
616: AHL_VISIT_TASKS_TL ATSKL,
617: AHL_VISIT_TASKS_VL ORIGTSK,
618: AHL_MR_HEADERS_VL AMRH,
619: AHL_UNIT_EFFECTIVITIES_B AUEF,
620: CSI_ITEM_INSTANCES CSIS,
621: CS_INCIDENTS_ALL_B SR,

Line 705: AHL_VISIT_TASKS_VL ATSK,

701: to_number(null) MR_ID,
702: ATSK.UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID,
703: to_char(NULL) MR_DESCRIPTION
704: FROM AHL_VISITS_VL AVTS,
705: AHL_VISIT_TASKS_VL ATSK,
706: AHL_VISIT_TASKS_VL ORIGTSK,
707: CSI_ITEM_INSTANCES CSIS,
708: CS_INCIDENTS_ALL_B SR,
709: AHL_VWP_STAGES_VL ASTG,

Line 706: AHL_VISIT_TASKS_VL ORIGTSK,

702: ATSK.UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID,
703: to_char(NULL) MR_DESCRIPTION
704: FROM AHL_VISITS_VL AVTS,
705: AHL_VISIT_TASKS_VL ATSK,
706: AHL_VISIT_TASKS_VL ORIGTSK,
707: CSI_ITEM_INSTANCES CSIS,
708: CS_INCIDENTS_ALL_B SR,
709: AHL_VWP_STAGES_VL ASTG,
710: BOM_DEPARTMENTS BDPT,

Line 740: FROM AHL_VISIT_TASKS_VL T1, AHL_VISITS_VL T2

736:
737: -- To find all task related information which is not in visit/template search views
738: CURSOR c_task_data(p_task_id IN NUMBER) IS
739: SELECT T1.*, T2.TEMPLATE_FLAG, T2.ORGANIZATION_ID
740: FROM AHL_VISIT_TASKS_VL T1, AHL_VISITS_VL T2
741: WHERE T1.visit_task_id = p_task_id
742: AND T1.VISIT_ID = T2.VISIT_ID;
743: c_task_data_rec c_task_data%ROWTYPE;
744:

Line 2737: SELECT * FROM Ahl_Visit_Tasks_VL

2733: l_visit_end_date DATE;
2734:
2735: -- To find task related information
2736: CURSOR c_Task (x_id IN NUMBER) IS
2737: SELECT * FROM Ahl_Visit_Tasks_VL
2738: WHERE VISIT_TASK_ID = x_id;
2739: c_Task_rec c_Task%ROWTYPE;
2740:
2741: BEGIN

Line 3031: from ahl_visit_tasks_vl

3027: ATTRIBUTE14 ,
3028: ATTRIBUTE15 ,
3029: QUANTITY , --Added by rnahata for Issue 105
3030: STAGE_ID
3031: from ahl_visit_tasks_vl
3032: where visit_task_id = p_visit_task_id;
3033:
3034: l_old_Task_rec c_visit_task_det%rowtype;
3035:

Line 3052: FROM Ahl_Visit_Tasks_VL

3048:
3049: -- To find all tasks under this current visit related information
3050: CURSOR c_all_Task (x_id IN NUMBER) IS
3051: SELECT *
3052: FROM Ahl_Visit_Tasks_VL
3053: WHERE VISIT_TASK_ID = x_id;
3054: l_all_Task_rec c_all_Task%ROWTYPE;
3055:
3056: l_workrec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;

Line 3556: from ahl_visit_tasks_vl

3552: ATTRIBUTE14 ,
3553: ATTRIBUTE15 ,
3554: QUANTITY , --Added by rnahata for Issue 105
3555: STAGE_ID
3556: from ahl_visit_tasks_vl
3557: where visit_task_id = p_visit_task_id;
3558:
3559: l_old_Task_rec c_visit_task_det%rowtype;
3560:

Line 3837: SELECT * FROM Ahl_Visit_Tasks_VL

3833: l_planned_order_flag VARCHAR2(1);
3834:
3835: -- To find task related information
3836: CURSOR c_Task (x_id IN NUMBER) IS
3837: SELECT * FROM Ahl_Visit_Tasks_VL
3838: WHERE VISIT_TASK_ID = x_id;
3839: c_Task_rec c_Task%ROWTYPE;
3840: c_upd_Task_rec c_Task%ROWTYPE;
3841:

Line 4418: SELECT * FROM Ahl_Visit_Tasks_VL

4414: l_department_id NUMBER;
4415:
4416: -- To find task related information
4417: CURSOR c_Task (x_id IN NUMBER) IS
4418: SELECT * FROM Ahl_Visit_Tasks_VL
4419: WHERE VISIT_TASK_ID = x_id;
4420: c_Task_rec c_Task%ROWTYPE;
4421:
4422: -- To find visit related information

Line 4908: SELECT * FROM Ahl_Visit_Tasks_VL

4904: l_msg_count NUMBER;
4905:
4906: -- To find task related information
4907: CURSOR c_Task (x_id IN NUMBER) IS
4908: SELECT * FROM Ahl_Visit_Tasks_VL
4909: WHERE VISIT_TASK_ID = x_id;
4910: c_Task_rec c_Task%ROWTYPE;
4911:
4912: -- To find visit related information

Line 5380: SELECT * FROM Ahl_Visit_Tasks_VL

5376: l_return_status VARCHAR2(1);
5377:
5378: -- To find all tasks related information
5379: CURSOR c_Task (x_id IN NUMBER) IS
5380: SELECT * FROM Ahl_Visit_Tasks_VL
5381: WHERE Visit_Task_ID = x_id;
5382: c_task_rec c_Task%ROWTYPE;
5383:
5384: -- To find visit related information

Line 5395: FROM Ahl_Visit_Tasks_VL

5391: -- To find any task which have primary visit task id as deleted task id
5392: --CURSOR c_primary (x_visit_id IN NUMBER, x_task_id IN NUMBER) IS
5393: CURSOR c_primary (x_task_id IN NUMBER) IS
5394: SELECT Visit_Task_Id, Object_Version_Number,visit_id
5395: FROM Ahl_Visit_Tasks_VL
5396: WHERE --VISIT_ID = x_visit_id AND
5397: PRIMARY_VISIT_TASK_ID = x_task_id
5398: AND status_code <> 'DELETED';
5399: c_primary_rec c_primary%ROWTYPE;

Line 5779: FROM Ahl_Visit_Tasks_VL

5775:
5776: -- To find all tasks related information
5777: CURSOR c_Task (x_id IN NUMBER) IS
5778: SELECT *
5779: FROM Ahl_Visit_Tasks_VL
5780: WHERE Visit_Task_ID = x_id;
5781: c_task_rec c_Task%ROWTYPE;
5782:
5783: -- To find visit related information

Line 5794: FROM Ahl_Visit_Tasks_VL

5790: -- To find any task which have primary visit task id as deleted task id
5791: --CURSOR c_primary (x_visit_id IN NUMBER, x_task_id IN NUMBER) IS
5792: CURSOR c_primary (x_task_id IN NUMBER) IS
5793: SELECT Visit_Task_Id, Object_Version_Number
5794: FROM Ahl_Visit_Tasks_VL
5795: WHERE --VISIT_ID = x_visit_id AND
5796: PRIMARY_VISIT_TASK_ID = x_task_id
5797: AND STATUS_CODE <> 'DELETED';
5798: c_primary_rec c_primary%ROWTYPE;

Line 6224: FROM Ahl_Visit_Tasks_VL

6220:
6221: -- To find all tasks related information
6222: CURSOR c_Task (x_id IN NUMBER) IS
6223: SELECT *
6224: FROM Ahl_Visit_Tasks_VL
6225: WHERE Visit_Task_ID = x_id;
6226: c_task_rec c_Task%ROWTYPE;
6227: l_task_rec c_Task%ROWTYPE;
6228: -- To find visit related information

Line 6239: FROM Ahl_Visit_Tasks_VL

6235: -- To find any task which have primary visit task id as deleted task id
6236: --CURSOR c_primary (x_visit_id IN NUMBER, x_task_id IN NUMBER) IS
6237: CURSOR c_primary (x_task_id IN NUMBER) IS
6238: SELECT Visit_Task_Id, Object_Version_Number
6239: FROM Ahl_Visit_Tasks_VL
6240: WHERE --VISIT_ID = x_visit_id AND
6241: PRIMARY_VISIT_TASK_ID = x_task_id
6242: AND STATUS_CODE <> 'DELETED';
6243: c_primary_rec c_primary%ROWTYPE;

Line 7282: FROM Ahl_Visit_Tasks_vl

7278: )
7279: IS
7280: CURSOR c_Visit_Task IS
7281: SELECT *
7282: FROM Ahl_Visit_Tasks_vl
7283: WHERE Visit_Task_ID = p_task_rec.Visit_Task_ID;
7284: --
7285: -- This is the only exception for using %ROWTYPE.
7286: -- We are selecting from the VL view, which may

Line 7457: 'Ahl_Visit_Tasks_vl',

7453: END IF;
7454:
7455: -- FOR CREATION
7456: IF Ahl_Utility_Pvt.check_uniqueness(
7457: 'Ahl_Visit_Tasks_vl',
7458: 'Visit_Task_ID = ' || p_task_rec.Visit_Task_ID
7459: ) = Fnd_Api.g_false
7460: THEN
7461: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN