Oracle Ebs-sql (BOM-10): Check for data with BOM Planner. SQL

Tag:des   c   code   a   com    Data    

Select DISTINCT
     msi.segment1  encode
   , msi.description Description
   , msi.item_type item type
   , msi.inventory_item_status_code status
    , Msi.planner_code Planner
from
      INV. Mtl_system_items_b MSI
    , apps. Bom_bill_of_materials BOM
     ,apps. Bom_inventory_components Bic
where
     msi.organization_id=x
  --and   Msi.inventory_item_status_code = ' Active '
    and BOM. Organization_id=x
    bom.assembly_item_id=msi.inventory_item_id
    and bom.bill_sequence_id=bic.bill_sequence_id
    and Bic. Disable_date is null
    and  msi.item_type in (' FG ', ' SA ')
    and Msi.planner_code is null
ORDER by Msi.segment1