APPS.EAM_WORKORDERS_JSP dependencies on EAM_JOB_COMPLETION_TXNS

Line 492: from eam_job_completion_txns where transaction_type = 1

488: --Note: This is redundant as we are not using the actual start and end for
489: --uncompletion anywhere, but keeping for sake of consistency with forms
490: if (p_transaction_type = 2) then
491: select max(transaction_date) into l_max_tran_date
492: from eam_job_completion_txns where transaction_type = 1
493: and wip_entity_id = p_wip_entity_id;
494: select actual_start_date, actual_end_date into
495: l_actual_start_date, l_actual_end_date
496: from eam_job_completion_txns where transaction_date = l_max_tran_date

Line 496: from eam_job_completion_txns where transaction_date = l_max_tran_date

492: from eam_job_completion_txns where transaction_type = 1
493: and wip_entity_id = p_wip_entity_id;
494: select actual_start_date, actual_end_date into
495: l_actual_start_date, l_actual_end_date
496: from eam_job_completion_txns where transaction_date = l_max_tran_date
497: and wip_entity_id = p_wip_entity_id;
498: l_actual_duration := (l_actual_end_date - l_actual_start_date)* 24;
499: end if;
500:

Line 2834: from eam_job_completion_txns

2830: if (p_tx_type = 2) then --uncompletion
2831: x_msg_data := x_msg_data || 'Uncompletion: ';
2832: select actual_start_date, actual_end_date into
2833: x_start_date, x_end_date
2834: from eam_job_completion_txns
2835: where wip_entity_id = p_wip_entity_id
2836: and transaction_date = (
2837: select max(transaction_date)
2838: from eam_job_completion_txns where transaction_type = 1

Line 2838: from eam_job_completion_txns where transaction_type = 1

2834: from eam_job_completion_txns
2835: where wip_entity_id = p_wip_entity_id
2836: and transaction_date = (
2837: select max(transaction_date)
2838: from eam_job_completion_txns where transaction_type = 1
2839: and wip_entity_id = p_wip_entity_id);
2840: end if;
2841:
2842: IF(x_start_date > SYSDATE) THEN