APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_OPERATION_RESOURCES

Line 2471: FROM AHL_OPERATION_RESOURCES

2467: SELECT operation_resource_id,
2468: object_version_number,
2469: duration
2470:
2471: FROM AHL_OPERATION_RESOURCES
2472:
2473: WHERE workorder_operation_id = c_wo_oper_id
2474: AND resource_id = c_bom_resource_id;
2475:

Line 2480: FROM AHL_OPERATION_RESOURCES

2476: -- Cursor for getting maximum resource sequence number associated with a workorder operation
2477: CURSOR get_max_res_seq_csr (c_wo_oper_id NUMBER)
2478: IS
2479: SELECT max(resource_sequence_num)
2480: FROM AHL_OPERATION_RESOURCES
2481: WHERE workorder_operation_id = c_wo_oper_id;
2482:
2483: /* An Associative array for storing BOM resources corresponding to the CMRO resources.
2484: * Basic use is to aggregate the BOM resource durations in case more than 1 CMRO resource gives the same BOM resource.

Line 2716: FROM AHL_OPERATION_RESOURCES

2712: CURSOR get_oper_bom_res_csr (c_wo_operation_id NUMBER)
2713: IS
2714: SELECT operation_resource_id,
2715: object_version_number
2716: FROM AHL_OPERATION_RESOURCES
2717: WHERE workorder_operation_id = c_wo_operation_id;
2718:
2719: -- Cursor to check whether the workorder being processed is in allowable status
2720: CURSOR check_wo_status_cur (c_workorder_id IN NUMBER)