APPS.AHL_UMP_BOM_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 991: FROM ahl_rt_oper_resources res,

987: FROM
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

Line 1034: FROM ahl_rt_oper_resources res,

1030: FROM
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

Line 1072: FROM ahl_rt_oper_resources res,

1068: FROM
1069: (SELECT DECODE(cost_basis_id, '1', duration*quantity*p_ii_qty, duration*quantity) resc_hrs,
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

Line 1096: FROM ahl_rt_oper_resources

1092: AND res.association_type_code = 'OPERATION'
1093: -- do an aggregrate if route has resources.
1094: AND NOT EXISTS
1095: (SELECT 'x'
1096: FROM ahl_rt_oper_resources
1097: WHERE association_type_code = 'ROUTE'
1098: AND object_id = r.route_id
1099: )
1100: -- Added by debadey for bug 13934412

Line 1133: FROM ahl_rt_oper_resources res,

1129: FROM
1130: (SELECT DECODE(cost_basis_id, '1', duration*quantity*p_ii_qty, duration*quantity) resc_hrs,
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

Line 1154: FROM ahl_rt_oper_resources

1150: AND res.association_type_code = 'OPERATION'
1151: -- do an aggregrate if route has resources.
1152: AND NOT EXISTS
1153: (SELECT 'x'
1154: FROM ahl_rt_oper_resources
1155: WHERE association_type_code = 'ROUTE'
1156: AND object_id = r.route_id
1157: )
1158: -- Added by debadey for bug 13934412

Line 1194: FROM ahl_rt_oper_resources res,

1190: FROM
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

Line 1227: FROM ahl_rt_oper_resources res,

1223: FROM
1224: (SELECT DECODE(cost_basis_id, '1', duration*quantity*p_ii_qty, duration*quantity) resc_hrs,
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

Line 1240: FROM ahl_rt_oper_resources

1236: AND res.association_type_code = 'OPERATION'
1237: -- do an aggregrate if route has resources.
1238: AND NOT EXISTS
1239: (SELECT 'x'
1240: FROM ahl_rt_oper_resources
1241: WHERE association_type_code = 'ROUTE'
1242: AND object_id = r.route_id
1243: )
1244: -- Added by debadey for bug 13934412