3588: ELSE
3589: -- Bug 9146725
3590: SELECT reservable_type
3591: INTO l_reservable_type
3592: FROM mtl_secondary_inventories
3593: WHERE organization_id = l_mmtt_rec.organization_id
3594: AND secondary_inventory_name = to_char(l_mmtt_rec.transfer_subinventory);
3595: g_is_sub_reservable(l_hash_value).reservable_type := l_reservable_type;
3596: g_is_sub_reservable(l_hash_value).org_id := l_mmtt_rec.organization_id;
5703: l_reservable_type := g_is_sub_reservable(l_hash_value).reservable_type;
5704: ELSE
5705: SELECT reservable_type
5706: INTO l_reservable_type
5707: FROM mtl_secondary_inventories
5708: WHERE organization_id = l_mmtt_rec.organization_id
5709: AND secondary_inventory_name = l_mmtt_rec.transfer_subinventory;
5710: g_is_sub_reservable(l_hash_value).reservable_type := l_reservable_type;
5711: g_is_sub_reservable(l_hash_value).org_id := l_mmtt_rec.organization_id;