165: AND TRUNC(NVL(disable_date, SYSDATE + 1)) > TRUNC(SYSDATE)
166: AND NVL(subinventory_type, 1) = 1
167: AND(( msi.planning_level = 2
168: AND EXISTS(SELECT 1
169: FROM mtl_item_sub_inventories mis
170: WHERE mis.organization_id = msi.organization_id
171: AND mis.secondary_inventory = msi.secondary_inventory_name
172: )
173: )
427: AND msik.stock_enabled_flag = 'Y'
428: AND msik.concatenated_segments LIKE p_item
429: AND ((p_locator_id IS NULL
430: AND EXISTS(SELECT 1
431: FROM mtl_item_sub_inventories mis
432: , mtl_replenish_lines mrl
433: WHERE mis.organization_id = msik.organization_id
434: AND mis.secondary_inventory = p_subinventory
435: AND mis.inventory_item_id = msik.inventory_item_id