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 AHL_MR_ROUTES

Line 1792: FROM ahl_routes_vl ar,ahl_visit_tasks_vl avt, ahl_mr_routes mrr

1788: SUBSTR(NVL(ar.title,avt.visit_task_name),1,250) description,
1789: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date, avt.visit_task_id,
1790: avt.end_date_time task_end_date, avt.task_type_code, avt.cost_parent_id, avt.service_type_code, avt.status_code -- PRAKKUM :: PIE :: 13-OCT-2010
1791: , avt.repair_batch_name --PRAKKUM :: 11/06/2012 :: Bug 14068468
1792: FROM ahl_routes_vl ar,ahl_visit_tasks_vl avt, ahl_mr_routes mrr
1793: WHERE avt.visit_id = p_visit_id
1794: AND NVL(avt.status_code,'Y') = 'PLANNING'
1795: 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
1796: AND avt.mr_route_id = mrr.mr_route_id (+)

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 4085: FROM AHL_MR_HEADERS_APP_V mrh1, AHL_MR_ROUTES mrr

4081:
4082: -- To find MR related Information
4083: CURSOR c_mr_header (c_id IN NUMBER) IS
4084: SELECT mrh1.effective_from,mrh1.effective_to
4085: FROM AHL_MR_HEADERS_APP_V mrh1, AHL_MR_ROUTES mrr
4086: WHERE mrh1.mr_status_code = 'COMPLETE' AND
4087: trunc(mrh1.effective_from) <= trunc(sysdate) AND
4088: trunc(nvl(mrh1.effective_to,sysdate)) >= trunc(sysdate) AND
4089: mrr.mr_route_id = c_id AND

Line 4103: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr

4099:
4100: -- To find Route related Information
4101: CURSOR c_route (c_id IN NUMBER) IS
4102: SELECT ra.*
4103: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr
4104: WHERE ra.route_id = mrr.route_id AND
4105: mrr.mr_route_id = c_id AND
4106: ra.revision_status_code = 'COMPLETE';
4107:

Line 4282: FROM AHL_MR_HEADERS_APP_V mrh1, AHL_MR_ROUTES mrr

4278:
4279: -- To find MR related Information
4280: CURSOR c_mr_header (c_id IN NUMBER) IS
4281: SELECT mrh1.effective_from,mrh1.effective_to
4282: FROM AHL_MR_HEADERS_APP_V mrh1, AHL_MR_ROUTES mrr
4283: WHERE mrh1.mr_status_code = 'COMPLETE' AND
4284: trunc(mrh1.effective_from) <= trunc(sysdate) AND
4285: trunc(nvl(mrh1.effective_to,sysdate)) >= trunc(sysdate) AND
4286: mrr.mr_route_id = c_id AND

Line 4300: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr

4296:
4297: -- To find Route related Information
4298: CURSOR c_route (c_id IN NUMBER) IS
4299: SELECT ra.*
4300: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr
4301: WHERE ra.route_id = mrr.route_id AND
4302: mrr.mr_route_id = c_id AND
4303: ra.revision_status_code = 'COMPLETE';
4304:

Line 4516: SELECT T1.* FROM AHL_MR_HEADERS_APP_V T1, AHL_MR_ROUTES_V T2

4512: -- AnRaj: Following two cursors have been changed due to performnace issues
4513: -- Bug Number 4919291
4514: -- To find MR header related information
4515: /* CURSOR c_mr_header (x_id IN NUMBER) IS
4516: SELECT T1.* FROM AHL_MR_HEADERS_APP_V T1, AHL_MR_ROUTES_V T2
4517: WHERE T1.MR_HEADER_ID = T2.MR_HEADER_ID
4518: AND T2.MR_ROUTE_ID = x_id;
4519: */
4520:

Line 4526: FROM AHL_MR_HEADERS_APP_V T1, AHL_MR_ROUTES_V T2

4522: -- bug fix#5209826
4523: /*
4524: CURSOR c_mr_header (x_id IN NUMBER) IS
4525: SELECT T1.EFFECTIVE_FROM,T1.EFFECTIVE_TO
4526: FROM AHL_MR_HEADERS_APP_V T1, AHL_MR_ROUTES_V T2
4527: WHERE T1.MR_HEADER_ID = T2.MR_HEADER_ID
4528: AND T2.MR_ROUTE_ID = x_id;
4529: */
4530: CURSOR c_mr_header (x_id IN NUMBER) IS

Line 4532: FROM ahl_mr_headers_app_v T1, AHL_MR_ROUTES_V T2

