bos 查询出物料基本类别是xx的所有物料内码

原创

晴天MZ 2023-02-28 15:05:03 博主文章分类：ORACLE ©著作权

©著作权归作者所有：来自51CTO博客作者晴天MZ的原创作品，请联系作者获取转载授权，否则将追究法律责任

select * from  T_BD_Material 


select    FID  from T_BD_MaterialGroup   where FPARENTID='10YAAAAARc3Hn8BC'

 
select * from     T_BD_MaterialGroupDetial      where      FMATERIALGROUPID='10YAAAAARc3Hn8BC'   


//查询出物料基本类别是xx的所有物料内码

select  FMATERIALID  from T_BD_MaterialGroupDetial where FMATERIALGROUPSTANDARDID='dR8lnQEPEADgAAWKwKgSxZeb4R8='  and  FMATERIALGROUPID   in (   
select    FID  from T_BD_MaterialGroup   where FPARENTID='10YAAAAARc3Hn8BC')

=======================================================================================

 select * from  T_BD_Material 
 
select  fid   from T_BD_MaterialGroupStandard where  FNUMBER='17'

 select  fid   from T_BD_MaterialGroup  where FGROUPSTANDARD=(select  fid   from T_BD_MaterialGroupStandard where  FNUMBER='17')  and FLEVEL='1' 
 
  select   *   from T_BD_MaterialGroup  where FGROUPSTANDARD=(select  fid   from T_BD_MaterialGroupStandard where  FNUMBER='17')  and FLEVEL='1' 

//查找物料分类标准编码为17的物料类别为15的所有下级类别
  select   *   from T_BD_MaterialGroup  where FPARENTID =(   select   fid  from T_BD_MaterialGroup  where FGROUPSTANDARD=(select  fid   from T_BD_MaterialGroupStandard where  FNUMBER='17')  and FLEVEL='1'   and FNUMBER='15' )
 
 
 // 查找物料分类标准编码为17的物料类别为15的所有下级类别的所有物料
select   *   from T_BD_MaterialGroupDetial  where FMATERIALGROUPSTANDARDID= ( select  fid   from T_BD_MaterialGroupStandard where  FNUMBER='17')  and FMATERIALGROUPID in (
   select   fid  from T_BD_MaterialGroup  where FPARENTID =(   select   fid  from T_BD_MaterialGroup  where FGROUPSTANDARD=(select  fid   from T_BD_MaterialGroupStandard where  FNUMBER='17')  and FLEVEL='1'   and FNUMBER='15' )
)