[Home] [Help]
988: (SELECT DECODE(cost_basis_id, '1', duration*quantity*p_ii_qty, duration*quantity) resc_hrs,
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
1031: (SELECT DECODE(cost_basis_id, '1', duration*quantity*p_ii_qty, duration*quantity) resc_hrs,
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
1070: ASO_RESOURCE_ID,
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
1131: ASO_RESOURCE_ID,
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
1191: (SELECT DECODE(cost_basis_id, '1', duration*quantity*p_ii_qty, duration*quantity) resc_hrs,
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'
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
1234: AND res.object_id = rop.operation_id
1308: SELECT rt.mr_route_id,
1309: rt.route_id,
1310: R.start_date_active,
1311: R.end_date_active
1312: FROM ahl_mr_routes rt,
1313: ahl_routes_b R
1314: WHERE rt.route_id = r.route_id
1315: AND rt.mr_header_id = p_mr_header_id;
1316: