APPS.AHL_VWP_RULES_PVT dependencies on AHL_MR_ROUTES_V

Line 1876: FROM AHL_MR_ROUTES_V T1,

1872:
1873: -- To find MR_ROUTE_ID for the particular MR_HEADER_ID
1874: CURSOR c_MR_route (x_mr_id IN NUMBER) IS
1875: SELECT T1.MR_ROUTE_ID
1876: FROM AHL_MR_ROUTES_V T1,
1877: AHL_ROUTES_B T2
1878: WHERE T1.MR_HEADER_ID = x_mr_id
1879: AND T1.ROUTE_ID = T2.ROUTE_ID
1880: AND T2.REVISION_STATUS_CODE = 'COMPLETE'

Line 1885: FROM AHL_MR_ROUTES_V T3

1881: -- Added as of Bug# 3562914
1882: -- By shbhanda 04/22/2004
1883: AND T1.ROUTE_REVISION_NUMBER
1884: IN ( SELECT MAX(T3.ROUTE_REVISION_NUMBER)
1885: FROM AHL_MR_ROUTES_V T3
1886: WHERE T3.MR_HEADER_ID = x_mr_id
1887: AND T3.ROUTE_NUMBER = T1.ROUTE_NUMBER
1888: GROUP BY T3.ROUTE_NUMBER
1889: );

Line 2201: FROM AHL_MR_ROUTES_V T1, AHL_ROUTES_B T2

2197: -- AnRaj: Changes made for fixing bug#4919353, issue# 10
2198: SELECT T1.MR_ROUTE_ID,
2199: -- Added for 11.5.10 Changes done by Senthil.
2200: T1.STAGE
2201: FROM AHL_MR_ROUTES_V T1, AHL_ROUTES_B T2
2202: WHERE T1.MR_HEADER_ID = x_mr_id
2203: AND T1.ROUTE_ID = T2.ROUTE_ID
2204: AND T2.REVISION_STATUS_CODE = 'COMPLETE'
2205: -- Added as of Bug# 3562914

Line 2209: FROM AHL_MR_ROUTES_V T3

2205: -- Added as of Bug# 3562914
2206: -- By shbhanda 04/22/2004
2207: AND T1.ROUTE_REVISION_NUMBER
2208: IN (SELECT MAX(T3.ROUTE_REVISION_NUMBER)
2209: FROM AHL_MR_ROUTES_V T3
2210: WHERE T3.MR_HEADER_ID = x_mr_id
2211: AND T3.ROUTE_NUMBER = T1.ROUTE_NUMBER
2212: GROUP BY T3.ROUTE_NUMBER
2213: );

Line 2493: FROM AHL_MR_ROUTES_V T1, AHL_ROUTES_B T2

2489: -- 11.5.10 Changes by Senthil.
2490: -- AnRaj: Changes made for fixing bug#4919353, issue# 11
2491: SELECT T1.MR_ROUTE_ID, T1.STAGE
2492: BULK COLLECT INTO MR_Route_Tbl,l_Stage_num_Tbl
2493: FROM AHL_MR_ROUTES_V T1, AHL_ROUTES_B T2
2494: WHERE T1.MR_HEADER_ID = l_MR_Id
2495: AND T1.ROUTE_ID = T2.ROUTE_ID
2496: AND T2.revision_status_code = 'COMPLETE'
2497: AND T1.ROUTE_REVISION_NUMBER IN

Line 2499: FROM AHL_MR_ROUTES_V T3

2495: AND T1.ROUTE_ID = T2.ROUTE_ID
2496: AND T2.revision_status_code = 'COMPLETE'
2497: AND T1.ROUTE_REVISION_NUMBER IN
2498: (SELECT MAX(T3.ROUTE_REVISION_NUMBER)
2499: FROM AHL_MR_ROUTES_V T3
2500: WHERE T3.MR_HEADER_ID = l_MR_Id
2501: AND T3.ROUTE_NUMBER = T1.ROUTE_NUMBER
2502: GROUP BY T3.ROUTE_NUMBER
2503: );

Line 3844: AHL_MR_ROUTES_V AMRR,

3840: --cursor to fetch warranty template associated at route
3841: CURSOR c_route_template (c_task_id IN NUMBER) IS
3842: SELECT ARV.WARRANTY_TEMPLATE_ID
3843: FROM AHL_VISIT_TASKS_VL ATSK,
3844: AHL_MR_ROUTES_V AMRR,
3845: AHL_ROUTES_B ARV
3846: WHERE ATSK.MR_ROUTE_ID = AMRR.MR_ROUTE_ID(+)
3847: AND AMRR.ROUTE_ID = ARV.ROUTE_ID (+)
3848: AND ATSK.VISIT_TASK_ID = c_task_id;