119: OP.actual_start_date,
120: OP.actual_end_date,
121: OP.status_code,
122: OP.status
123: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP
124: WHERE WO.workorder_id = OP.workorder_id
125: AND OP.workorder_operation_id = p_workorder_operation_id;
126:
127: BEGIN
151: x_operation_rec.actual_start_date,
152: x_operation_rec.actual_end_date,
153: x_operation_rec.status_code,
154: x_operation_rec.status
155: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP
156: WHERE WO.workorder_id = OP.workorder_id
157: AND OP.workorder_operation_id = p_workorder_operation_id;*/
158: -- fix for bug number 7295717 (Sunil)
159: OPEN get_op_details(p_workorder_operation_id);
1458: actual_start_date,
1459: actual_end_date,
1460: status_code,
1461: status
1462: FROM AHL_WORKORDER_OPERATIONS_V
1463: WHERE workorder_id = c_workorder_id;
1464:
1465: BEGIN
1466:
10690: SCHEDULED_START_DATE,
10691: SCHEDULED_END_DATE,
10692: ACTUAL_START_DATE,
10693: ACTUAL_END_DATE
10694: FROM AHL_WORKORDER_OPERATIONS_V
10695: WHERE WORKORDER_ID = x_workorder_id
10696: AND OPERATION_SEQUENCE_NUM = x_operation_seq_num;
10697:
10698: -- cursor to retrieve the wip_entity_id