328: FROM csm_mtl_system_items_acc msi_acc,
329: csm_inv_loc_ass_acc cila_acc,
330: csp_inv_loc_assignments cila,
331: mtl_item_sub_inventories mis,
332: csm_user_inventory_org uorg
333: WHERE msi_acc.inventory_item_id = mis.inventory_item_id
334: AND msi_acc.organization_id = mis.organization_id
335: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id
336: AND cila.subinventory_code = mis.secondary_inventory
384: FROM csm_mtl_system_items_acc msi_acc,
385: csm_inv_loc_ass_acc cila_acc,
386: csp_inv_loc_assignments cila,
387: mtl_item_sub_inventories mis,
388: csm_user_inventory_org uorg
389: WHERE msi_acc.inventory_item_id = mis.inventory_item_id
390: AND msi_acc.organization_id = mis.organization_id
391: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id
392: AND cila.subinventory_code = mis.secondary_inventory