INV - Sub Inventory Information

SELECT 
     sub.SECONDARY_INVENTORY_NAME Sub, 
     iop.organization_code invntory 
 FROM 
     inv_secondary_inventories sub, 
     inv_material_statuses_tl status, 
     fnd_lookup_values flv, 
     fnd_lookup_values flv1, 
     inv_org_parameters iop, 
     fnd_kf_str_instances_b str_b, 
     fnd_kf_str_instances_tl str_tl 
 WHERE 
     1=1 
     AND sub.status_id = status.status_id 
     AND sysdate > NVL(DISABLE_DATE, sysdate - 1) 
     AND status.LANGUAGE = USERENV('LANG') 
     AND flv.lookup_type = 'INV_SUB_TYPE' 
     AND flv.lookup_code = sub.subINVentory_type 
     AND NVL(flv.start_date_active, sysdate -1) <= SYSDATE 
     AND NVL(flv.end_date_active, sysdate +1) >= SYSDATE 
     AND flv.enabled_flag = 'Y' 
     AND flv.LANGUAGE = USERENV('LANG') 
     AND flv1.lookup_type = 'INV_SUB_LOCATOR_CONTROL' 
     AND flv1.lookup_code = sub.locator_type 
     AND NVL(flv1.start_date_active, sysdate -1) <= SYSDATE 
     AND NVL(flv1.end_date_active, sysdate +1) >= SYSDATE 
     AND flv1.enabled_flag = 'Y' 
     AND flv1.LANGUAGE = USERENV('LANG') 
     AND iop.organization_id = sub.organization_id 
     AND str_b.structure_instance_number = sub.structure_instance_number 
     AND str_tl.structure_instance_code = str_b.structure_instance_code 
     AND str_tl.LANGUAGE = USERENV('LANG') 
     AND iop.organization_id IN (:p_inv_org);