APPS.AHL_PRD_OPERATIONS_PVT dependencies on AHL_OPERATIONS_B_KFV

Line 55: FROM AHL_OPERATIONS_B_KFV

51: AND TRUNC(NVL(OP.end_date_active,SYSDATE+1))
52: AND OP.revision_status_code='COMPLETE'
53: AND OP.revision_number IN
54: ( SELECT MAX(revision_number)
55: FROM AHL_OPERATIONS_B_KFV
56: WHERE concatenated_segments=OP.concatenated_segments
57: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active) AND
58: TRUNC(NVL(end_date_active,SYSDATE+1))
59: );

Line 627: AHL_OPERATIONS_B_KFV rop

623: SELECT
624: rop.concatenated_segments
625: FROM
626: AHL_WORKORDER_OPERATIONS wop,
627: AHL_OPERATIONS_B_KFV rop
628: WHERE
629: rop.operation_id = wop.operation_id
630: AND wop.workorder_operation_id = p_wo_op_id;
631:

Line 636: FROM AHL_OPERATIONS_B_KFV OP

632: -- cursor for getting latest revision of the operation
633: CURSOR get_operation(c_operation_code VARCHAR2)
634: IS
635: SELECT OP.operation_id
636: FROM AHL_OPERATIONS_B_KFV OP
637: WHERE OP.concatenated_segments=c_operation_code
638: AND OP.revision_number IN
639: ( SELECT MAX(OP1.revision_number)
640: FROM AHL_OPERATIONS_B_KFV OP1

Line 640: FROM AHL_OPERATIONS_B_KFV OP1

636: FROM AHL_OPERATIONS_B_KFV OP
637: WHERE OP.concatenated_segments=c_operation_code
638: AND OP.revision_number IN
639: ( SELECT MAX(OP1.revision_number)
640: FROM AHL_OPERATIONS_B_KFV OP1
641: WHERE OP1.concatenated_segments=OP.concatenated_segments
642: AND TRUNC(SYSDATE) BETWEEN TRUNC(OP1.start_date_active) AND
643: TRUNC(NVL(OP1.end_date_active,SYSDATE+1))
644: AND OP1.revision_status_code='COMPLETE'

Line 743: FROM AHL_OPERATIONS_B_KFV

739:
740: CURSOR get_operation(c_operation_code VARCHAR2)
741: IS
742: SELECT operation_id
743: FROM AHL_OPERATIONS_B_KFV
744: WHERE concatenated_segments=c_operation_code
745: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE))
746: AND TRUNC(NVL(end_date_active,SYSDATE+1))
747: AND revision_status_code='COMPLETE';