DBA Data[Home] [Help]

APPS.EAM_OP_COMP_VALIDATE_PVT dependencies on EAM_OP_COMPLETION_TXNS

Line 227: from eam_op_completion_txns eoct,wip_operation_networks won

223:
224: --added for fix to bug 3543834:
225: CURSOR CON3 IS
226: select nvl(max(actual_end_date),sysdate-20000)
227: from eam_op_completion_txns eoct,wip_operation_networks won
228: where eoct.wip_entity_id = p_eam_op_comp_rec.wip_entity_id
229: and eoct.operation_seq_num=won.prior_operation
230: and won.wip_entity_id=eoct.wip_entity_id
231: and won.next_operation=p_eam_op_comp_rec.operation_seq_num

Line 234: from eam_op_completion_txns

230: and won.wip_entity_id=eoct.wip_entity_id
231: and won.next_operation=p_eam_op_comp_rec.operation_seq_num
232: and transaction_type=1
233: and transaction_id = (select max(transaction_id)
234: from eam_op_completion_txns
235: where wip_entity_id = p_eam_op_comp_rec.wip_entity_id
236: and operation_seq_num = eoct.operation_seq_num
237: );
238: