APPS.EAM_WORKORDERS_JSP dependencies on EAM_OP_COMPLETION_TXNS

Line 520: from eam_op_completion_txns eoct

516: if (p_transaction_type = 1) then -- added by dgupta
517: /* Fix for Bug 2100416 */
518: select nvl(max(actual_end_date), sysdate - 200000)
519: into l_max_compl_op_date
520: from eam_op_completion_txns eoct
521: where wip_entity_id = p_wip_entity_id
522: --fix for 3543834.added where clause so that the last completion date will be fetched if the operation is complete
523: and transaction_type=1
524: and transaction_id = (select max(transaction_id)

Line 525: from eam_op_completion_txns

521: where wip_entity_id = p_wip_entity_id
522: --fix for 3543834.added where clause so that the last completion date will be fetched if the operation is complete
523: and transaction_type=1
524: and transaction_id = (select max(transaction_id)
525: from eam_op_completion_txns
526: where wip_entity_id = p_wip_entity_id
527: and operation_seq_num = eoct.operation_seq_num
528: );
529: /* Fix for bug no:2730242 */

Line 532: from eam_op_completion_txns eoct

528: );
529: /* Fix for bug no:2730242 */
530: select nvl(min(actual_start_date), sysdate + 200000)
531: into l_min_compl_op_date
532: from eam_op_completion_txns eoct
533: where wip_entity_id = p_wip_entity_id
534: --fix for 3543834.added where clause so that the last completion date will be fetched if the operation is complete
535: and transaction_type=1
536: and transaction_id = (select max(transaction_id)

Line 537: from eam_op_completion_txns

533: where wip_entity_id = p_wip_entity_id
534: --fix for 3543834.added where clause so that the last completion date will be fetched if the operation is complete
535: and transaction_type=1
536: and transaction_id = (select max(transaction_id)
537: from eam_op_completion_txns
538: where wip_entity_id = p_wip_entity_id
539: and operation_seq_num = eoct.operation_seq_num
540: );
541:

Line 2831: from eam_op_completion_txns eoct

2827: begin
2828: --fix for 3543834.changed queries to fetch correct data
2829: select max(actual_end_date)
2830: into l_max_op_end_date
2831: from eam_op_completion_txns eoct
2832: where wip_entity_id = p_wip_entity_id
2833: and transaction_type=1
2834: and transaction_id = (select max(transaction_id)
2835: from eam_op_completion_txns

Line 2835: from eam_op_completion_txns

2831: from eam_op_completion_txns eoct
2832: where wip_entity_id = p_wip_entity_id
2833: and transaction_type=1
2834: and transaction_id = (select max(transaction_id)
2835: from eam_op_completion_txns
2836: where wip_entity_id = p_wip_entity_id
2837: and operation_seq_num = eoct.operation_seq_num
2838: );
2839:

Line 2842: from eam_op_completion_txns eoct

2838: );
2839:
2840: select min(actual_start_date)
2841: into l_min_op_start_date
2842: from eam_op_completion_txns eoct
2843: where wip_entity_id = p_wip_entity_id
2844: and transaction_type=1
2845: and transaction_id = (select max(transaction_id)
2846: from eam_op_completion_txns

Line 2846: from eam_op_completion_txns

2842: from eam_op_completion_txns eoct
2843: where wip_entity_id = p_wip_entity_id
2844: and transaction_type=1
2845: and transaction_id = (select max(transaction_id)
2846: from eam_op_completion_txns
2847: where wip_entity_id = p_wip_entity_id
2848: and operation_seq_num = eoct.operation_seq_num
2849: );
2850: