[Home] [Help]
2402: FROM ahl_rt_oper_resources WHERE
2403: ASSOCIATION_TYPE_CODE = G_OPER_ASSOC_TYPE
2404: /*LTP CHANGES FOR NONSCHEDULED RESOURCE REQUIREMENTS - sowsubra*/
2405: AND NVL(SCHEDULED_TYPE_ID,1) <> 2
2406: AND OBJECT_ID IN (SELECT OPERATION_ID FROM ahl_route_operations WHERE ROUTE_ID = c_route_id);
2407:
2408: CURSOR l_get_bom_resources_csr(c_aso_resource_id IN NUMBER,
2409: c_org_id IN NUMBER) IS
2410: SELECT BOM_RESOURCE_ID
2765:
2766: -- get only operations with latest revision
2767: CURSOR l_get_ops_count(p_route_id IN NUMBER) IS
2768: SELECT COUNT(ro.operation_id)
2769: FROM ahl_route_operations ro, AHL_OPERATIONS_VL OP
2770: WHERE OP.operation_id=RO.operation_id
2771: AND ro.ROUTE_ID = p_route_id
2772: AND OP.revision_number IN
2773: ( SELECT MAX(OP1.revision_number)
2785:
2786: -- get only operations with latest revision
2787: CURSOR l_get_rt_oper_csr(p_route_id IN NUMBER) IS
2788: SELECT RO.OPERATION_ID, RO.STEP
2789: FROM ahl_route_operations ro, AHL_OPERATIONS_VL OP
2790: WHERE OP.operation_id=RO.operation_id
2791: AND ro.ROUTE_ID = p_route_id
2792: AND OP.revision_number IN
2793: ( SELECT MAX(OP1.revision_number)
3958: x_duration OUT NOCOPY NUMBER
3959: ) IS
3960:
3961: CURSOR l_route_operations_csr(p_route_id IN NUMBER) IS
3962: SELECT OPERATION_ID FROM ahl_route_operations
3963: WHERE route_id = p_route_id;
3964:
3965: l_operation_id NUMBER;
3966: l_temp_duration NUMBER := 0;