4528: AND T2.MR_ROUTE_ID = x_id;
4529: */
4530: CURSOR c_mr_header (x_id IN NUMBER) IS
4531: SELECT T1.EFFECTIVE_FROM,T1.EFFECTIVE_TO
4532: FROM ahl_mr_headers_app_v T1, AHL_MR_ROUTES_V T2
4533: WHERE T1.mr_status_code = 'COMPLETE' AND
4534: trunc(T1.effective_from) <= trunc(sysdate) AND
4535: trunc(nvl(T1.effective_to,sysdate)) >= trunc(sysdate) AND
4536: T2.MR_ROUTE_ID = x_id AND

Line 4551: SELECT T1.* FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2

4547: c_mr_header_rec c_mr_header%ROWTYPE;
4548:
4549: -- To find route related information
4550: /* CURSOR c_route (x_id IN NUMBER) IS
4551: SELECT T1.* FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2
4552: WHERE T1.ROUTE_ID = T2.ROUTE_ID
4553: AND T2.MR_ROUTE_ID = x_id
4554: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
4555: */

Line 4558: FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2

4554: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
4555: */
4556: CURSOR c_route (x_id IN NUMBER) IS
4557: SELECT T1.START_DATE_ACTIVE,T1.END_DATE_ACTIVE
4558: FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2
4559: WHERE T1.ROUTE_ID = T2.ROUTE_ID
4560: AND T2.MR_ROUTE_ID = x_id
4561: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
4562: c_route_rec c_route%ROWTYPE;

Line 4578: FROM AHL_MR_ROUTES T1, AHL_ROUTES_APP_V T2, AHL_MR_HEADERS_APP_V B

4574: AND NVL(STATUS_CODE,'X') not in ('DELETED','RELEASED','CLOSED')
4575: AND VT.MR_Route_ID IS NOT NULL
4576: AND NOT EXISTS (
4577: SELECT 1
4578: FROM AHL_MR_ROUTES T1, AHL_ROUTES_APP_V T2, AHL_MR_HEADERS_APP_V B
4579: WHERE T1.MR_ROUTE_ID = VT.MR_ROUTE_ID
4580: AND T1.MR_HEADER_ID = B.MR_HEADER_ID
4581: AND T1.ROUTE_ID = T2.ROUTE_ID
4582: AND T2.REVISION_STATUS_CODE = 'COMPLETE');

Line 4601: SELECT count(*) FROM Ahl_MR_Items_V T1, AHL_MR_ROUTES_APP_V T2

4597: /* commented out for bug fix 4081044
4598: yazhou 03-Jan-2005
4599: -- To find count for Item and MR Header ID
4600: CURSOR c_check (x_item_id IN NUMBER, x_mr_route_id IN NUMBER) IS
4601: SELECT count(*) FROM Ahl_MR_Items_V T1, AHL_MR_ROUTES_APP_V T2
4602: WHERE T1.Inventory_Item_ID = x_item_id
4603: AND T1.MR_HEADER_ID = T2.MR_HEADER_ID
4604: AND MR_ROUTE_ID = x_mr_route_id;
4605: */

Line 6161: SELECT Route_Id FROM AHL_MR_ROUTES_V

6157: /* End Changes by Shkalyan */
6158:
6159: -- To find Route Id from MR Routes view
6160: CURSOR c_route (x_id IN NUMBER) IS
6161: SELECT Route_Id FROM AHL_MR_ROUTES_V
6162: WHERE MR_ROUTE_ID = x_id;
6163:
6164: /* Begin Changes by Shkalyan */
6165: -- To find job for task

Line 6269: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr

6265: CURSOR get_wo_dtls_for_mrtasks_cur (p_task_id IN NUMBER) IS
6266: --TCHIMIRA::Bug 9149770 ::09-FEB-2010
6267: --use substrb and lengthb instead of substr and length respectively
6268: SELECT ar.route_no||'.'||substrb(ar.title,1,(240 - (lengthb(ar.route_no) + 1))) workorder_description
6269: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr
6270: WHERE avt.visit_task_id = p_task_id
6271: AND nvl(avt.status_code,'Y') = 'PLANNING'
6272: AND avt.mr_route_id = mrr.mr_route_id
6273: AND mrr.route_id = ar.route_id;

Line 9314: SELECT Route_Id FROM AHL_MR_ROUTES_V

9310: CONNECT BY originating_task_id = PRIOR visit_task_id;
9311:
9312: --find Route Id from MR Routes view
9313: CURSOR c_route (x_id IN NUMBER) IS
9314: SELECT Route_Id FROM AHL_MR_ROUTES_V
9315: WHERE MR_ROUTE_ID = x_id;
9316:
9317: --check if the visit master wo exists
9318: CURSOR c_fet_mas_wo_dtls (x_visit_id IN NUMBER) IS

