APPS.EAM_OP_COMP_VALIDATE_PVT dependencies on WIP_OPERATIONS

Line 194: select 1 from wip_operations

190: where
191: won.wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
192: won.next_operation = p_eam_op_comp_rec.operation_seq_num and
193: exists (
194: select 1 from wip_operations
195: where
196: wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
197: operation_seq_num = won.prior_operation and
198: nvl(operation_completed,'N') <> 'Y'

Line 208: select 1 from wip_operations

204: where
205: won.wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
206: won.prior_operation = p_eam_op_comp_rec.operation_seq_num and
207: exists (
208: select 1 from wip_operations
209: where
210: wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
211: operation_seq_num = won.next_operation and
212: operation_completed = 'Y'

Line 449: FROM wip_operations

445: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
446: BEGIN
447: SELECT shutdown_type
448: INTO l_shutdown_type
449: FROM wip_operations
450: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id
451: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
452:
453: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;