APPS.EAM_WO_COMP_UTILITY_PVT dependencies on EAM_JOB_COMPLETION_TXNS

Line 72: INSERT INTO EAM_JOB_COMPLETION_TXNS (

68:
69: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing insert row'); END IF;
70:
71: begin
72: INSERT INTO EAM_JOB_COMPLETION_TXNS (
73: transaction_id,
74: transaction_date,
75: transaction_type,
76: wip_entity_id,

Line 769: from EAM_JOB_COMPLETION_TXNS

765: into l_cmpl_sub,
766: l_locator,
767: l_lot
768:
769: from EAM_JOB_COMPLETION_TXNS
770: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
771: and transaction_type = 1
772: and transaction_date = (select max(transaction_date) from EAM_JOB_COMPLETION_TXNS
773: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id

Line 772: and transaction_date = (select max(transaction_date) from EAM_JOB_COMPLETION_TXNS

768:
769: from EAM_JOB_COMPLETION_TXNS
770: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
771: and transaction_type = 1
772: and transaction_date = (select max(transaction_date) from EAM_JOB_COMPLETION_TXNS
773: where wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
774: and transaction_type =1);
775:
776: x_inventory_item_rec.subinventory := l_cmpl_sub;