Line 9342: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr

9338: CURSOR get_wo_dtls_for_mrtasks_cur (p_task_id IN NUMBER) IS
9339: --TCHIMIRA::Bug 9149770 ::09-FEB-2010
9340: --use substrb and lengthb instead of substr and length respectively
9341: SELECT ar.route_no||'.'||substrb(ar.title,1,(240 - (lengthb(ar.route_no) + 1))) workorder_description
9342: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr
9343: WHERE avt.visit_task_id = p_task_id
9344: and nvl(avt.status_code,'Y') = 'PLANNING'
9345: and avt.mr_route_id = mrr.mr_route_id
9346: and mrr.route_id = ar.route_id;

Line 11193: SELECT Route_Id FROM AHL_MR_ROUTES_V

11189: CONNECT BY originating_task_id = PRIOR visit_task_id;
11190:
11191: -- To find Route Id from MR Routes view
11192: CURSOR c_route (x_id IN NUMBER) IS
11193: SELECT Route_Id FROM AHL_MR_ROUTES_V
11194: WHERE MR_ROUTE_ID = x_id;
11195:
11196: --To get summary task start, end time
11197: CURSOR get_summary_task_times_csr(x_task_id IN NUMBER)IS

Line 11244: ahl_mr_routes mrr

11240: --TCHIMIRA::Bug 9149770 ::09-FEB-2010
11241: --use substrb and lengthb instead of substr and length respectively
11242: SELECT ar.route_no||'.'||SUBSTRB(ar.title, 1, (240 - (LENGTHB(ar.route_no) + 1))) workorder_description
11243: FROM ahl_routes_vl ar, ahl_visit_tasks_b avt,
11244: ahl_mr_routes mrr
11245: WHERE avt.visit_task_id = c_visit_task_id
11246: AND NVL(avt.status_code, 'X') = 'PLANNING'
11247: AND avt.mr_route_id = mrr.mr_route_id
11248: AND mrr.route_id = ar.route_id;

Line 11859: ahl_mr_routes mrr

11855: CURSOR get_prj_task_dtls_cur (c_visit_task_id IN NUMBER) IS
11856: SELECT SUBSTR(NVL(ar.route_no, avt.visit_task_name), 1, 20) task_name,
11857: SUBSTR(NVL(ar.title, avt.visit_task_name), 1, 250) description
11858: FROM ahl_routes_vl ar, ahl_visit_tasks_vl avt,
11859: ahl_mr_routes mrr
11860: WHERE avt.visit_task_id = c_visit_task_id
11861: AND NVL(avt.status_code, 'X') = 'PLANNING'
11862: AND avt.task_type_code NOT IN ('SUMMARY', 'UNASSOCIATED')
11863: AND avt.mr_route_id = mrr.mr_route_id (+)

Line 13035: SELECT Route_Id FROM AHL_MR_ROUTES_V

13031: l_visit_end_time DATE;
13032: --
13033: -- To find count for tasks for visit
13034: CURSOR c_route (x_id IN NUMBER) IS
13035: SELECT Route_Id FROM AHL_MR_ROUTES_V
13036: WHERE MR_ROUTE_ID = x_id;
13037:
13038: -- To find visit related information
13039: CURSOR c_visit (x_id IN NUMBER) IS

Line 14549: SELECT Route_Id FROM AHL_MR_ROUTES_V

14545: CONNECT BY originating_task_id = PRIOR visit_task_id;
14546:
14547: --find Route Id from MR Routes view
14548: CURSOR c_route (c_mr_route_id IN NUMBER) IS
14549: SELECT Route_Id FROM AHL_MR_ROUTES_V
14550: WHERE MR_ROUTE_ID = c_mr_route_id;
14551:
14552: --Inventory item id and instance id to be defaulted when
14553: --the item and instance are not specified at the header level

Line 14564: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr

14560: --Fetches the route information for updating workorder
14561: --description for tasks created from Routes
14562: CURSOR get_wo_dtls_for_mrtasks_cur (p_task_id IN NUMBER) IS
14563: SELECT ar.route_no||'.'||substrb(ar.title,1,(240 - (lengthb(ar.route_no) + 1))) workorder_description
14564: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr
14565: WHERE avt.visit_task_id = p_task_id
14566: and nvl(avt.status_code,'Y') = 'PLANNING'
14567: and avt.mr_route_id = mrr.mr_route_id
14568: and mrr.route_id = ar.route_id;