[Home] [Help]
989: ASO_RESOURCE_ID,
990: duration
991: FROM ahl_rt_oper_resources res,
992: ahl_mr_routes r,
993: ahl_routes_v route
994: WHERE r.route_id = res.object_id
995: AND r.mr_header_id IN
996: (SELECT mr.mr_header_id
997: FROM ahl_mr_headers_b mr,
1010: AND TRUNC(SYSDATE) BETWEEN TRUNC(route.start_date_active) AND
1011: TRUNC(NVL(route.end_date_active,SYSDATE+1))
1012: AND route.revision_number IN
1013: (SELECT MAX(revision_number)
1014: FROM ahl_routes_v rv
1015: WHERE route.route_no = rv.route_no
1016: AND revision_status_code = 'COMPLETE'
1017: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active) AND
1018: TRUNC(NVL(end_date_active,SYSDATE+1) ))
1032: ASO_RESOURCE_ID,
1033: duration
1034: FROM ahl_rt_oper_resources res,
1035: ahl_mr_routes r,
1036: ahl_routes_v route
1037: WHERE r.route_id = res.object_id
1038: AND r.mr_header_id IN
1039: (SELECT mr.mr_header_id
1040: FROM ahl_mr_headers_b mr,
1050: AND TRUNC(SYSDATE) BETWEEN TRUNC(route.start_date_active) AND
1051: TRUNC(NVL(route.end_date_active,SYSDATE+1))
1052: AND route.revision_number IN
1053: (SELECT MAX(revision_number)
1054: FROM ahl_routes_v rv
1055: WHERE route.route_no = rv.route_no
1056: AND revision_status_code = 'COMPLETE'
1057: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active) AND
1058: TRUNC(NVL(end_date_active,SYSDATE+1) ))
1071: duration
1072: FROM ahl_rt_oper_resources res,
1073: ahl_route_operations rop,
1074: ahl_mr_routes r,
1075: ahl_routes_v route,
1076: ahl_operations_vl op
1077: WHERE route.route_id = r.route_id
1078: AND r.route_id = rop.route_id
1079: AND res.object_id = rop.operation_id
1112: )
1113: -- End of changes b debadey for bug 13934412
1114: AND route.revision_number IN
1115: (SELECT MAX(revision_number)
1116: FROM ahl_routes_v rv
1117: WHERE route.route_no = rv.route_no
1118: AND revision_status_code = 'COMPLETE'
1119: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active) AND
1120: TRUNC(NVL(end_date_active,SYSDATE+1) ))
1132: duration
1133: FROM ahl_rt_oper_resources res,
1134: ahl_route_operations rop,
1135: ahl_mr_routes r,
1136: ahl_routes_v route,
1137: ahl_operations_vl op
1138: WHERE route.route_id = r.route_id
1139: AND r.route_id = rop.route_id
1140: AND res.object_id = rop.operation_id
1170: )
1171: -- End of changes by debadey for bug 13934412
1172: AND route.revision_number IN
1173: (SELECT MAX(revision_number)
1174: FROM ahl_routes_v rv
1175: WHERE route.route_no = rv.route_no
1176: AND revision_status_code = 'COMPLETE'
1177: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active)
1178: AND TRUNC(NVL(end_date_active,SYSDATE+1) ))
1192: ASO_RESOURCE_ID,
1193: duration
1194: FROM ahl_rt_oper_resources res,
1195: ahl_mr_routes r,
1196: ahl_routes_v route
1197: WHERE r.route_id = res.object_id
1198: AND r.mr_header_id = p_mr_header_id
1199: AND res.association_type_code = 'ROUTE'
1200: -- start of changes by debadey for bug 13934412
1203: AND TRUNC(SYSDATE) BETWEEN TRUNC(route.start_date_active) AND
1204: TRUNC(NVL(route.end_date_active,SYSDATE+1))
1205: AND route.revision_number IN
1206: (SELECT MAX(revision_number)
1207: FROM ahl_routes_v rv
1208: WHERE route.route_no = rv.route_no
1209: AND revision_status_code = 'COMPLETE'
1210: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active) AND
1211: TRUNC(NVL(end_date_active,SYSDATE+1) ))
1225: ASO_RESOURCE_ID,
1226: duration
1227: FROM ahl_rt_oper_resources res,
1228: ahl_route_operations rop,
1229: ahl_routes_v route,
1230: ahl_mr_routes r,
1231: ahl_operations_vl op
1232: WHERE route.route_id = r.route_id
1233: AND r.route_id = rop.route_id
1256: )
1257: -- End of changes b debadey for bug 13934412
1258: AND route.revision_number IN
1259: (SELECT MAX(revision_number)
1260: FROM ahl_routes_v rv
1261: WHERE route.route_no = rv.route_no
1262: AND revision_status_code = 'COMPLETE'
1263: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active)
1264: AND TRUNC(NVL(end_date_active,SYSDATE+1) ))