DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on AHL_WORKORDER_OPERATIONS_V

Line 123: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP

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

Line 155: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP

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);

Line 1462: FROM AHL_WORKORDER_OPERATIONS_V

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:

Line 10694: FROM AHL_WORKORDER_OPERATIONS_V

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