APPS.EAM_OP_COMP_VALIDATE_PVT dependencies on WIP_OPERATIONS

Line 149: FROM wip_operations

145:
146: --Added for bug 12843159
147: SELECT shutdown_type
148: INTO l_shutdown_type
149: FROM wip_operations
150: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id
151: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
152:
153: IF nvl(to_number(l_shutdown_type),1) = 2 THEN

Line 203: select 1 from wip_operations

199: where
200: won.wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
201: won.next_operation = p_eam_op_comp_rec.operation_seq_num and
202: exists (
203: select 1 from wip_operations
204: where
205: wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
206: operation_seq_num = won.prior_operation and
207: nvl(operation_completed,'N') <> 'Y'

Line 217: select 1 from wip_operations

213: where
214: won.wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
215: won.prior_operation = p_eam_op_comp_rec.operation_seq_num and
216: exists (
217: select 1 from wip_operations
218: where
219: wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
220: operation_seq_num = won.next_operation and
221: operation_completed = 'Y'

Line 458: FROM wip_operations

454: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
455: BEGIN
456: SELECT shutdown_type
457: INTO l_shutdown_type
458: FROM wip_operations
459: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id
460: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
461:
462: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;