DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 3477: AHL_ROUTE_OPERATIONS RO

3473: OP.concatenated_segments,
3474: OP.operation_type_code,
3475: OP.description
3476: FROM AHL_OPERATIONS_VL OP,
3477: AHL_ROUTE_OPERATIONS RO
3478: WHERE OP.operation_id=RO.operation_id
3479: -- AND OP.revision_status_code='COMPLETE'
3480: AND RO.route_id=c_route_id
3481: AND OP.revision_number IN

Line 3639: AHL_ROUTE_OPERATIONS ARO

3635: (Select ARO.route_operation_id,
3636: AWO.operation_sequence_num
3637:
3638: From AHL_WORKORDER_OPERATIONS AWO,
3639: AHL_ROUTE_OPERATIONS ARO
3640:
3641: Where AWO.workorder_id = c_workorder_id
3642: AND AWO.operation_id = ARO.operation_id
3643: AND ARO.route_id = c_route_id