DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_OPERATIONS_B_KFV

Line 3483: FROM AHL_OPERATIONS_B_KFV OP1

3479: -- AND OP.revision_status_code='COMPLETE'
3480: AND RO.route_id=c_route_id
3481: AND OP.revision_number IN
3482: ( SELECT MAX(OP1.revision_number)
3483: FROM AHL_OPERATIONS_B_KFV OP1
3484: WHERE OP1.concatenated_segments=OP.concatenated_segments
3485: AND OP1.revision_status_code='COMPLETE'
3486: AND TRUNC(SYSDATE) BETWEEN TRUNC(OP1.start_date_active) AND
3487: TRUNC(NVL(OP1.end_date_active,SYSDATE+1))

Line 4664: FROM AHL_OPERATIONS_B_KFV OP1

4660: FROM AHL_OPERATIONS_VL OP
4661: WHERE OP.concatenated_segments=p_operation_code
4662: AND OP.revision_number IN
4663: ( SELECT MAX(OP1.revision_number)
4664: FROM AHL_OPERATIONS_B_KFV OP1
4665: WHERE OP1.concatenated_segments=OP.concatenated_segments
4666: AND TRUNC(SYSDATE) BETWEEN TRUNC(OP1.start_date_active) AND
4667: TRUNC(NVL(OP1.end_date_active,SYSDATE+1))
4668: AND OP1.revision_status_code='COMPLETE'