DBA Data[Home] [Help]

APPS.AHL_UMP_BOM_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 1073: ahl_route_operations rop,

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
1077: WHERE route.route_id = r.route_id

Line 1134: ahl_route_operations rop,

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
1138: WHERE route.route_id = r.route_id

Line 1228: ahl_route_operations rop,

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
1232: WHERE route.route_id = r.route_id