DBA Data[Home] [Help]

APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 603: from mtl_material_transactions_temp

599: if (p_eam_mat_req_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
600:
601: select count(*)
602: into l_count_mmtt
603: from mtl_material_transactions_temp
604: where transaction_source_id = p_eam_mat_req_rec.wip_entity_id
605: and organization_id = p_eam_mat_req_rec.organization_id
606: and operation_seq_num = p_eam_mat_req_rec.operation_seq_num
607: and inventory_item_id = p_eam_mat_req_rec.inventory_item_id;

Line 615: from mtl_material_transactions

611: end if;
612:
613: select count(*)
614: into l_count_mmt
615: from mtl_material_transactions
616: where transaction_source_id = p_eam_mat_req_rec.wip_entity_id
617: and organization_id = p_eam_mat_req_rec.organization_id
618: and operation_seq_num = p_eam_mat_req_rec.operation_seq_num
619: and inventory_item_id = p_eam_mat_req_rec.inventory_item_id;