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 2800: from eam_op_completion_txns eoct

2796: begin
2797: --fix for 3543834.changed queries to fetch correct data
2798: select max(actual_end_date)
2799: into l_max_op_end_date
2800: from eam_op_completion_txns eoct
2801: where wip_entity_id = p_wip_entity_id
2802: and transaction_type=1
2803: and transaction_id = (select max(transaction_id)
2804: from eam_op_completion_txns

Line 2804: from eam_op_completion_txns

2800: from eam_op_completion_txns eoct
2801: where wip_entity_id = p_wip_entity_id
2802: and transaction_type=1
2803: and transaction_id = (select max(transaction_id)
2804: from eam_op_completion_txns
2805: where wip_entity_id = p_wip_entity_id
2806: and operation_seq_num = eoct.operation_seq_num
2807: );
2808:

Line 2811: from eam_op_completion_txns eoct

2807: );
2808:
2809: select min(actual_start_date)
2810: into l_min_op_start_date
2811: from eam_op_completion_txns eoct
2812: where wip_entity_id = p_wip_entity_id
2813: and transaction_type=1
2814: and transaction_id = (select max(transaction_id)
2815: from eam_op_completion_txns

Line 2815: from eam_op_completion_txns

2811: from eam_op_completion_txns eoct
2812: where wip_entity_id = p_wip_entity_id
2813: and transaction_type=1
2814: and transaction_id = (select max(transaction_id)
2815: from eam_op_completion_txns
2816: where wip_entity_id = p_wip_entity_id
2817: and operation_seq_num = eoct.operation_seq_num
2818: );
2819: