334: AND asg.user_id = asg.owner_id
335: AND asg.user_id = acc.user_id
336: AND NOT EXISTS
337: (SELECT 1
338: FROM csm_mtl_onhand_qty_acc ohqacc
339: WHERE ohqacc.user_id = acc.user_id
340: AND ohqacc.inventory_item_id = cii.inventory_item_id
341: AND ohqacc.organization_id = cii.inv_organization_id
342: AND ohqacc.subinventory_code = cii.inv_subinventory_name
371: cqa.user_id,
372: cii.instance_id,
373: civ.version_label,
374: CIR.OBJECT_ID
375: FROM csm_mtl_onhand_qty_acc cqa
376: , csi_item_instances cii
377: , csi_instance_statuses iis
378: , asg_user asg
379: , csi_i_version_labels civ