DBA Data[Home] [Help]

APPS.EAM_WO_COMP_VALIDATE_PVT dependencies on MTL_SERIAL_NUMBERS

Line 538: mtl_serial_numbers msn

534: INTO l_serial_number ,
535: l_serial_status
536: FROM wip_discrete_jobs wdj,
537: csi_item_instances cii,
538: mtl_serial_numbers msn
539: WHERE wdj.wip_entity_id = p_eam_wo_comp_rec.wip_entity_id
540: AND wdj.maintenance_object_type = 3
541: AND wdj.maintenance_object_id = cii.instance_id
542: AND cii.serial_number = msn.serial_number