Oracle Ebs-sql (QA-1): Checks the inspection data beyond the inspection cycle. SQL

Select Msi.segment1 Material Code,
Msi. DESCRIPTION Material Description,
PER. Last_Name Buyer,
Msi. Full_lead_time lead time,
Msi. Fixed_order_quantity Fixed Order quantity,
Msi. Minimum_order_quantity Minimum Order quantity,
Msi. Fixed_days_supply Fixed days supply,
Msi. Fixed_lot_multiplier Fixed Batch Multiples
From Inv. Mtl_system_items_b MSI,

APPS. Per_people_f PER
where msi.organization_id = X and
Msi. Inventory_item_status_code not like ' Inactive ' and
Msi. Item_type = ' P ' and
(MSI. BUYER_ID is a NULL OR MSI. Full_lead_time is NULL OR
Msi. Minimum_order_quantity is NULL OR
Msi. Fixed_days_supply is a NULL OR MSI. Fixed_lot_multiplier is NULL) and
Msi. buyer_id = PER. PERSON_ID (+) and MSI. SEGMENT1 ' 1% '