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: WHERE concatenated_segments=c_operation_code
58: AND revision_status_code='COMPLETE'
59: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date_active) AND

Line 629: AHL_OPERATIONS_B_KFV rop

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

Line 638: FROM AHL_OPERATIONS_B_KFV OP

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

Line 642: FROM AHL_OPERATIONS_B_KFV OP1

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

Line 745: FROM AHL_OPERATIONS_B_KFV

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