DBA Data[Home] [Help]

APPS.EAM_RES_INST_VALIDATE_PVT dependencies on MTL_SERIAL_NUMBERS

Line 356: from mtl_serial_numbers msn, bom_resource_equipments bre

352: if (p_eam_res_inst_rec.serial_number is not NULL) then
353:
354: select 1
355: into g_dummy
356: from mtl_serial_numbers msn, bom_resource_equipments bre
357: where msn.inventory_item_id = bre.inventory_item_id
358: and msn.current_organization_id = bre.organization_id
359: and bre.instance_id = p_eam_res_inst_rec.instance_id
360: and msn.serial_number = p_eam_res_inst_rec.serial_number;