APPS.AHL_VWP_RULES_PVT dependencies on AHL_MR_ROUTES

Line 1160: FROM ahl_routes_vl ar, ahl_mr_routes mrr

1156: /*Bug 5758813 - rnahata - Route title and route remarks should be passed
1157: to visit as visit task name and visit task description*/
1158: CURSOR c_route_title(c_mr_route_id IN NUMBER) IS
1159: SELECT substr(ar.title,1,80), ar.remarks
1160: FROM ahl_routes_vl ar, ahl_mr_routes mrr
1161: WHERE mrr.mr_route_id = c_mr_route_id
1162: AND mrr.route_id = ar.route_id;
1163:
1164: -- Local variables defined for the procedure

Line 1645: FROM AHL_MR_ROUTES_V T1,

1641:
1642: -- To find MR_ROUTE_ID for the particular MR_HEADER_ID
1643: CURSOR c_MR_route (x_mr_id IN NUMBER) IS
1644: SELECT T1.MR_ROUTE_ID
1645: FROM AHL_MR_ROUTES_V T1,
1646: AHL_ROUTES_B T2
1647: WHERE T1.MR_HEADER_ID = x_mr_id
1648: AND T1.ROUTE_ID = T2.ROUTE_ID
1649: AND T2.REVISION_STATUS_CODE = 'COMPLETE'

Line 1654: FROM AHL_MR_ROUTES_V T3

1650: -- Added as of Bug# 3562914
1651: -- By shbhanda 04/22/2004
1652: AND T1.ROUTE_REVISION_NUMBER
1653: IN ( SELECT MAX(T3.ROUTE_REVISION_NUMBER)
1654: FROM AHL_MR_ROUTES_V T3
1655: WHERE T3.MR_HEADER_ID = x_mr_id
1656: AND T3.ROUTE_NUMBER = T1.ROUTE_NUMBER
1657: GROUP BY T3.ROUTE_NUMBER
1658: );

Line 1923: FROM AHL_MR_ROUTES_V T1, AHL_ROUTES_B T2

1919: -- AnRaj: Changes made for fixing bug#4919353, issue# 10
1920: SELECT T1.MR_ROUTE_ID,
1921: -- Added for 11.5.10 Changes done by Senthil.
1922: T1.STAGE
1923: FROM AHL_MR_ROUTES_V T1, AHL_ROUTES_B T2
1924: WHERE T1.MR_HEADER_ID = x_mr_id
1925: AND T1.ROUTE_ID = T2.ROUTE_ID
1926: AND T2.REVISION_STATUS_CODE = 'COMPLETE'
1927: -- Added as of Bug# 3562914

Line 1931: FROM AHL_MR_ROUTES_V T3

1927: -- Added as of Bug# 3562914
1928: -- By shbhanda 04/22/2004
1929: AND T1.ROUTE_REVISION_NUMBER
1930: IN (SELECT MAX(T3.ROUTE_REVISION_NUMBER)
1931: FROM AHL_MR_ROUTES_V T3
1932: WHERE T3.MR_HEADER_ID = x_mr_id
1933: AND T3.ROUTE_NUMBER = T1.ROUTE_NUMBER
1934: GROUP BY T3.ROUTE_NUMBER
1935: );

Line 2193: FROM AHL_MR_ROUTES_V T1, AHL_ROUTES_B T2

2189: -- 11.5.10 Changes by Senthil.
2190: -- AnRaj: Changes made for fixing bug#4919353, issue# 11
2191: SELECT T1.MR_ROUTE_ID, T1.STAGE
2192: BULK COLLECT INTO MR_Route_Tbl,l_Stage_num_Tbl
2193: FROM AHL_MR_ROUTES_V T1, AHL_ROUTES_B T2
2194: WHERE T1.MR_HEADER_ID = l_MR_Id
2195: AND T1.ROUTE_ID = T2.ROUTE_ID
2196: AND T2.revision_status_code = 'COMPLETE'
2197: AND T1.ROUTE_REVISION_NUMBER IN

Line 2199: FROM AHL_MR_ROUTES_V T3

2195: AND T1.ROUTE_ID = T2.ROUTE_ID
2196: AND T2.revision_status_code = 'COMPLETE'
2197: AND T1.ROUTE_REVISION_NUMBER IN
2198: (SELECT MAX(T3.ROUTE_REVISION_NUMBER)
2199: FROM AHL_MR_ROUTES_V T3
2200: WHERE T3.MR_HEADER_ID = l_MR_Id
2201: AND T3.ROUTE_NUMBER = T1.ROUTE_NUMBER
2202: GROUP BY T3.ROUTE_NUMBER
2203: );