DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on AHL_WORKORDER_OPERATIONS_V

Line 97: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP

93: OP.actual_start_date,
94: OP.actual_end_date,
95: OP.status_code,
96: OP.status
97: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP
98: WHERE WO.workorder_id = OP.workorder_id
99: AND OP.workorder_operation_id = p_workorder_operation_id;
100:
101: BEGIN

Line 129: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP

125: x_operation_rec.actual_start_date,
126: x_operation_rec.actual_end_date,
127: x_operation_rec.status_code,
128: x_operation_rec.status
129: FROM AHL_WORKORDERS WO, AHL_WORKORDER_OPERATIONS_V OP
130: WHERE WO.workorder_id = OP.workorder_id
131: AND OP.workorder_operation_id = p_workorder_operation_id;*/
132: -- fix for bug number 7295717 (Sunil)
133: OPEN get_op_details(p_workorder_operation_id);

Line 1401: FROM AHL_WORKORDER_OPERATIONS_V

1397: actual_start_date,
1398: actual_end_date,
1399: status_code,
1400: status
1401: FROM AHL_WORKORDER_OPERATIONS_V
1402: WHERE workorder_id = c_workorder_id;
1403:
1404: BEGIN
1405:

Line 9909: FROM AHL_WORKORDER_OPERATIONS_V

9905: SCHEDULED_START_DATE,
9906: SCHEDULED_END_DATE,
9907: ACTUAL_START_DATE,
9908: ACTUAL_END_DATE
9909: FROM AHL_WORKORDER_OPERATIONS_V
9910: WHERE WORKORDER_ID = x_workorder_id
9911: AND OPERATION_SEQUENCE_NUM = x_operation_seq_num;
9912:
9913: -- cursor to retrieve the wip_entity_id